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
, orlistUrl
but not multiple. -t, --listTitle [listTitle]
- Title of the list. Specify either
listTitle
,listId
, orlistUrl
but not multiple. --listUrl [listUrl]
- Server- or site-relative URL of the list. Specify either
listTitle
,listId
, orlistUrl
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
orfields
but not both. -l, --filter [filter]
- OData filter to use to query the list of items with. Specify
camlQuery
orfilter
but not both. -p, --pageSize [pageSize]
- Number of list items to return. Specify
camlQuery
orpageSize
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 isfull
. --query [query]
- JMESPath query string. See http://jmespath.org/ for more information and examples
-o, --output [output]
- Output type.
json,text,csv,md
. Defaultjson
--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¶
[
{
"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,,