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.