Data Fetcher Help Center
🚀 Try for free📮 Support
  • 👋Welcome
  • Create Requests
    • Create a request
    • Use table values in requests
    • Use variables in requests
    • Response field mapping
    • Schedule a request
    • Add a request trigger
    • Troubleshoot errors
    • Run request using webhook URL
    • Pre-built integrations
  • Custom Requests
    • Create a custom request
    • Set request method
    • Set request parameters
    • Request authorization
    • Set request headers
    • Add request body
    • Connect to a preset OAuth API
    • Create a custom OAuth connection
  • Advanced settings
    • Write modes
    • Update based on field(s)
    • Pagination
    • Response data transformations
    • Response JMESPath
    • Add fixed value to output
    • No output mode
    • Rate limit
    • Max response records
    • Run request from button field
    • Denormalize response
    • XML array handling
    • Fixed IP Address
  • Organise Requests
    • Run history
    • Duplicate a request
    • Delete a request
    • Add request description
    • Import request from cURL command
    • Export requests as JSON file
    • Import requests from JSON file
  • Create Sequences
    • Create a sequence
    • Schedule a sequence
    • Run sequence from button field
    • Run sequence using webhook URL
  • Account
    • Upgrade workspace
    • Authorize Data Fetcher and Airtable
    • Add user to workspace
    • Roles and permissions
    • View monthly usage
    • Update personal details
    • Update payment card
    • Update billing information
    • View invoices
    • Switch workspace
  • Get a Google Maps API Key
Powered by GitBook
On this page
  • Run on Multiple Records
  • Change Table and View for Run on Multiple Records
  • Ignore errors when running on multiple records
  • Use the value in a single cell
  • Reference dynamic values using Airtable formula fields
  • Encode URL table references
  1. Create Requests

Use table values in requests

Last updated 6 months ago

You can use values from your tables in requests. You do this by creating table references, which are replaced with the actual table data when the request runs.

There are two different ways to do this:

  1. : this will run a separate request for each record in a table. For example:

  • Lookup the stock price for every record in a view based on its Ticker field.

  • Fetch more info about each course in a table based on its Course ID field.

  1. : this will run one API request, with the reference replaced by the value in a single Airtable cell. For example:

  • Use an Airtable formula field to create a date string for yesterday, and use this string in a request URL.

  • Store an access token in an Airtable cell (assuming your base is private) and use this in an authorization header.

Run on Multiple Records

  1. Click the + button in any input to open the table reference modal.

  1. On the modal that opens, select the Table and Field you want to reference.

  1. Under Run for every record in view, select the view on which you’ll run the request. Do not select an individual record.

  1. Click Confirm. The input will now contain a reference to the table and field.

Change Table and View for Run on Multiple Records

The Run on Multiple Records table and view will automatically be set to the table and view you selected, but if you want to confirm or change this:

  1. Click â–¼ Advanced settings to open the advanced settings.

  2. Under Run on Multiple Records, select the table and the view you want to use. The table must be the same as the one referenced in your input.

Ignore errors when running on multiple records

Turn on the "If one of these records causes an error, run the next request anyway." switch if you want Data Fetcher to ignore errors and move on to the next record when the requests run.

Use the value in a single cell

  1. Click the + button in an input to open the table reference modal.

  1. Select the Table and Field you want to reference.

  1. Select the record with the cell's value you want to use.

  1. Click Confirm.

The input will now have a reference to the cell.

When the request runs, the reference will be replaced by the cell value in that cell.

You can edit a table reference at any time by clicking it to re-open the table reference modal.

Reference dynamic values using Airtable formula fields

Let's say we want to use the current date and time in our request's parameters with this format: 2023-03-22 12:00:00.000 .

  1. Create a table in Airtable called "Config". Creating a new table keeps things cleaner.

  2. Delete all the records apart from one.

  3. Create an Airtable formula field called "Date today" with this formula:

DATETIME_FORMAT(NOW(), 'YYYY-MM-DD HH:mm:ss.sss')

The cell will now have a dynamic value in it:

Your parameter will now have a reference to the formula field. When the request runs, it will be replaced by the latest date value in that cell. This works for both manual and scheduled/ automatic Data Fetcher runs.

Encode URL table references

When referencing a table/cell in the URL, you might need to encode the values. Data Fetcher has the option to do this automatically. On the table reference modal, use the Encode URL table references option at the bottom to turn this behaviour on or off:

When the request runs for each record in the view, the reference will be replaced with the value for each record in that field. .

When you are running on multiple records, you should keep set to "None". The output record's position in the Run on Multiple Records table/view will then be used to update it.

When with this option enabled, the request will be paused if there are errors for 100 consecutive scheduled records/runs. You will be notified after this happens so that you can fix the request.

If you need to reference dynamic values, you can use an Airtable formula field to get these values, then reference them using the method described above.

Create a to this cell.

Update based on field(s)
scheduling requests
single value
single value reference
Run on multiple records
Use the value in a single cell
Each record in view will use one run in your monthly usage