Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
How to get only changed records from SuiteTalk
I am writing a program to find all records (e.g. customers) that have been updated and so I can write these changes to a legacy database.
My program sends a Search command to SuiteTalk with a (for example) CustomerSearchBasic object. The CustomerSearchBasic object defines a search for all records and compares their lastModifiedDate with the latest lastModifiedDate value it received when it last got results.
I have two options:
A) Ask for all records where the lastModifiedDate is not earlier than the latest lastModifiedDate it received when it last got results. This would mean that if two records were updated in the same second but last time I received just the first then this time I will receive both of them. This means I won't miss an update but I will usually receive at least one record whose update I have processed already.