Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.