The new ADF/Synapse connector to Salesforce no longer supports QueryAll to query deleted records in Salesforce. How can this be done?

Question

Hi, The previous version of the ADF Salesforce connector (https://learn.microsoft.com/en-us/azure/data-factory/connector-salesforce-legacy?tabs=data-factory) supported querying deleted records in Salesforce:

But the new version (https://learn.microsoft.com/en-us/azure/data-factory/connector-salesforce?tabs=data-factory) does not appear support this option.

Is there a way to queryAll using the new connector, or to continue to use the legacy connector for new linked services. This functionality is crucial to my application. Thanks, Kevin

Answer 1

This function has been added which replicates the QueryAll functionality:

Answer 2

Microsoft has missed to add drop down in GUI side but we can enable this feature from code wise, In adf after creating pipeline, open as script add this line
, "includeDeletedObjects": True

then it will pull all deleted data also.

"activities":[

{

    "name": "CopyFromSalesforce",

    "type": "Copy",

    "inputs": [

        {

            "referenceName": "<Salesforce input dataset name>",

            "type": "DatasetReference"

        }

    ],

    "outputs": [

        {

            "referenceName": "<output dataset name>",

            "type": "DatasetReference"

        }

    ],

    "typeProperties": {

        "source": {

            "type": "SalesforceV2Source",

            "query": "SELECT Col_Currency__c, Col_Date__c, Col_Email__c FROM AllDataType__c",

            **"includeDeletedObjects": True -- Add this code** 

        },

        "sink": {

            "type": "<sink type>"

        }

    }

}

]

Answer 3

I do still have a problem, the check box is clicked, but deleted records are not downloaded.