Breyta

Deila með

Dataverse SDK for Python overview (preview)

Dataverse SDK for Python enables Python developers to interact directly with Microsoft Dataverse, making it easy to access, manage, and manipulate data stored in Dataverse using familiar Python syntax—no .NET knowledge required.

Important

  • This is a preview feature.
  • Preview features aren’t meant for production use and might have restricted functionality. These features are subject to supplemental terms of use, and are available before an official release so that customers can get early access and provide feedback.

Supporting Agentic Processes

The SDK empowers the development of automated, intelligent processes (agentic workflows) by allowing seamless integration with Python's ecosystem for data analysis, AI, and workflow orchestration.

Key Features

The following list describes key features of the SDK.

  • Data operations

    The SDK supports create, retrieve, update, and delete (CRUD) data operations using a single request, and also bulk operations. Data retrievals support OData options and paging, plus single or multiple "gets" in one call (as needed). Direct-SQL is supported for simple "SELECT" statements with paging.

  • Metadata operations on tables

    The SDK supports create, update, and delete (CUD) of tables, optional solution association, plus retrieve and list table definitions.

  • Simplified authentication

    The SDK supports authentication using Azure identity credentials that supports getting a token (get_token() method).

  • File upload

    Upload a file to a File column in a table.

  • OptionSet/enum handling

    OptionSet columns in an API call are mapped to enumeration values automatically.

  • Integration with pandas

    The API call return value is in JSON format, which can be mapped to a DataFrame.

  • SDK is published under open source licensing

Benefits

Dataverse SDK for Python lowers barriers for Python users, enabling rapid development of scalable, intelligent solutions on Microsoft Dataverse without .NET expertise.

The following list describes a few benefits of the SDK.

  • No need to learn .NET or C# — work entirely in Python
  • Accelerates automation, AI, and data-driven development
  • Accessible to data scientists, developers, and engineers across platforms

Limitations

Here are a few known limitations of the current (preview) release.

  • General purpose OData batching, upsert, and association operations aren't supported.
  • Dataverse DeleteMultiple functionality isn't yet available from the Python SDK.
  • Minimal retry policy support is in the SDK. Currently, only network errors are retried. Our code examples include another backoff for transient Dataverse consistency.
  • SQL JOINs are currently not supported, and there's limited support for a WHERE/TOP/ORDER BY clause.
  • Last updated on