Help

Query only recently udpated records

Topic Labels: API
Solved
Jump to Solution
1696 2
cancel
Showing results for 
Search instead for 
Did you mean: 
aaron_altamura
6 - Interface Innovator
6 - Interface Innovator

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!

1 Solution

Accepted Solutions
andywingrave
10 - Mercury
10 - Mercury

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.

Screenshot 2020-01-25 at 11.07.17

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

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

Screenshot 2020-01-25 at 11.10.01

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

See Solution in Thread

2 Replies 2
andywingrave
10 - Mercury
10 - Mercury

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.

Screenshot 2020-01-25 at 11.07.17

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

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

Screenshot 2020-01-25 at 11.10.01

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

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