How to Multi-Select in CRM with ADF?

Balachandran Kannan 181 Reputation points

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  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