Skip to main 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.

-l, --listId [listId]

ID of the list. Specify either listTitle, listId, or listUrl but not multiple.

-t, --listTitle [listTitle]

Title of the list. Specify either listTitle, listId, or listUrl but not multiple.

--listUrl [listUrl]

Server- or site-relative URL of the list. Specify either listTitle, listId, or listUrl but not multiple.

-q, --camlQuery [camlQuery]

CAML query to use to query the list of items with.

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

-s, --pageSize [pageSize]

Number of list items to return. Specify camlQuery or pageSize but not both. The default value is 5000.

-n, --pageNumber [pageNumber]

Page number to return if pageSize is specified (first page is indexed as value of 0).

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

Remarks​

This command retrieves all items in the list, even if there are more than 5000. Use the pageSize and pageNumber options if you only want a specific amount of items. When using a CAML query, include a RowLimit-node to get all items. If you run into list view threshold exceptions, remove any Query-conditions or filters and also include a RowLimit-node.

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

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 first 100 items

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

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 1

Get all items from a list by server-relative URL

m365 spo listitem list --listUrl /sites/project-x/documents --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><RowLimit Paged='TRUE'>5000</RowLimit></View>"

From a library named Demo Library with 5000+ files and folders, get all items recursively without running into a list view threshold exception, using a CAML query

m365 spo listitem list --listTitle "Demo List" --webUrl https://contoso.sharepoint.com/sites/project-x --camlQuery "<View Scope='RecursiveAll'><Query></Query><ViewFields><FieldRef Name='Title'/></ViewFields><RowLimit Paged='TRUE'>5000</RowLimit></View>"

Response​

[
  {
    "FileSystemObjectType": 0,
    "Id": 236,
    "ServerRedirectedEmbedUri": null,
    "ServerRedirectedEmbedUrl": "",
    "ContentTypeId": "0x01003CDBEB7138618C47A98D56499135D6EE0004C0F5794DEBCC4BAC981AC4AE1BD803",
    "Title": "Test",
    "Modified": "2022-11-16T21:00:03Z",
    "Created": "2022-11-16T20:56:31Z",
    "AuthorId": 10,
    "EditorId": 10,
    "OData__UIVersionString": "6.0",
    "Attachments": true,
    "GUID": "cac57513-e870-4e7a-9f23-f4ea10e14f4e",
    "ComplianceAssetId": null,
    "OData__vti_ItemDeclaredRecord": null
  }
]
CTRL + M