We are trying to create a local proxy of Part records in our on-premise SQL Server via a scheduled sync event. The plan was to ask the REST API for all part records updated since the last sync. However, even in a BAQ query, I can’t find an “updated date” bound to the part record. I see “createdat” and “createdby” but they don’t help since we want to know when the part’s data has changed (description, unit price, etc.).
Is there a datetime stamp for updates on parts recorded somewhere in the DB that we can see?
Advice anyone? Thanks!