Microsoft Power Platform Metadata API

The Metadata API from Microsoft Power Platform — 3 operation(s) for metadata.

Documentation GitHub OpenAPI

Operations 3

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 /EntityDefinitions List all Dataverse table definitions · List all table (entity) definitions #

Ask an LLM

“What tables exist in my Dataverse environment?”

“Can I get the metadata for every entity at once?”

Tell an agent

List all table definitions in Dataverse.

Show the entity definitions for every table.

GET /EntityDefinitions(LogicalName='{logicalName}') Get metadata for one Dataverse table · Get metadata for a specific table by logical name #

Ask an LLM

“How do I read the schema of a single Dataverse table?”

“Where do I find a table's metadata by its logical name?”

Tell an agent

Get the table definition for {logicalName}.

Show metadata for the {logicalName} entity.

GET /WhoAmI Identify the signed-in Dataverse user · Identifies the currently authenticated user #

Ask an LLM

“Which user am I authenticated as against Dataverse?”

“How can I check my own user ID in the current session?”

Tell an agent

Tell me who I'm signed in as.

Return the current authenticated user's identity.

Specifications

⚙

OpenAPI

https://raw.githubusercontent.com/api-evangelist/power-platform/refs/heads/main/openapi/power-platform-metadata-api-openapi.yml

Other Resources

🔗

Overlay

https://raw.githubusercontent.com/api-evangelist/power-platform/refs/heads/main/overlays/power-platform-metadata-api-overlay.yaml

🔗

AgentSkill

https://raw.githubusercontent.com/api-evangelist/power-platform/refs/heads/main/skills/power-platform-dataverse-schema-discovery.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-metadata-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 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: Metadata
paths:
  /EntityDefinitions:
    get:
      tags:
      - Metadata
      summary: List all table (entity) definitions
      operationId: listEntityDefinitions
      responses:
        '200':
          description: Collection of EntityMetadata
          content:
            application/json:
              schema:
                type: object
  /EntityDefinitions(LogicalName='{logicalName}'):
    get:
      tags:
      - Metadata
      summary: Get metadata for a specific table by logical name
      operationId: getEntityDefinition
      parameters:
      - name: logicalName
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: EntityMetadata
          content:
            application/json:
              schema:
                type: object
        '404':
          description: Not found
  /WhoAmI:
    get:
      tags:
      - Metadata
      summary: Identifies the currently authenticated user
      operationId: whoAmI
      responses:
        '200':
          description: WhoAmIResponse
          content:
            application/json:
              schema:
                type: object
                properties:
                  UserId:
                    type: string
                    format: uuid
                  BusinessUnitId:
                    type: string
                    format: uuid
                  OrganizationId:
                    type: string
                    format: uuid
components:
  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