Microsoft Power Platform Records API

The Records API from Microsoft Power Platform — 2 operation(s) for records.

Documentation GitHub OpenAPI

Operations 5

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /{entitySetName} Query records from a Dataverse table · Retrieve records from a Dataverse table #

Ask an LLM

“How do I pull rows out of a Dataverse table?”

“Can I filter, sort and pick columns when querying Dataverse records?”

Tell an agent

List records from the {entitySetName} table.

Query {entitySetName} where {filter}, sorted by {orderby}.

POST /{entitySetName} Create a record in a Dataverse table · Create a record #

Ask an LLM

“How do I add a new row to a Dataverse table?”

“Can I insert a record into any table by its entity set name?”

Tell an agent

Create a new record in the {entitySetName} table.

Add a row to {entitySetName}.

GET /{entitySetName}({id}) Retrieve a single Dataverse record by id · Retrieve a record by id #

Ask an LLM

“How do I fetch one Dataverse row when I know its GUID?”

“Can I choose which columns come back for a single record?”

Tell an agent

Get record {id} from {entitySetName}.

Fetch columns {select} of record {id} in {entitySetName}.

PATCH /{entitySetName}({id}) Update or upsert a Dataverse record · Update or upsert a record #

Ask an LLM

“How do I change fields on an existing Dataverse row?”

“Can I upsert a record so it's created if the id doesn't exist yet?”

Tell an agent

Update record {id} in {entitySetName}.

Upsert the {entitySetName} row with id {id}.

DELETE /{entitySetName}({id}) Delete a Dataverse record · Delete a record #

Ask an LLM

“How do I remove a row from a Dataverse table?”

“Can I delete a single record by its id?”

Tell an agent destructive · confirm first

Delete record {id} from the {entitySetName} table.

Remove the {entitySetName} row with id {id}.

Specifications

⚙

OpenAPI

https://artifacts.apis.io/power-platform/openapi/power-platform-records-api-openapi.yml

Other Resources

🔗

Overlay

https://artifacts.apis.io/power-platform/overlays/power-platform-records-api-overlay.yaml

🔗

AgentSkill

https://artifacts.apis.io/power-platform/skills/power-platform-dataverse-record-operations.md

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/power-platform:microsoft-power-platform-records-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: Microsoft Dataverse Web Metadata Records API
  description: The Microsoft Dataverse Web API implements OData v4 over the Dataverse data platform that powers Microsoft Power Platform (Power Apps, Power Automate, Dynamics 365). It supports CRUD operations on tables, execution of actions and functions, and metadata queries. Authentication is via Microsoft Entra ID OAuth 2.0 against the org URL.
  version: '9.2'
servers:
- url: https://{org}.api.crm.dynamics.com/api/data/v9.2
  description: Dataverse Web API for a specific environment
  variables:
    org:
      default: contoso
      description: The Dataverse organization name (subdomain).
security:
- oauth2: []
tags:
- name: Records
paths:
  /{entitySetName}:
    get:
      tags:
      - Records
      summary: Retrieve records from a Dataverse table
      operationId: listRecords
      parameters:
      - name: entitySetName
        in: path
        required: true
        schema:
          type: string
        example: accounts
      - name: $select
        in: query
        schema:
          type: string
      - name: $filter
        in: query
        schema:
          type: string
      - name: $orderby
        in: query
        schema:
          type: string
      - name: $top
        in: query
        schema:
          type: integer
      - name: $expand
        in: query
        schema:
          type: string
      - name: $count
        in: query
        schema:
          type: boolean
      responses:
        '200':
          description: Collection of records
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/RecordCollection'
    post:
      tags:
      - Records
      summary: Create a record
      operationId: createRecord
      parameters:
      - name: entitySetName
        in: path
        required: true
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
      responses:
        '204':
          description: Created (no content)
        '201':
          description: Created
  /{entitySetName}({id}):
    get:
      tags:
      - Records
      summary: Retrieve a record by id
      operationId: getRecord
      parameters:
      - name: entitySetName
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
          format: uuid
      - name: $select
        in: query
        schema:
          type: string
      responses:
        '200':
          description: Record
          content:
            application/json:
              schema:
                type: object
        '404':
          description: Not found
    patch:
      tags:
      - Records
      summary: Update or upsert a record
      operationId: updateRecord
      parameters:
      - name: entitySetName
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
          format: uuid
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
      responses:
        '204':
          description: Updated
    delete:
      tags:
      - Records
      summary: Delete a record
      operationId: deleteRecord
      parameters:
      - name: entitySetName
        in: path
        required: true
        schema:
          type: string
      - name: id
        in: path
        required: true
        schema:
          type: string
          format: uuid
      responses:
        '204':
          description: Deleted
components:
  schemas:
    RecordCollection:
      type: object
      properties:
        '@odata.context':
          type: string
        '@odata.count':
          type: integer
        value:
          type: array
          items:
            type: object
  securitySchemes:
    oauth2:
      type: oauth2
      description: Microsoft Entra ID OAuth 2.0. Use the resource/scope corresponding to the Dataverse environment, e.g. https://{org}.api.crm.dynamics.com/.default for client credentials.
      flows:
        authorizationCode:
          authorizationUrl: https://login.microsoftonline.com/common/oauth2/v2.0/authorize
          tokenUrl: https://login.microsoftonline.com/common/oauth2/v2.0/token
          scopes:
            https://{org}.api.crm.dynamics.com/.default: Full Dataverse access scoped to the environment
x-generated-from: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/overview
x-generated-by: claude-genwave10-08-2026-05-23