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)

Sort by

Suggested answer

fabipfr 13 on at

Like (0)

Report
Copy link

Link copied!

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,423 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May 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

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates