Skip to main content
Solved

Query only recently udpated records

A

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!

Best answer by andywingrave

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

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

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

View original
Did this topic help you find an answer to your question?

2 replies

A
  • andywingrave
  • Inspiring
  • 323 replies
  • Answer
  • January 25, 2020

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

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

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

A
1 person likes this
  • A
    aaron_altamura
A
andywingrave wrote:

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

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

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.

A
1 person likes this
  • A
    andywingrave

Reply


Most helpful members this week

Terms & Conditions