Response field mapping

Data Fetcher allows you to choose which fields from the API response to keep or filter out, and how they should map to the fields in the output table.

Create the response field mapping

  • Clickfor the first time, and Data Fetcher will determine the fields and types (e.g. number, checkbox etc) of the response and open a dialog.

  • For each response field:

    • Choose whether to keep it or filter it using .

    • Change the data type from the suggested one using .

    • Select an existing field in the output table using .

    • Enter the name of a new field to create using .

  • Click to close the dialog and create any new fields.

Update the response field mapping

  • Click to open the dialog.

  • For each response field:

    • Choose whether to keep it or filter it using .

    • Change the data type from the suggested one using .

    • Select an existing field in the output table using .

    • Enter the name of a new field to create using .

  • Click to close the dialog and create any new fields.

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 when an API request runs.

Data Fetcher cannot create the actual linked fields (Airtable apps are not able to do this), but it can create and update the links between records. You will first need to create the linked fields in your output table, then:

  • Click to open the dialog.

  • Set the data type to 'Link' using .

  • Choose a linked field using .

  • By default, Data Fetcher will use the primary field in the linked table to find the record to link to, but you can change this with .

  • You will also see an option to change the linked table: . You should not need to use this (and it is disabled by default), as the table is inferred from the linked field you selected. However if the table name changes, you will see a warning and might need to update it.

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

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. the 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 the app will fail when trying to update the field.

‚Äč