Microsoft Dynamics 365 | Integration, Dataverse...

API Request for Query data from multi-select picklists

(1) 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'./  }}

All responses (2)

Answers (0)

CU28050851-0 2 on at

Like (0)

Report

API Request for Query data from multi-select picklists

Maybe we need a course on how to use `Equal`

dinosaur game
Suggested answer

Guido Preite 54,069 Super User 2024 Season 1 on at

Like (0)

Report

API Request for Query data from multi-select picklists

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