Share
Report
72Hi,
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:
I have the same question (0)
All responses (
Answers (
