Skip to content

spo listitem list

Gets a list of items from the specified list

Usage

m365 spo listitem list [options]

Options

-u, --webUrl <webUrl>
URL of the site from which the item should be retrieved
-i, --listId [listId]
ID of the list to retrieve items from. Specify listId or listTitle but not both
--id [id]
(deprecated. Use listId instead) ID of the list to retrieve items from. Specify id or title but not both
-t, --listTitle [listTitle]
Title of the list to retrieve items from. Specify listId or listTitle but not both
--title [title]
(deprecated. Use listTitle instead) Title of the list to retrieve items from. Specify id or title but not both
-q, --camlQuery [camlQuery]
CAML query to use to query the list of items with
-f, --fields [fields]
Comma-separated list of fields to retrieve. Will retrieve all fields if not specified and json output is requested. Specify camlQuery or fields but not both
-l, --filter [filter]
OData filter to use to query the list of items with. Specify camlQuery or filter but not both
-p, --pageSize [pageSize]
Number of list items to return. Specify camlQuery or pageSize but not both
-n, --pageNumber [pageNumber]
Page number to return if pageSize is specified (first page is indexed as value of 0)
-h, --help
output usage information
--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

Remarks

pageNumber is specified as a 0-based index. A value of 2 returns the third page of items.

If you want to specify a lookup type in the properties option, define which columns from the related list should be returned.

Examples

Get all items from a list named Demo List

m365 spo listitem list --listTitle "Demo List" --webUrl https://contoso.sharepoint.com/sites/project-x

From a list named Demo List get all items with title Demo list item using a CAML query

m365 spo listitem list --listTitle "Demo List" --webUrl https://contoso.sharepoint.com/sites/project-x --camlQuery "<View><Query><Where><Eq><FieldRef Name='Title' /><Value Type='Text'>Demo list item</Value></Eq></Where></Query></View>"

Get all items from a list with ID 935c13a0-cc53-4103-8b48-c1d0828eaa7f

m365 spo listitem list --listId 935c13a0-cc53-4103-8b48-c1d0828eaa7f --webUrl https://contoso.sharepoint.com/sites/project-x

Get all items from list named Demo List. For each item, retrieve the value of the ID, Title and Modified fields

m365 spo listitem list --listTitle "Demo List" --webUrl https://contoso.sharepoint.com/sites/project-x --fields "ID,Title,Modified"

Get all items from list named Demo List. For each item, retrieve the value of the ID, Title, Modified fields, and the value of lookup field Company

m365 spo listitem list --listTitle "Demo List" --webUrl https://contoso.sharepoint.com/sites/project-x --fields "ID,Title,Modified,Company/Title"

From a list named Demo List get all items with title Demo list item using an OData filter

m365 spo listitem list --listTitle "Demo List" --webUrl https://contoso.sharepoint.com/sites/project-x --filter "Title eq 'Demo list item'"

From a list named Demo List get the second batch of 10 items

m365 spo listitem list --listTitle "Demo List" --webUrl https://contoso.sharepoint.com/sites/project-x --pageSize 10 --pageNumber 2