Skip to main content

pp dataverse table list

Lists dataverse tables in a given environment

Usage​

m365 pp dataverse table list [options]

Options​

-e, --environmentName <environmentName>

The name of the environment to list all tables for.

--asAdmin

Set, to retrieve the dataverse tables 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 all tables for the given environment.

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

List all tables for the given environment as Admin.

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

Response​

[
  {
    "MetadataId":"47a9636e-b7a1-4a8d-858a-ebce7d9b7526",
    "IsCustomEntity":true,
    "IsManaged":true,
    "SchemaName":"aaduser",
    "IconVectorName":null,
    "LogicalName":"aaduser",
    "EntitySetName":"aadusers",
    "IsActivity":false,
    "DataProviderId":"54629ed7-0cd3-4c85-9b6c-ea5f8548a9aa",
    "IsRenameable":{
      "Value":true,
      "CanBeChanged":false,
      "ManagedPropertyLogicalName":"isrenameable"
    },
    "IsCustomizable":{
      "Value":true,
      "CanBeChanged":false,
      "ManagedPropertyLogicalName":"iscustomizable"
    },
    "CanCreateForms":{
      "Value":true,
      "CanBeChanged":false,
      "ManagedPropertyLogicalName":"cancreateforms"
    },
    "CanCreateViews":{
      "Value":true,
      "CanBeChanged":false,
      "ManagedPropertyLogicalName":"cancreateviews"
    },
    "CanCreateCharts":{
      "Value":false,
      "CanBeChanged":false,
      "ManagedPropertyLogicalName":"cancreatecharts"
    },
    "CanCreateAttributes":{
      "Value":true,
      "CanBeChanged":false,
      "ManagedPropertyLogicalName":"cancreateattributes"
    },
    "CanChangeTrackingBeEnabled":{
      "Value":false,
      "CanBeChanged":false,
      "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