Create a custom request

For quick, helpful support: [email protected]
Custom requests give you control over the request URL, headers, method etc., so you can connect to any JSON or GraphQL API in Airtable. You can also use custom requests to connect to remote JSON/CSV/XML files.
The custom request UI might be familiar to you from using API clients like Postman or Insomnia.

Before you begin

  1. 2.
    After the extension launches, create a free Data Fetcher account by entering a password and clicking Sign up for free or click Continue with Google to sign in using your Google account.

Create a custom request

  • On the home screen, click Create your first request.
  • On the create request screen, under Application, select Custom.
  • Enter the request URL. For example, enter the following URL to fetch a list of crypto prices from the CoinGecko API.
https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd
You can paste a cURL command straight into the URL input and it will be imported into the current request, including all parameters, headers etc.
  • Select the Output Table and View. This is where the data will be imported into. By default, this is set to your current table and view.

Run the request

  • Click Save & Run in the bottom right of the screen.
The request will run and the Response field mapping modal will open. This is where you set how the fields from the response should map to fields in the output table. You will only need to do this the first time you set up the request or when you make changes to the data transformation.
  • For each field, you can select or deselect it by clicking on the field names. All the selected fields will be imported whenever the request runs.
  • Selected fields can be mapped to either an Existing field or a New field.
  • Click Save & Run in the bottom right of the modal.
The request will now run and import your data to Airtable. You can run the request again to update the data by clicking Run on the create request screen.
If you want to import the data automatically, even when you are not logged into Airtable or Data Fetcher, you can schedule the request, add a trigger or run it from a webhook.