API Request for Query data from multi-select picklists

(2) Share

Report

Posted on by AA-27052047-0

I'm trying to understand how to correctly Query (let's say Contacts) the Multi select Picklists fields using the API? Yes, I have the documentation from https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/multi-select-picklist?view=op-9-1#query-data-from-multi-select-picklists but I don't fully understand how to use `Equal`. Also, can someone share how to use `Contains` Here is an example of my request that fails. pic

GET Request - /accounts?%24filter=new_testmultifield%20eq%201

I got

{  /error/: {    /code/: /0x0/,    /message/: /A binary operator with incompatible types was detected. Found operand types 'Edm.String' and 'Edm.Int32' for operator kind 'Equal'./  }}

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

My tool Dataverse REST Builder can show you the syntax on how to deal with multi-select optionsets (Choices)

Link: https://github.com/GuidoPreite/DRB

If you don't want to install the tool you can just use the online demo, if you select request type "Retrieve Multiple" and the table "Custom Table" there is a field called "Choices" where you can add the filter Equals and Contains Values, they use the Microsoft.Dynamics.CRM.In and Microsoft.Dynamics.CRM.ContainsValues operators

Was this reply helpful? Yes No