Open the Excel file in Excel. You can use this file as is without any further programming or you can modify it according to your organization's requirements.A sample Python application is available that:The following information will be downloaded:To filter the search results so that only selected records are downloaded, follow these steps: Multiple API requests can be combined in a single batch request. On the Settings tab, paste your API key into the API key field. Wild Apricot provides 2 separate APIs – an admin API that you can use retrieve or update data stored in your Wild Apricot database, and a member API you can use to create apps for your members.Currently, the limits on the number API request per minute are:The version number of the Wild Apricot API is included in the API call to allow existing applications to function after new versions are released.The same application could retrieve data from an external database and use it to update your Wild Apricot database.The retrieved data can be backed up, used to update another database, displayed on a web page, or passed onto another program for further processing or reporting. The Excel file provides parameters that you can set to filter the results. • Example • Response fields • Sample response. You can set up a Google Spreadsheet to retrieve and update information from your Wild Apricot database using Wild Apricot's API. The default format is JSON.For example, you could use Wild Apricot's API to:You can compress the response by including the following field in the HTTP header:To specify the response format, include the following field in the HTTP header:You should keep the following in mind when you transition your application from Version 1 of the Wild Apricot's API to Version 2.An API – Application Programming Interface – is a set of functions that allow programs to interact with each other. For example, you could use Wild Apricot's API to: Create an Excel file that retrieves all your contacts with a single click and automatically generates a report or a chart. Wild Apricot's API is intended for use by developers with technical expertise. Log into your Wild Apricot account as an administrator, find your API key, and copy it to the clipboard. GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together. Dismiss Join GitHub today. To do so, follow these steps:A sample Visual Studio project is available that performs the following functions using Version 2 of Wild Apricot's API.To help get you started with Wild Apricot's API, we have provided a sample Windows Excel file that uses API calls – programmed with Visual Basic – to download contact records and other information from a Wild Apricot account. If you need assistance, we provide support via email or through our Developers forum. To set up a sample spreadsheet that retrieves account details, follow these steps:Your search results will now be displayed on the Contacts tab using only the selected fields.Visual Basic for Applications will open, and display the DownloadButton macro.You can filter the search results so that only selected records are downloaded. Results from Wild Apricot API calls can be returned in either JSON (JavaScript Object Notation) or XML (Extensible Markup Language) formats. If you encounter errors opening the file, enable macros for this file or in your Excel options.