Knowing when there is a change to the record

[Ken]

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.

[Jonah_Stiennon]

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

[Charlie_Martin]

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?

[John_Fernandez]

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]

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.