Azure Data Factory: Upsert with alternate key containing a guid

(1) Share

Report

Posted on by WouterVD

Hi,

I'm trying to upsert records to dataverse using ADF. The table in dataverse has an alternate key based on 2 guids.

I am reading the data from a json File. So the guids come in as a string.

Converting to a guid is not possible in the "Derived Column" step.

In the "Derived Column" step I added this mapping

In the mapping to dataverse I added:

This is the error I get:

Job failed due to reason: Schema of Source(..... ) doesn't contain key column: ..._productid.
Please confirm your input schema contains all key columns

The above is necessary to link the lookups. I tried to add the guids also as strings to the mapping (without the /products and without the odata.bind) but that doesn't help.

Is there a way to get this done or is the only way to solve this to work with text fields for the alternate key?

Categories:

Microsoft Dataverse

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WouterVD 72 on at

Like (0)

Report

Azure Data Factory: Upsert with alternate key containing a guid

Microsoft has made a change that now makes it possible to update lookups just by passing the guids as a string.

Upsert based on 2 guids now also works.

Was this reply helpful? Yes No