Create a custom request
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.
- 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.
- 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
- 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.
- Set up any other options for the request, such as:
- Enter a name for 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 application should map to fields in the output table.
- For each field, import or filter it. For an imported field, you can set whether to map it to an existing field or create a new field.
- Click "Save & "Run".
- The request will now run and import your data to Airtable!
If you want to import the data automatically, even when you are not logged into Airtable or Data Fetcher, you can schedule the request or run it from a webhook.