Add an API for Opportunity Applications

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.

  • Jordan Martinez
  • Dec 1 2020
  • Already exists
Client Name "shard name" calbaptist
User System Admin , Opportunity Admin
Functional Unit API
Employee Name Jordan
  • Attach files
  • Jordan Martinez commented
    December 02, 2020 18:56

    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."

  • Admin
    Carrie Goldberger commented
    December 02, 2020 14:20

    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.