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
Copy link

Link copied!

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
Copy link

Link copied!

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

Like (0)

Report
Copy link

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates