Knowing when there is a change to the record


#1

Hi, when using the API to read the stored records, what’s a good way for the client to know if there’s been updates to the content? Do we have to make the decision ourselves (ie download the whole data and compare), or is there a way to check “last updated”? Sorry if I missed that somehow.


#2

:slight_smile:


Zapier trigger for updated record or all records
#3

I’m also eagerly awaiting the MODIFIED_TIME() and Metadata API features!

But for now, here’s how I find changes:

New Records

Store the RECORD_ID() or the CREATED_TIME() for the last record your application requested. Subsequent requests can specify only records created after that record using the filterByFormula parameter.

Example filterByFormula param to get last known record:
RECORD_ID() = "a89ds790sad8f09ds8f90"

Example filterByFormula param to get records after time:
CREATED_TIME() > "2015-11-11T22:18:17"


Modified Records

The best way I’ve found to handle the identification of modified records is by:

  1. Identify specific fields to “watch”
  2. Request as few records as needed using filterByFormula. For example, for an events application I only retrieved upcoming events that were marked as “active”. This means my application won’t be aware of any inactive or past events, but for my application this was sufficient.
  3. Request as few fields as needed using the fields parameter. This speeds things up.
  4. Update/Patch only the fields that have actually changed. I’ve found debugging and performance to be improved by comparing each field I’m watching and building a new object/array/record using only the fields that have changed. This prevents the submission of values that have not changed and allows your debugging/console messages to be specific and informative. The alternative would be to create a hash of the entire record and if new_hash != old_hash update the whole record. This isn’t bad, just not the route I went down.

#4

Hi are there any updates to when the ‘created date’ or ‘last modified date’ will be added to Airtable? I have seen in the generated API documentation that it is on the roadmap, but it would be great to get a more tangible update about when this feature would be coming. Thanks!


#5

Any update? Any update at all?