'Import data from Salesforce Report using ADF

I am working on importing data from Salesforce Report using ADF. I am using copy activity and have created salesforce linked service.

I did get the below syntax from Microsoft documentation https://docs.microsoft.com/en-us/azure/data-factory/connector-salesforce but I get the below error.

enter image description here

Error:

Failed to import source schema. ERROR [HY000] [Microsoft][Salesforce] (120) SOQL_FIRST mode prepare failure: SOQL error: [Microsoft][SQLEngine] (31480) syntax error near '"<<< ??? >>>query": "{call "Quality & Impact Survey Results by Tier"}"'. SQL error: [Microsoft][SQLEngine] (31480) syntax error near '"query"<<< ??? >>>: "{call "Reportname"}"'. Activity ID: a1373279-97e4-42e4-86e3-80d930ef9364

If anyone have worked on this then do let me know your thoughts.

azuresalesforceazure-data-factoryazure-data-factory-2


Solution 1:[1]

I found out the syntax to extract data from Salesforce from ADF as per below.

{call "Reportname"}

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Babulal

Related Questions