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://video2.skills-academy.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.
10,024 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
236 questions