Customer experience | Sales, Customer Insights,...

Read/Extract data from Dynamics CRM Sales via Python

(2) Share

Report

Posted on by Community member

Hello all,

I am very new to Dynamics CRM and have a question. Is there a way to read data from the dynamics CRM sales database via Python script?

Thanks a lot for your help.

I have the same question (0)

All responses (3)

Answers (0)

Dengliang Li Microsoft Employee on at

Like (0)

Report

Hi,

Please refer to the following links that may help.
web services - How can I connect to a Microsoft Dynamics CRM server using Python? - Stack Overflow

Python Dynamics 365 package to read write data - Stack Overflow
send data to create incident to Dynamics 365 with Python Requests post() Method - Stack Overflow

Best Regards,
Dengliang Li

Was this reply helpful? Yes No
Suggested answer

fabipfr 13 on at

Like (0)

Report

I developed a python package for that. It leverages pandas DataFrames to handle easy data transformations, imports or exports which is what you're looking for.

The repository and Readme is here:
https://github.com/fabipfr/DataversePython/blob/main/README.md

this package contains a get_rows() method where you can filter and choose columns to export.
check my blog for detailed examples of the function:
https://blog.fabianpfriem.com/2025/08/how-to-getrows-in-dataversepython.html

Installation: pip install DataversePython

hope this helps :)

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report
Hi there,

Yes, you can read data from Dynamics CRM (now part of Dynamics 365) using Python by leveraging the Web API provided by Microsoft.

Here’s a general approach:

1. Register an App in Azure

Go to the Azure Portal and register an application.

Assign the necessary API permissions for Dynamics CRM.

2. Authenticate via OAuth2

Use libraries like msal or requests in Python to authenticate and obtain an access token.

3. Use the Dynamics Web API

The base URL typically looks like:
https://<your_org>.crm.dynamics.com/api/data/v9.2/

You can then send GET requests to endpoints like:
accounts, contacts, opportunities, etc.

Example Python Snippet

import requests

headers = {

    'Authorization': 'Bearer <access_token>',

    'Content-Type': 'application/json',

    'OData-MaxVersion': '4.0',

    'OData-Version': '4.0'

}

url = 'https://your_org.crm.dynamics.com/api/data/v9.2/accounts'

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

data = response.json()

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

Read/Extract data from Dynamics CRM Sales via Python

1. Register an App in Azure

2. Authenticate via OAuth2

3. Use the Dynamics Web API

Example Python Snippet

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

Read/Extract data from Dynamics CRM Sales via Python

1. Register an App in Azure

2. Authenticate via OAuth2

3. Use the Dynamics Web API

Example Python Snippet

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