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