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 looks like: ***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.