How do you write SOQL to import delta records?

In the standard integration you could have write something like this:

LastModifiedDate >= Last Successful Upload AND ...

but in the new Salesforce Integration App Import SOQL you can't embed "Last Successful Upload "

Any suggestions of can you query Salesforce records modified since the last successful upload to Eloqua, would be greatly appreciated!

Best Answer

  • Sunny Gupta
    Sunny Gupta IndiaPosts: 5 Red Ribbon
    Answer ✓

    This is added to the backend functionality and all import job runs in a way that it will fetch only data which got modified after the last upload. The last upload can be evaluated based on the stamp which reflects on the import last run on the overview page. This is not customized. However, I have raised an Enhancement request to Oracle to make it customized.