SFSF Adapter - Delta Synch

[Former Member]

Hi All,

I am trying to use delta synch in SFSF adapter to query ADHOC_XXX entity but when I specify the condition based on datetime field in the query and on execution channel is failing with error (Attached error for reference).

If I specify the delta synch condition for other API such as 'User' then execution is working fine.

So please let me know whether delta synch is supported for ADHOC entities ?

Thanks & Regards,

Prakash

[Former Member · Accepted solution]

Hi Prakash,

We have not enabled support for delta sync yet from sender adapter. The issue is that some adhoc queries do not have full timestamp and there is a possibility to get duplicate records again and again.

Will a solution involving BPM be useful to you?

Best regards,

Bikash

[Former Member · Accepted solution]

Hi Bikash,

Thanks for the update.

Any update when delta sync will be enabled for ADHOC queries?

Do we have any option to use Join queries (multiple entities) in sender adapter and how do we achieve this as in kepler not able to find any option for join query?

What is the use of the additional settings in sender adapter? Please share if any documentation/help link

If the business scenario needs delta changes need to be retrieved from ADHOC entities, then any workaround without BPM is possible?

Thanks & Regards,

Prakash