Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Incremental query / SOAP calls

Avatar

Community Advisor

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

0 Replies

Avatar

Correct answer by
Community Advisor

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