This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 25%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
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
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Hi, thanks for your answers on this. But I don't think either option works. I have tried using a SOQL query but don't see how this allows the use of QueryAll? It still does not return deleted records. Am I missing something? As for using the legacy connector. I cannot create new linked connections using the UI on the legacy connnector. Only the new connector is available. How can I create new connections but use the legacy connector? Thanks, Kevin
Looks like I can create a legacy connected linked service via PowerShell. But I'd still like to know if there is anyway to QueryAll using the new salesforce connector.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Hello Kevin Chadney,
Welcome to the Microsoft Q&A forum.
I am checking with my internal team and get back to you with an update.
AI usage policy for Microsoft Q&A
Follow these steps when using AI to generate an answer on Q&A:
Using AI to help with answers on Microsoft Q&A requires following these three steps. Otherwise, moderators might delete the content and suspend your account.
Please see the below link for details:
https://learn.microsoft.com/en-us/answers/support/ai-usage-policy#ai-usage-policy-for-microsoft-qa
Hello Kevin Chadney,
This is a limitation with the new salesforce connector.
I would recommend submitting feedback item in the below channel. https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c
All the feedback shared in this forum are actively monitored and reviewed by ADF engineering team and will prioritize them accordingly based the number of requests.
Also please do share the link once the feedback is posted so that we can pass the feedback to respective product owners for further review.
Hope this info helps.
@Bhargava-MSFT I posted the idea here: https://feedback.azure.com/d365community/idea/b0d3d53b-f9e5-ee11-a73d-000d3a0ec6c7
Thanks!
Thank you Kevin Chadney
This function has been added which replicates the QueryAll functionality:
Hi Kevin Chadney,
Thank you so much for the update as it helps as it helps the community look for an answer to this new functionality.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 79%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
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>"
}
}
}
]
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 77%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
I do still have a problem, the check box is clicked, but deleted records are not downloaded.