How to Multi-Select in CRM with ADF?

Balachandran Kannan 181 Reputation points
2021-06-25T15:14:02.537+00:00

There is a CRM table that is being upserted for a Multi-Select values (Choices) through ADF copy activity. Values are being sent as String such as "1,2". But CRM complains

Dynamics operation failed with error code: -2147220989, error message: Incorrect attribute value type System.String

Tried with Postman with a PUT request as below and it is working absolutely fine.

PUT https://me.crm11.dynamics.com/api/data/v9.1/products(3ABCC128-XYZA-470D-8DAC-EIRY6478288F)/category/  HTTP/1.1 

Content-Type: application/json  
OData-MaxVersion: 4.0  
OData-Version: 4.0  

{
"value": "1,2"
}

How do I mimic this value setting in Copy activity?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,121 questions
{count} votes