Usage
m365 pp dataverse table row list
Description
Lists table rows for the given dataverse table
Options
| Option |
Description |
-n, --name<name> |
The name of the dataverse table to retrieve rows from |
-e, --environment <environment> |
The name of the environment to list all tables for |
--asAdmin |
Set, to retrieve the dataverse tables as admin for environments you are not a member of |
Examples
List all rows for the Appointment table
m365 pp dataverse table row list -environment "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --name "Appointment"
List all rows for the Appointment table as Admin
m365 pp dataverse table row list -environment "Default-2ca3eaa5-140f-4175-8261-3272edf9f339" --name "Appointment" --asAdmin
Additional Info
Since this is a list command we should not return all columns
Values can be retrieved from:
https://[DYNAMICSURL]/api/data/v9.0/[msdyn_schemaname]?fetchXml=<fetchmapping="logical"returntotalrecordcount="true"page="1"count="10"no-lock="false"><entityname="crd2e_myfirsttable"><attributename="crd2e_name"/><orderattribute="crd2e_name"descending="false"/></entity></fetch>
The msdyn_schemaname is the full name including the prefix; that value can be found using https://[DYNAMICSURL]/api/data/v9.0/msdyn_solutioncomponentsummaries?%24filter=((msdyn_componenttype%20eq%201))%20and%20msdyn_objectid%20eq%20%27fGUID%27&api-version=9.1 where the GUID is the table id that is passed as table name
Usage
m365 pp dataverse table row list
Description
Lists table rows for the given dataverse table
Options
-n, --name<name>-e, --environment <environment>--asAdminExamples
List all rows for the Appointment table
List all rows for the Appointment table as Admin
Additional Info
Since this is a list command we should not return all columns
Values can be retrieved from:
https://[DYNAMICSURL]/api/data/v9.0/[msdyn_schemaname]?fetchXml=<fetchmapping="logical"returntotalrecordcount="true"page="1"count="10"no-lock="false"><entityname="crd2e_myfirsttable"><attributename="crd2e_name"/><orderattribute="crd2e_name"descending="false"/></entity></fetch>The msdyn_schemaname is the full name including the prefix; that value can be found using
https://[DYNAMICSURL]/api/data/v9.0/msdyn_solutioncomponentsummaries?%24filter=((msdyn_componenttype%20eq%201))%20and%20msdyn_objectid%20eq%20%27fGUID%27&api-version=9.1where the GUID is the table id that is passed as table name