Skip to main content

pp dataverse table get

List a dataverse table in a given environment

Usage​

m365 pp dataverse table get [options]

Options​

-e, --environmentName <environmentName>

The name of the environment to list a table for.

-n, --name<name>

The name of the dataverse table to retrieve rows from.

--asAdmin

Set, to retrieve the dataverse table as admin for environments you are not a member of.

-h, --help [help]

Output usage information. Optionally, specify which section of command's help you want to see. Allowed values are options, examples, remarks, response, full. Default is options.

--query [query]

JMESPath query string. See http://jmespath.org/ for more information and examples.

-o, --output [output]

Output type. json, text, csv, md, none. Default json.

--verbose

Runs command with verbose logging.

--debug

Runs command with debug logging.

Examples​

List a table for the given environment

m365 pp dataverse table get --environmentName "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --name "aaduser"

List a table for the given environment as Admin

m365 pp dataverse table get --environmentName "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --name "aaduser" --asAdmin

Response​

{
  "MetadataId": "84f4c125-474d-ed11-bba1-000d3a2caf7f",
  "IsCustomEntity": true,
  "IsManaged": false,
  "SchemaName": "aaduser",
  "IconVectorName": null,
  "LogicalName": "aaduser",
  "EntitySetName": "aadusers",
  "IsActivity": false,
  "DataProviderId": null,
  "IsRenameable": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "isrenameable"
  },
  "IsCustomizable": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "iscustomizable"
  },
  "CanCreateForms": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "cancreateforms"
  },
  "CanCreateViews": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "cancreateviews"
  },
  "CanCreateCharts": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "cancreatecharts"
  },
  "CanCreateAttributes": {
    "Value": true,
    "CanBeChanged": false,
    "ManagedPropertyLogicalName": "cancreateattributes"
  },
  "CanChangeTrackingBeEnabled": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "canchangetrackingbeenabled"
  },
  "CanModifyAdditionalSettings": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "canmodifyadditionalsettings"
  },
  "CanChangeHierarchicalRelationship": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "canchangehierarchicalrelationship"
  },
  "CanEnableSyncToExternalSearchIndex": {
    "Value": true,
    "CanBeChanged": true,
    "ManagedPropertyLogicalName": "canenablesynctoexternalsearchindex"
  }
}
CTRL + M