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 isfull
. --query [query]
- JMESPath query string. See http://jmespath.org/ for more information and examples
-o, --output [output]
- Output type.
json,text,csv,md
. Defaultjson
--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"}