How to extract delta records using Salesforce Object API in Copy Data pipeline

Question

Is it possible to extract delta records from the Salesforce Account object using the Object API in the Copy Data pipeline? We know this can be done with a SOQL query by filtering by the last modified date and passing the date as a variable to isolate the delta data. However, we prefer to use the Object API for some additional benefits and would like to know if it's feasible to pass filter criteria with this method.

Answer 1

Hello Jayanth Kanagaraj (Moody's),

Welcome to the Microsoft Q&A forum.

It is not possible to extract delta records from the Salesforce Account object using the Object API in the Copy Data pipeline.

The Object API does not support filtering based on the last modified date or any other criteria. It only allows you to retrieve all records for a given object.

To extract delta records from the Salesforce Account object, you will need to use a SOQL query that filter based on the last modified date. By passing the date as a variable, you can isolate and retrieve only the delta data.

I hope this answers your question. Please let me know if you have any further questions.