Skip to main content

Hello,


I’m trying to figure out a way to use the API to get all records modified TODAY(). When I retrieve records with the API I can see the createdTime field, but no modifiedTime field though the documentation says it exists.


Does anyone know of a formula that I can use to get all records modified TODAY()?


Thanks!

Hey @Daniel_Dow


There is actually a function you can use in filterByFormula called LAST_MODIFIED_TIME() for this purpose. Eg:


filterByFormula=IS_AFTER(LAST_MODIFIED_TIME()%2C+\\"2021-01-25T14%3A23%3A41.000Z\\")

Best,

Anthony

Hey @Daniel_Dow


There is actually a function you can use in filterByFormula called LAST_MODIFIED_TIME() for this purpose. Eg:


filterByFormula=IS_AFTER(LAST_MODIFIED_TIME()%2C+\\"2021-01-25T14%3A23%3A41.000Z\\")

Best,

Anthony


Thanks! I’ll try that!

Reply


Terms & Conditions