Skip to main content

pp dataverse table row list

Lists table rows for the given Dataverse table

Usage​

pp dataverse table row list [options]

Options​

-e, --environment <environment>

The name of the environment

--entitySetName [entitySetName]

The entity set name of the table. Specify either entitySetName or tableName but not both

--tableName [tableName]

The name of the table. Specify either entitySetName or tableName but not both

--asAdmin

Run the command as admin for environments you do not have explicitly assigned permissions to

-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 all table rows for the given environment based on the entity set name

m365 pp dataverse table row list --environment "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --entitySetName "cr6c3_accounts"

List all table rows for the given environment based on the table name

m365 pp dataverse table row list --environment "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --tableName "cr6c3_account"

List all table rows for the given environment based on the entity set name as Admin

m365 pp dataverse table row list --environment "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --entitySetName "cr6c3_accounts" --asAdmin

Response​

[
  {
    "cr6c3_accountsid": "95c80273-3764-ed11-9561-000d3a4bbea4",
    "_owningbusinessunit_value": "6da087c1-1c4d-ed11-bba1-000d3a2caf7f",
    "statecode": 0,
    "statuscode": 1,
    "_createdby_value": "5fa787c1-1c4d-ed11-bba1-000d3a2caf7f",
    "_ownerid_value": "5fa787c1-1c4d-ed11-bba1-000d3a2caf7f",
    "modifiedon": "2022-11-14T16:14:45Z",
    "_owninguser_value": "5fa787c1-1c4d-ed11-bba1-000d3a2caf7f",
    "_modifiedby_value": "5fa787c1-1c4d-ed11-bba1-000d3a2caf7f",
    "versionnumber": 1413873,
    "createdon": "2022-11-14T16:14:45Z",
    "cr6c3_name": "Column1 value",
    "overriddencreatedon": null,
    "importsequencenumber": null,
    "_modifiedonbehalfby_value": null,
    "utcconversiontimezonecode": null,
    "_createdonbehalfby_value": null,
    "_owningteam_value": null,
    "timezoneruleversionnumber": null
  }
]
CTRL + M