Incremental query / SOAP calls

[Milan_Vucetic]

Hi everyone,

I am supposed to call a SOAP web service from Adobe Campaign and update customers status (opt-in, opt-out) in remote table.

Now my question what is the best approach regarding I won't to update the whole DB every time (call will be performed every 5 min) so I need only changes from last time to send towards remote table? Can I use Incremental query for this? Is there any example in javascript to use like a guide?

Thanks

[Jonathon_wodnicki · Accepted solution]

Hi,

Use an xtk:option to track position in the table by most recent 'last modified date' if available (creation date, sequential id, etc if not).

For a reference, the ootb crm connectors mostly do this.

Thanks,

-Jon