I would like to know how I can query on update_id. I'm using the API and want to be able to asked for rows with a greater update_id than the highest I have on record.

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
I want to know how to get updates to records. If I pull a query and I want to run the same query but only get the records that have been updated.  I thought I could use the update_id field returned with each recordID however I'm unsure how to query that field since my schema document does not include information on update_id.
Photo of Shelby

Shelby

  • 10 Points

Posted 2 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 744 Points 500 badge 2x thumb
Have you considered using the Date Modified field?
Photo of Shelby

Shelby

  • 10 Points
I'm using date modified now, however, it's not always updated. If I modify something in a grid report, it doesn't get the update.  If there is a simple solution for updating that last modified date for all updates it would help.

I have an issue where data is going to be loaded/edited via CSV upload.  If update_id is the only solution I need to query on it also.
low tech solution would be to add your own last_update field to the table and include it in the CSV import.
Photo of Shelby

Shelby

  • 10 Points
There is not data coming back in my query for Date Modified. I'll recheck my query to make sure that field was included in the request.    I'm now researching how to onlynew flag works.