Aug 05, 2024 05:18 PM - edited Aug 05, 2024 05:23 PM
I am using LIST records API to retrieve data from the table.
I am needing to get all the records every time. This is acceptable, but no ideal.
My client's table has no field that mark when a row is created or edited/updated. Does this of function already exist? If so, How would I grab only the records that were added or changed since the last update?
BTW: using this API call:
https://api.airtable.com/v0/xxxxxxxxxxxxxxxxxx/$$tablename$$
Thanks,
Scott
Solved! Go to Solution.
Aug 05, 2024 06:33 PM
re: My client's table has no field that mark when a row is created or edited/updated. Does this of function already exist?
There's the "Created Time" and "Last Modified Time" fields?
---
re: If so, How would I grab only the records that were added or changed since the last update?
Hmm...if you're storing the time you're making the call each time, you could try to combine that with a `filterByFormula` and filter for records that were created / modified since the last time you made the call?
Aug 05, 2024 06:33 PM
re: My client's table has no field that mark when a row is created or edited/updated. Does this of function already exist?
There's the "Created Time" and "Last Modified Time" fields?
---
re: If so, How would I grab only the records that were added or changed since the last update?
Hmm...if you're storing the time you're making the call each time, you could try to combine that with a `filterByFormula` and filter for records that were created / modified since the last time you made the call?