Incremental query / SOAP calls | Community
Skip to main content
Milan_Vucetic
Level 9
July 1, 2019
Solved

Incremental query / SOAP calls

  • July 1, 2019
  • 1 reply
  • 1130 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
July 11, 2019

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