Filter by most recent record

[aaron_altamura]

Hello,

Is there a way to query the API for recently updated records?

Trying to understand the best way to scan for records that need to be updated in a separate database.

Thanks!

[andywingrave · Accepted solution]

Hey Aaron,

The easiest way to do this is by doing the following:

1. Create a field called “Last Updated”, and choose the fields you want to be included in this calculation.

Here you can choose the specific fields you want, or just include every field

2. Next create a view with this field as a filter

So now you can query that specific table and view via the API

[aaron_altamura]

Duh. Amazing! Didn’t know this field existed and was resorting cussing out the API haha. Thank you good sir.