Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,726 questions
How to Multi-Select in CRM with ADF?
Bala
176
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 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?
{count} votes
-
ShaikMaheer-MSFT 30,506 Reputation points Microsoft Employee2021-06-28T10:40:57.653+00:00 Hi @Bala ,
Thank you for posting query in Microsoft Q&A Platform.
Could you please help on below details. So that we can follow along to replicate scenario and help in detailed resolution.
- What is your Source type?
- If possible, could you please share sample source data? which helps us to replicate scenario.
- When you say multi select values, you mean values with comma separated? If your source file is also comma separated values(csv) file?
Sign in to comment
Hi @Bala ,
Could you please share clarifications on above commented queries? That will help us to follow along issue and provide detailed resolution. Thank you.
Hi @Bala ,
Did you get chance to share details on above requested clarifications? Details on clarifications will help us to follow along issue and provide detailed resolution. Thank you.