Help

Knowing when there is a change to the record

Topic Labels: API
15319 13
cancel
Showing results for 
Search instead for 
Did you mean: 
Ken
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

13 Replies 13
Jonah_Stiennon
4 - Data Explorer
4 - Data Explorer

I don’t suppose there’s plans for a websocket API where we can get change events?

Charlie_Martin
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to fetch recently modified rows via the API. Seems to me that this should work, but it doesn’t return any rows…

filterByFormula: "LAST_MODIFIED_TIME() > '8/17/2019, 7:36:49 PM'",

what am I doing wrong here?

I tried this and it actually worked

we are using curl api

url: '<AIR_TABLE_API_URL>/<APP_KEY>/<APP_NAME>?maxRecords=10&view=Master%20View&filterByFormula=CREATED_TIME%28%29%20%3E%20%222019-08-27T22%3A18%3A17%22

filterByFormula=CREATED_TIME%28%29%20%3E%20%222019-08-27T22%3A18%3A17%22

//
this is url encoded version of

CREATED_TIME() > “2019-08-08T22:18:17”

Charlie_Martin
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you!!! The issue was the date format.

Where did you find out what date format to use? I saw the API seems to return dates in this format ‘8/17/2019, 7:36:49 PM’, but it accepts them in this format ‘2019-08-08T22:18:17’. I can’t find any documentation on this at all.