Skip to content

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 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 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"}