API method GetItems with paged CAML query does not return paging information

[nero120]

Category

• Question
• Typo
• Bug
• Additional article idea

Querying list items using a POST request to /_api/Web/Lists/getByTitle('MyList')/GetItems with POST data:

{
    "query": {
        "ViewXml": "<View><RowLimit Paged='TRUE'>1</RowLimit></View>"
    }
}

gives the following response:

{
    "odata.metadata": "https://savillsukdev.sharepoint.com/sites/cpa-ci/_api/$metadata#SP.ApiData.ListItems",
    "value": [
        { ... }
    ]
}

Though the results appear to be paged (only one item returned), no paging information is included in the response object. I would expect to receive alongside the list items a ListItemCollectionPosition property that would include a PagingInfo string (as per the Client Object Model) which I can then use to retrieve the next batch (if any).

The data type returned by the query is SP.ApiData.ListItems which is not mentioned in the API Index and in fact should probably return a ListItemCollection which would include the paging information.

Please can you clarify?

[msft-github-bot]

Thank you for reporting this issue. We will be triaging your incoming issue as soon as possible.

[TjWheeler]

I am also looking for a fix for this issue. Is there any update on a resolution or workaround to get the ListItemCollectionPosition?

[DaleyKD]

+1. I need this, too.

[Aymkdn]

I need this, too… :(

To solve it, I build the 'PagingInfo' by myself with Paged=TRUE&p_ID= + the last item ID in the results.

[github-actions]

Thank you for taking the time to file an issue. We periodically archive older or inactive issues as part of our issue management process, which automatically closes them once they are archived.

If you’d like to understand more about why and how we handle archived (closed) issues, please see Our approach to closed issues.

We appreciate your contribution and if this is still an active issue with the latest SPFx versions, please do resubmit the details. We needed to perform a cleanup, so that we can start with a clean table with a new process. We apologize for the inconvenience this might cause.