Skip to content

pp dataverse table list

Lists dataverse tables in a given environment

Usage

pp dataverse table list [options]

Options

-e, --environment <environment>
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 full.
--query [query]
JMESPath query string. See http://jmespath.org/ for more information and examples
-o, --output [output]
Output type. json,text,csv,md. 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 -e "Default-2ca3eaa5-140f-4175-8261-3272edf9f339"

List all tables for the given environment as Admin

m365 pp dataverse table list -e "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"
    }
  }
]
SchemaName EntitySetName  LogicalName  IsManaged
---------- -------------  -----------  ---------
aaduser    aadusers       aaduser      true
SchemaName,EntitySetName,LogicalName,IsManaged
aaduser,aadusers,aaduser,1
# pp dataverse table list --environment "Default-2ca3eaa5-140f-4175-8261-3272edf9f339"

Date: 9/1/2023

Property | Value
---------|-------
MetadataId | "47a9636e-b7a1-4a8d-858a-ebce7d9b7526
IsCustomEntity | true
IsManaged | false
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"}