pp dataverse table get¶
List a dataverse table in a given environment
Usage¶
pp dataverse table get [options]
Options¶
-e, --environment <environment>
- 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 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 a table for the given environment
m365 pp dataverse table get -e "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --name "aaduser"
List a table for the given environment as Admin
m365 pp dataverse table get -e "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"
}
}
EntitySetName: aadusers
IsManaged : false
LogicalName : aaduser
SchemaName : aaduser
SchemaName,EntitySetName,LogicalName,IsManaged
aaduser,aadusers,aaduser,
# pp dataverse table get --environment "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --name "aaduser"
Date: 9/1/2023
Property | Value
---------|-------
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":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"}