Microsoft Power Apps · JSON Structure

Microsoft Power Apps Dataverse Web Account Structure

Type: object Properties: 69
Business ApplicationsCloudEnterpriseLow-CodeMicrosoftNo-CodePower PlatformSoftware-as-a-Service

Account is a JSON Structure definition published by Microsoft Power Apps, describing 69 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

accountid name accountnumber accountcategorycode accountclassificationcode accountratingcode description emailaddress1 emailaddress2 emailaddress3 telephone1 telephone2 telephone3 fax websiteurl industrycode numberofemployees revenue revenue_base ownershipcode customertypecode businesstypecode sic tickersymbol stockexchange sharesoutstanding marketcap creditlimit creditonhold paymenttermscode preferredcontactmethodcode donotemail donotphone donotfax donotpostalmail donotbulkemail donotsendmm address1_name address1_line1 address1_line2 address1_line3 address1_city address1_stateorprovince address1_postalcode address1_country address1_county address1_telephone1 address1_fax address1_latitude address1_longitude

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

Raw ↑
{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "Account",
  "type": "object",
  "properties": {
    "accountid": {
      "type": "string"
    },
    "name": {
      "type": "string"
    },
    "accountnumber": {
      "type": "string"
    },
    "accountcategorycode": {
      "type": "integer"
    },
    "accountclassificationcode": {
      "type": "integer"
    },
    "accountratingcode": {
      "type": "integer"
    },
    "description": {
      "type": "string"
    },
    "emailaddress1": {
      "type": "string"
    },
    "emailaddress2": {
      "type": "string"
    },
    "emailaddress3": {
      "type": "string"
    },
    "telephone1": {
      "type": "string"
    },
    "telephone2": {
      "type": "string"
    },
    "telephone3": {
      "type": "string"
    },
    "fax": {
      "type": "string"
    },
    "websiteurl": {
      "type": "string"
    },
    "industrycode": {
      "type": "integer"
    },
    "numberofemployees": {
      "type": "integer"
    },
    "revenue": {
      "type": "number"
    },
    "revenue_base": {
      "type": "number"
    },
    "ownershipcode": {
      "type": "integer"
    },
    "customertypecode": {
      "type": "integer"
    },
    "businesstypecode": {
      "type": "integer"
    },
    "sic": {
      "type": "string"
    },
    "tickersymbol": {
      "type": "string"
    },
    "stockexchange": {
      "type": "string"
    },
    "sharesoutstanding": {
      "type": "integer"
    },
    "marketcap": {
      "type": "number"
    },
    "creditlimit": {
      "type": "number"
    },
    "creditonhold": {
      "type": "boolean"
    },
    "paymenttermscode": {
      "type": "integer"
    },
    "preferredcontactmethodcode": {
      "type": "integer"
    },
    "donotemail": {
      "type": "boolean"
    },
    "donotphone": {
      "type": "boolean"
    },
    "donotfax": {
      "type": "boolean"
    },
    "donotpostalmail": {
      "type": "boolean"
    },
    "donotbulkemail": {
      "type": "boolean"
    },
    "donotsendmm": {
      "type": "boolean"
    },
    "address1_name": {
      "type": "string"
    },
    "address1_line1": {
      "type": "string"
    },
    "address1_line2": {
      "type": "string"
    },
    "address1_line3": {
      "type": "string"
    },
    "address1_city": {
      "type": "string"
    },
    "address1_stateorprovince": {
      "type": "string"
    },
    "address1_postalcode": {
      "type": "string"
    },
    "address1_country": {
      "type": "string"
    },
    "address1_county": {
      "type": "string"
    },
    "address1_telephone1": {
      "type": "string"
    },
    "address1_fax": {
      "type": "string"
    },
    "address1_latitude": {
      "type": "number"
    },
    "address1_longitude": {
      "type": "number"
    },
    "address1_addresstypecode": {
      "type": "integer"
    },
    "address2_name": {
      "type": "string"
    },
    "address2_line1": {
      "type": "string"
    },
    "address2_line2": {
      "type": "string"
    },
    "address2_line3": {
      "type": "string"
    },
    "address2_city": {
      "type": "string"
    },
    "address2_stateorprovince": {
      "type": "string"
    },
    "address2_postalcode": {
      "type": "string"
    },
    "address2_country": {
      "type": "string"
    },
    "statecode": {
      "type": "integer"
    },
    "statuscode": {
      "type": "integer"
    },
    "createdon": {
      "type": "string"
    },
    "modifiedon": {
      "type": "string"
    },
    "versionnumber": {
      "type": "integer"
    },
    "_primarycontactid_value": {
      "type": "string"
    },
    "_parentaccountid_value": {
      "type": "string"
    },
    "_ownerid_value": {
      "type": "string"
    },
    "_transactioncurrencyid_value": {
      "type": "string"
    },
    "yominame": {
      "type": "string"
    }
  }
}

Work with this as data

Every JSON Structure 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 json structure

4 MCP tools reach this
  • find_json_structuresBrowse and filter every JSON Structure in the catalog.
  • 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 JSON Structure
curl "https://apis.io/api/v1/json-structures/microsoft-power-apps-dataverse-web-account-structure"
All json structure
curl "https://apis.io/api/v1/json-structures?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.

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