I need to download all opportunity-specific applications. The only way to do this is to open each Opportunity's list of applications and click the download button. This is very tedious and time consuming.
I can't use the General Applications download this data because it will not include opportunity-specific questions. I can't use the Encumbered Funds or Fund Disbursements to download everything because I need to do this before we make awards.
If there was an API for downloading Opportunity Applications, I could download all of them very quickly
While it would be nice to have a way to upload information via this same API, it's not my main concern here.
Client Name "shard name" | calbaptist |
User | System Admin , Opportunity Admin |
Functional Unit | API |
Employee Name | Jordan |
Hi Carrie,
I explored this API previously and thought it only included fields found in the General Application. I looked at it again due to your comment and see that isn't the case. Not sure whether a change was made or whether I just overlooked that. Thanks for the update!
However, when I did try using that API, it seems your server timed out before it could send me the data. I've already opened a BB case for it, but I thought I would share it here, too.
Here was the command I used to get the data where "MY_TOKEN" was replaced with its secret value:
curl.exe --connect-timeout 180 --globoff --output applications_page_1.json "https://calbaptist.academicworks.com/api/v1/applications.json?token=MY_TOKEN&per_page=1000&c[]=opportunity_id__eq__1750__eq__1654__eq__1699__eq__1873__eq__1915__eq__2081__eq__1774__eq__1828__eq__1729__eq__1618__eq__1690__eq__1954__eq__1717__eq__1591__eq__1759__eq__1909__eq__1973__eq__1744__eq__1864__eq__1979__eq__1741__eq__1804__eq__1552__eq__1549__eq__1705__eq__1576__eq__1711__eq__1822__eq__1807__eq__1951__eq__1537__eq__1849__eq__2030__eq__1582__eq__1921__eq__1747__eq__1693__eq__1900__eq__1825__eq__1687__eq__1906__eq__1795__eq__1555__eq__2050__eq__2053__eq__1720__eq__2018__eq__1976__eq__1609__eq__1930__eq__1819__eq__1798__eq__1714__eq__1696__eq__1885__eq__1985__eq__1780__eq__1948__eq__1882__eq__1840__eq__1792__eq__1831__eq__1597__eq__1684__eq__1982__eq__1861__eq__1708__eq__1594__eq__1988__eq__2066__eq__1624__eq__1678__eq__1663__eq__1813__eq__1846__eq__1585__eq__1762__eq__1786__eq__1669__eq__1936__eq__1858__eq__1991__eq__1997__eq__1732__eq__1918__eq__1927__eq__2063__eq__1933__eq__1642__eq__1783__eq__1894__eq__1939__eq__1852__eq__1756__eq__1735__eq__1765__eq__1994__eq__1945__eq__1837__eq__2000__eq__2036__eq__1879__eq__1540__eq__1723__eq__1753__eq__1672__eq__1567__eq__1639__eq__1834__eq__1633__eq__1855__eq__1777__eq__1588__eq__1963__eq__2069__eq__1789__eq__2033__eq__2003__eq__1738__eq__1702__eq__1564__eq__1870__eq__1924__eq__2075__eq__1957__eq__1645__eq__1570__eq__1636__eq__1621__eq__1960__eq__1579__eq__1726__eq__1897__eq__1681__eq__2024__eq__2006__eq__2078__eq__2072__eq__2015__eq__1543__eq__2012__eq__1603__eq__1651__eq__2056__eq__1660__eq__2059__eq__2009__eq__1612__eq__1888__eq__1630__eq__1675__eq__1561__eq__1648__eq__1627__eq__1867__eq__1891__eq__1558__eq__1969__eq__1666__eq__1942__eq__2021__eq__1903__eq__1768__eq__1876__eq__1810__eq__2040__eq__1843__eq__1600__eq__1771__eq__1816__eq__1801__eq__1573__eq__1912__eq__1966__eq__2027__eq__1657__eq__1615__eq__1606&page=1"
I tried attaching the outputted file, but it doesn't seem like this form allows me to upload JSON. Regardless, the content it returned was not JSON but HTML that says:
"Something Went Wrong
We're sorry, the page is taking too long to load.
Please try refreshing the page, and contact support if the problem continues."
Hi Jordan,
We have an Applications API which will allow you to download applications from specific Opportunities. You can find the documentation on this API in your site by going to Site > Settings > Import & Export Tools and then scrolling down to API Documentation. This API has a few different filter options, including by Opportunity IDs.