Retrieve all OptionSet values using OData in Dynamics CRM

dynamics-crm dynamics-crm-2013 dynamics-crm-webapi
Rahul Patil picture Rahul Patil · Sep 10, 2016 · Viewed 11.8k times · Source

I am quite new to Dynamics CRM. I am building an app which should update entity in Dynamics CRM. I can update simple types without any issues. Now the situation is, I have declared some custom Option Sets in Contact entity.

Is there any way to retrieve all the possible OptionSet values (text and value) so that my app can look for appropriate value and set it in the payload it is generating?

I can not find any endpoint in WebAPI as well as XRMServices/2011/OrganizationData.svc. Any help would be really awesome.

Answer

James Wood picture James Wood · Sep 10, 2016

You can use either the Web API or Organisation Service to retrieve The metadata and data models in Microsoft Dynamics CRM. Check out the sub articles of that one for specific examples and details.

Web API example Querying EntityMetadata attributes.

The following query will return only the PicklistAttributeMetadata attributes and will include the LogicalName as well as expanding the OptionSet and GlobalOptionSet collection-valued navigation properties.

GET [Organization URI]/api/data/v8.1/EntityDefinitions(70816501-edb9-4740-a16c-6a5efbc05d84)/Attributes/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet,GlobalOptionSet

Related questions

Get the string value from OptionSetValue in CRM Plugin

I'm wondering how to get the string value of an OptionSet in a CRM plugin I am making. I thought all I had to do was pass the int value to OptionSetValue, but that doesn't seem to be working. Here …

Read More
CRM 2013: Force refresh a form after save

We have a requirement to refresh the form after saving (to ensure that some hide/show logic works as expected based on a field value). Currently the form does not automatically refresh after saving the record. I have gone through …

Read More
setDisable for all fields of a Section in a Crm Form

I need to disable a section if a value from other field is true, normally I would do: function disableSection1(disabledStatus){ Xrm.Page.getControl("section1field1").setDisabled(disabledStatus); Xrm.Page.getControl("section1field2").setDisabled(disabledStatus); Xrm.Page.getControl("section1field3").…

Read More