Create a request

Requests let you connect to other applications/APIs in Airtable. A request is a saved set of instructions telling Data Fetcher how to import data to or from your base. Every time you run the request, the data will be imported or exported.

You can use Data Fetcher's ready-to-go Airtable integrations to import data from many popular applications. Alternatively, you can use custom requests to connect to any REST/GraphQL API or remote JSON/CSV/XML file by entering the API details yourself.

Before you begin

  1. Add Data Fetcher to your base and sign up for a free account.

  2. On the Data Fetcher home screen, click Create your first request.

Create a request

  1. On the create request screen, select the Application you want to import data from. Select Custom to create a custom request or select one of Data Fetcher's pre-built integrations like OpenAI, Facebook Ads, Google Analytics or Xero.

  1. Complete the Authorization by connecting your account or entering an API key. Some applications are public and do not need any authorization.

  1. Some applications will require you to select an Endpoint. If not, you can skip this step.

  1. Enter a name for your request in the input at the top of the screen.

  1. Click Save & Continue in the bottom right of the screen.

  1. Complete any required (*) options for your chosen application and endpoint.

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

  1. Click Save & Run in the bottom right-hand corner.

The Response Field Mapping window will open. This is where you configure how the fields from the application response map to fields in your 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 name. All the selected fields will be imported into Airtable when the request runs. All the deselected fields will be ignored.

  • Selected fields can be mapped to either an Existing field or a New field.

  1. Once you're happy with the mapping, click Save & Run in the bottom right of the response field mapping window.

The request will now run and import your data to Airtable.

You can import the fresh data again by clicking Run.

If you want to import the data automatically, even when you are not logged into Airtable, you can schedule the request, add a trigger or run it from a webhook.

Check out these guides to Write modes and Update based on field(s) to understand how data from the application is merged with the existing data in your output table.

Last updated