Customer experience | Sales, Customer Insights,...

How Decode Choices in Dynamics CRM 365 Using Python or SQL

(1) Share

Report

Posted on by carltonp

Hello Community.

My first post here,

I have been using the following link to retrieve to decode option sets in a table

https://github.com/slavatrofimov/Synapse-Link-for-Dataverse-data-enrichment-in-Serverless-SQL-Pools/blob/main/SQL/Enrich%20Synapse%20Link%20for%20Dataverse%20Entities%20with%20Human-Readable%20Labels.sql

This works well if it is applied to Azure SQL Serverless Pool, however, can someone let me know if there is are any other methods that can used to achieve the same result but using Python?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

fabipfr 13 on at

Like (0)

Report

I understand your trying to decode option set values and what label they are mapped to?

e.g. statuscode 0=active, 1=inactive

if this is what you're looking for there is a popular browser extension "level up for dynamics". if installed, navigate to a record of the entity you want to know the option set values of. click the extension > Forms > Show Option Set Values.

Also there is the option to navigate to the table settings over make.powerapps.com. entity > columns > your option set column > edit. your able to see the labels and mapping there.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report
Hi Santiago,

Welcome to the community, and great question!

You're right that decoding option sets (choices) in Dynamics 365 using SQL via Azure Synapse Serverless Pools is a common approach. If you're looking to do the same using Python, here are a couple of methods:

1. Use the Web API Metadata Endpoint

Dynamics 365 exposes metadata via its Web API.

You can retrieve OptionSet metadata using Python and parse the labels.

Example:

import requests

url = "https://your_org.crm.dynamics.com/api/data/v9.2/EntityDefinitions(LogicalName='account')/Attributes(LogicalName='your_field')/Microsoft.Dynamics.CRM.PicklistAttributeMetadata"

headers = {

    "Authorization": "Bearer <access_token>",

    "Accept": "application/json"

}

response = requests.get(url, headers=headers)

data = response.json()

# Extract option labels

for option in data["OptionSet"]["Options"]:

    print(f"Value: {option['Value']}, Label: {option['Label']['UserLocalizedLabel']['Label']}")

Use Dataverse Client Libraries

If you're working in Databricks or another Python environment, you can use the Dataverse Web API with libraries like requests or msal for authentication.

Let me know if this helps, and please mark the response as helpful if it answered your question 😊

Best regards!

Was this reply helpful? Yes No

Join the conversation

Community site session details

How Decode Choices in Dynamics CRM 365 Using Python or SQL

1. Use the Web API Metadata Endpoint

Example:

Use Dataverse Client Libraries

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

How Decode Choices in Dynamics CRM 365 Using Python or SQL

1. Use the Web API Metadata Endpoint

Example:

Use Dataverse Client Libraries

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates