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(249.60000000000002, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Hi team,
I have a question regarding this article.
First I have created a Linked Service, DataSet and copy activity in the pipeline which copy from SalesForce to Azure SQL database through UI.
https://learn.microsoft.com/en-us/azure/data-factory/connector-salesforce?tabs=data-factory
That setup ends with an error: "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,'"
Preview data in copy functionality was also ends with similar error. When I create the linked service via json delivered in the article preview data started to work but whole pipeline still did not work. Is it about those types SalesforceV2, SalesforceV2Object, SalesforceV2,SalesforceV2Source? In those articles I do not see how to set it using UI.
Please help with my issue.
Thanks.
In addition to what I provided I'm using SOQL query which is running fine (Preview data is working and returns correct results)
Regards,
Michal Janczewski
![](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 Michał Janczewski
I am checking to see if the above solution is helpful. Please let me know if you have any further questions.
Yes, fullfilling this column helps but why it should be fullfill? This is saying that for source if SOQL query is used it is not needed.
Regards,
Michał Janczewski
Hello Michał Janczewski
Yes, you are correct. This is an optional field as per the document. But Product team is aware of the issue and they are working on the fix. ETA will be end of June.
If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.
Hello Michał Janczewski
Can you please confirm if you have configured the objectAPIName?
If not, please configure the object API name and this will fix the issue.
The Product Team is working on a fix for this issue. ETA will be end of June.