Select or deselect fields - Only data from selected fields will be imported when the request runs.
Map to existing fields - Select Existing field and choose a field from the dropdown to use an existing column in your table.
Map to new fields - Select New field, enter a field name, and choose a field type. Data Fetcher automatically suggests appropriate field types based on the response data.
Search for fields - Use the Find field input to quickly locate specific fields in large responses.
Once you’ve configured your mappings, click Save & Run. Data Fetcher will create any new fields and import your data.
Apply transformations to field values before they reach your output table using formulas. Reference the original value as value in your formula (e.g., upper(value)).
Click the settings icon next to any field to open field settings.
Data Fetcher can automatically create and update linked records during imports. This is useful when you have related data, such as tasks linked to users.Use an existing linked field:
Select Existing field and choose a linked field from your output table.
By default, Data Fetcher uses the primary field in the linked table to find records. To change this, click the field settings icon and select a different field under Linked table field.
Create a new linked field:
Select New field, enter a field name, and set the field type to Linked record.
Click the field settings icon and select a table to link to under Linked table.
When the request runs, Data Fetcher will create links by looking for response values in the linked table. If no matching record is found, it will create a new record automatically.
Map remote file URLs (PNG, SVG, PDF, etc.) directly to Airtable attachment fields by selecting Attachment as the field type.Add to existing attachments instead of overwriting:
Click the settings icon next to the attachment field.
Under Attachment write mode, enable Add to existing.
Click Save.
Only write if cell is empty:
Click the settings icon next to the attachment field.
Under Write the attachment only if the cell is empty, enable Only if empty.
Data Fetcher converts API responses into tabular format, but you can view the original JSON or XML:
Click the settings sidebar icon (➡️) on the left side.
Click Response preview to display the raw response.
For JSON responses: Click any value to toggle whether it’s imported. Click the arrow next to field names to navigate directly to that field in the response.Note: For paginated requests and Run on Multiple Record requests, the response field mapping shows only the first request’s response data.
Data Fetcher suggests field types based on response data, but you can modify these suggestions (for example, changing from Number to Currency)
Be cautious when changing suggested data types, as incompatible values can cause import errors (for example, mapping text like “sdlf3421asd” to a Number field will fail)
