Salesforce Bulk API Connector

Dev Poudel (Health) 0 Reputation points
2024-05-28T04:11:41.51+00:00

I am using SOQL instead of ObjectApiName. The SOQL is generated using parameter correctly. The older legacy connector works fine for the same pipeline but the new one is giving this error msg:

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,'

I cant provide the objectApiName as this is generated dynamically during runtime using parameters. The input to the copy activity logs show that the SOQL is correctly generated.

I saw a similar issue here - https://learn.microsoft.com/en-us/answers/questions/1684985/adf-copy-activity-with-salesforce-connector-doesnt

Unfortunately this is not a solution as hardcoding the ObjectApiName is not an option

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,929 questions
{count} votes