Skip to main content

pp dataverse table row list

Lists table rows for the given Dataverse table

Usage

m365 pp dataverse table row list [options]

Options

-e, --environmentName <environmentName>

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

--query [query]

JMESPath query string. See http://jmespath.org/ for more information and examples.

-o, --output [output]

Output type. json, text, csv, md, none. 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 --environmentName "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 --environmentName "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 --environmentName "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