ADF copy activity with salesforce connector doesn't work.

Question

I'm changing my pipelines that copy data from salesforce into a file, because the old salesforce linked service will stop working in october. I created a new linked service, a new dataset and changed my copy activity into the new source dataset.

Now, I don't use a specific api or report, I use SOQL queries. But all my pipelines now give the following error:

Operation on target SalesForce_ExtractAccount failed:

Operation on target createExtract_Account failed:

ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=

The value of the property '' is invalid: 'itemPath and objectApiName or reportId cannot be null in properties at the same time'.

,Source=,''Type=System.ArgumentException,Message=itemPath and objectApiName or reportId cannot be null in properties at the same time,Source=Microsoft.Connectors.Salesforce,'

Now, I didn't fill in objectAPIName or reportID. But I have no idea what ItemPath is. It doesn't show up when I look at the json source code, and googling also doesn't provide an answer.

So what did I do wrong?

Answer 1

Hi Debie, Hanneke ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

It seems you are facing error while using new salesforce connector while using in ADF pipeline.

From the screenshot , it looks like the linked service connection is successful . However, the copy activity is failing while using the salesforce dataset as source . Although, you are using SOQL query in source, looks like it's probably needed to mention the 'objectAPIName' or 'reportId' in the dataset.

Could you please try providing the same by selecting from the dropdown or entering it manually in the dataset and see if you are still getting the same error?

Hope it helps. Kindly let us know how it goes. Thankyou

Answer 2

Can you share your SOQL query ?

Otherwise, verify the source settings are correctly configured in your copy activity.

If you are comfortable with editing the JSON code directly, review the JSON configuration for the copy activity.

If your problem still persists, you may need to open a ticket to the support :

{

    "name": "SalesforceDataset",

    "properties": {

        "linkedServiceName": {

            "referenceName": "SalesforceLinkedService",

            "type": "LinkedServiceReference"

        },

        "type": "SalesforceObject",

        "typeProperties": {

            "query": "SELECT Id, Name FROM Account"

        }

    }

}