Response field mapping
The response field mapping is where you select which fields should be imported from an application and how they map to the Airtable fields in your output table.

Create the response field mapping

  • When creating a request, click
    and the response field mapping modal will open.
  • This modal will have a list of all the possible fields you can import from the application. For each response field:
    • Choose whether to import it or not with
      .
    • Map it to an existing field by selecting
      then choosing a field with
      .
    • Map it to a new field by selecting
      , entering a field name in
      and selecting a field type with
      .
    • Click
      .

View the API response

You can view the actual response that is returned by the API.
  • Click
    to open the dialog.
  • Click
    to show the API response on the left-hand side of the dialog.
  • Click on a field to toggle whether it is kept or filtered.
  • Click on
    next to a field to search for it in the response. Click again to see the next value.
For paginated and "Run on Multiple record" requests, it shows the response from only the first request.

Formula

If you need to transform a field's values before it reaches the output table, you can do this by specifying a formula for the field. You should reference the value as value , e.g. upper(value). A full list of formulas can be found here.
  • Click on
    to open the field settings.
  • Enter the formula in the input.
  • Click
    .

Linked records in response field mapping

If your API response references records in other tables, you can tell Data Fetcher to understand and update these links during a run. For the response field you to link:
To use an existing linked field:
  • Select
    then choose a linked field in your output table with
    .
  • By default, Data Fetcher will use the primary field in the linked table to find the record to link to. To change this, click
    then select a different field under Linked table field.
To create a new linked field:
  • Select
    , enter a field name in
    and change the field type to
    .
  • Click
    to open the field settings, and select a table to link to under Linked table.
When the request runs, Data Fetcher will create links to the linked table by looking for the response value in the linked table field. Anywhere it cannot find a record to link to, it will create a new record and link to that instead.

Attachment field type

Data Fetcher can map a remote file URL (e.g. a PNG, SVG or PDF) in an API response to an Airtable attachment field. Simply select
in the response field mapping. When the request runs, Data Fetcher will create an attachment from the remote file.

Troubleshooting

  • Every time you change the output table, or data transformation, the response field mapping is reset, and you will need to create it again.
  • Data Fetcher suggests data types by looking at the values in the response, but you can change these. E.g. it might suggest Number when in reality you want Currency.
  • Be careful when changing the data type from the suggested one, as it can lead to errors if the values cannot be converted. e.g. if the response returns "sdlf3421asd" in a field you specified as a Number Data Fetcher will fail when trying to update the field.