Use table values in requests

Data Fetcher lets you use values from your base in any request URL, header, parameter or body. Any input with the allows you to add a reference to some data from your base.

There are two slightly different ways to use table values:

1. Make a single API request using a value from a cell

If you reference a table or field name with spaces in you may experience bugs.

  • In the input for the field you want, click

  • Select the table from the dropdown.

  • Select the field from the dropdown.

  • Click the record you want to reference.

  • The input will now have a reference to the cell, which is in the format: ***TABLE_NAME*FIELD_NAME*RECORD_ID***.

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

If you reference a table or field name with spaces in you may experience bugs.

2. Make multiple API requests, using the values from each record

  • In the input for the field you want, click

  • Select the table from the dropdown.

  • Select the field from the dropdown.

  • Click without clicking a record, since the request is going to run for multiple records.

  • The input will now have a reference to table and field, which looks like: ***TABLE_NAME*FIELD_NAME***.

  • Click to open the advanced options.

  • Under "Run on Multiple Records", select the table and the view to use. The table must be the same as the one referenced earlier.

  • When the API request runs, a separate request will run for each record, and the reference will be replaced with the value for that record. Each request will count towards your monthly usage.

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. (Coming soon).