question

GirishShekki-3022 avatar image
0 Votes"
GirishShekki-3022 asked GirishShekki-3022 commented

Issue with Azure Data Factory Salesforce Connector in copy activity

Hi,

I am using salesforce connector in copy activity & writing data to Salesforce object. (using salesforce as sink). I select write behavior as 'Insert' and save the pipeline. But when I refresh or login back again. insert is changing to 'Upsert' automatically. Even when I choose 'Insert' option and publish the PL, the option gets changed to 'Upsert' automatically and gets published.

Has anyone seen this issue before? Any solutions for it?

thanks

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered GirishShekki-3022 commented

Hi @GirishShekki-3022 ,

Thank you for posting query in Microsoft Q&A Platform.

I tried to repro your case, It seems UI Bug. UI shows upsert as value but when we go to activity json we see "insert" only as writeBehaviour.

Please check below image for same.
158240-copy.gif

I shared this Bug details to product team. I will update this thread once i here back updates. Thank you.

Hope this will help. Please let us know if any further queries. Thank you


Please consider hitting Accept Answer button. Accepted answers helps community as well.


copy.gif (393.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This appears to be by design: The design of the Upsert behavior in this Activity requires the ExternalID field and, if not provided, will default to using the Insert behavior. If you provide an ExternalID value, it will save as Upsert.

It would be nice if this Activity also implemented UPDATE so that we could update based on the Primary ID field in SF instead of being forced to create an external ID field.

0 Votes 0 ·