Reference Airtable data in API requests

Yes, you can use Airtable values throughout your entire API request. Insert cell values in your URL path, query parameters, headers (including authentication), and request body. For example, use customer IDs in your URL path, timestamp formula fields in query parameters, and customer details in your request body—all within a single API call.

Yes, you can reference Airtable attachment fields in your API requests. Data Fetcher will use the attachment URL, allowing you to send files to external services for processing. This works perfectly for sending images to AI vision APIs, documents to text extraction services, or media files to transcription tools. Simply reference your attachment field like any other field, and Data Fetcher handles the rest.

You can make use of Airtable formula fields to create dynamic variables for your API calls by generating timestamps, formatting dates, or performing calculations. Create a formula field with NOW() to get the current date or DATETIME_FORMAT(NOW(), 'YYYY-MM-DD') to format it for API parameters. Each time your request runs (manual or scheduled), it uses the freshly calculated value, ensuring your API requests always have up-to-date dynamic data.

This feature executes your API request once for each record in a selected view. Data Fetcher replaces table references with values from the current record being processed. For example, if you reference the 'Company Name' field and run it on a view with 50 company records, Data Fetcher will make 50 separate API requests—each with a different company name. Results are then mapped back to the corresponding records in your Airtable base.

Yes, Data Fetcher includes built-in URL encoding for table references. When referencing Airtable data in URL paths or query parameters, you often need to encode special characters to ensure they're properly transmitted in the URL. Data Fetcher makes this easy with a simple toggle option. Just turn on "Encode URL table references" when adding your reference.