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. 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,