How do you write SOQL to import delta records?

Alexander Stojanovic

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!

Sunny Gupta

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.

Sunny Gupta

It is a already inbuilt functionality in app which only fetch the records since last successful upload run.

Sunny Gupta

It is a already inbuilt functionality in app which only fetch the records since last successful upload run.

Alexander Stojanovic

Thanks Sunny, do you know where is that configured?

Alexander Stojanovic

Thanks Sunny, agree, it would be great to have more control over this feature!

Abhijeet R

Oracle has given inbuilt functionality in app which only fetch the records since last successful upload run.

Alexander Stojanovic

Thanks Abhijeet!

User_YKCN6

Digging up the old thread here, any updates on when we can customize SOQL query to reference the backend system stamped date?

Alexander Stojanovic

On my last call with them, they couldn't tell,

but as @Abhijeet R mentioned above, that feature is by default enabled, so all records are delta,

for us that was good enough, at least for now :)