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

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

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

Response¶

JSONTextCSV

[
  {
    "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
  }
]

Id   Title
---  -----
236  Test

FileSystemObjectType,Id,ServerRedirectedEmbedUri,ServerRedirectedEmbedUrl,ContentTypeId,Title,Modified,Created,AuthorId,EditorId,OData__UIVersionString,Attachments,GUID,ComplianceAssetId,OData__vti_ItemDeclaredRecord
0,236,,,0x01003CDBEB7138618C47A98D56499135D6EE0004C0F5794DEBCC4BAC981AC4AE1BD803,Test,2022-11-16T21:00:03Z,2022-11-16T20:56:31Z,10,10,6.0,1,cac57513-e870-4e7a-9f23-f4ea10e14f4e,,