Data Fetcher Help Center
Search…
Data Fetcher Help Center
Home
Create Requests
Create a request
Set request method
Set request parameters
Request authorization
Set request headers
Add request body
Use table values in requests
Use variables in requests
Write modes
Response field mapping
Schedule a request
Connect to an OAuth API
Advanced settings
Update based on field
Pagination
Response data transformations
Add fixed value to output
No output mode
Rate limit
Max response records
Run request from button field
Organise Requests
Run history
Duplicate a request
Edit a request
Delete a request
Import request from cURL command
Import requests from JSON file
Export requests as JSON file
Create Sequences
Create a sequence
Schedule a sequence
Run sequence from button field
Account
Accounts vs users
Upgrade account
Add user to account
Roles and permissions
Add Airtable API key to account
View monthly usage
Update personal details
Powered By GitBook
Update based on field
If each entity in your API response has an id field or some other unique field you can use this to as the basis for updating record data. This makes the update far more robust as Data Fetcher will match each entity to the relevant record rather than naiively using the order of the records.
Updating based on a field works with the Update or Overwrite request write modes. When this option is used:
    Update mode updates records in the table based on this field. Any records that existed before but are not in the API response are not changed.
    Overwrite mode updates records in the table based on this field. Any records that existed before but are not in the API response are deleted.

Update based on field

    You will need to have run the request at least once to have created the possible fields.
    Click
    to open the advanced options.
    Select either the Update or Overwrite request write mode.
    Under Update Based on Field, select the field you want in the dropdown.
Create Requests - Previous
Connect to an OAuth API
Next - Advanced settings
Pagination
Last modified 11mo ago
Copy link
Contents
Update based on field