LoadItemsByCamlQueryAsync not working with FolderServerRelativeUrl

[mortenfa]

Category

• Bug

Describe the bug

When querying with LoadItemsByCamlQueryAsync on a semi large list (10000 items) querying a specific folder throws REST exception

Steps to reproduce

This is working

var viewXml = $@"<View Scope='RecursiveAll'><RowLimit Paged='TRUE'>{rowLimit}</RowLimit><Where><Eq><FieldRef Name='FSObjType' /><Value Type='Integer'>1</Value></Eq></Where><ViewFields><FieldRef Name='ID' /><FieldRef Name='FileRef' /></ViewFields></View>";

await sourceList.LoadItemsByCamlQueryAsync(new CamlQueryOptions() { ViewXml = viewXml, PagingInfo = nextPage }

This throws the item limit exception with the same viewXml

await sourceList.LoadItemsByCamlQueryAsync(new CamlQueryOptions() { ViewXml = viewXml, FolderServerRelativeUrl = sourceList.RootFolder.ServerRelativeUrl + "/Testfolder", PagingInfo = nextPage });

Expected behavior

Results

Environment details (development & target environment)

Visual Studio latest version

Additional context

Thanks for your contribution! Sharing is caring.

[jansenbe]

@mortenfa : can you try to include the folder filtering in your CAML query, see #839 for some inspiration on how to do so. There's also a limitation with the used SharePoint API on special chars in the provided folder, so in my opinion it's anyhow better to implement this at CAML level. See also the notes of the related docs: https://pnp.github.io/pnpcore/using-the-sdk/listitems-intro.html#c-getting-list-items-via-the-loaditemsbycamlquery-approach

[jansenbe]

@mortenfa : did you manage to get unblocked?

[mortenfa]

not yet, I'll take a look in the weekend 😊👍

[mortenfa]

@jansenbe : Still not working. Getting this quite unusable error:

"SharePoint Rest service exception"

"Cannot complete this action. Please try again."

with this rowLimit:500 :

$@"<View Scope='RecursiveAll'> <RowLimit Paged='TRUE'>{rowLimit}</RowLimit> <ViewFields><FieldRef Name='FileDirRef' /><FieldRef Name='FileRef' /></ViewFields> <Query> <Where> <Or> <BeginsWith> <FieldRef Name='FileDirRef' /> <Value Type='Text'>{sourceList.RootFolder.ServerRelativeUrl}/_Documents</Value> </BeginsWith> <BeginsWith> <FieldRef Name='FileDirRef' /> <Value Type='Text'>{sourceList.RootFolder.ServerRelativeUrl}/_Emails</Value> </BeginsWith> <BeginsWith> <FieldRef Name='FileDirRef' /> <Value Type='Text'>{sourceList.RootFolder.ServerRelativeUrl}/Formalia</Value> </BeginsWith> </Or> </Where> </Query> </View>"

[bajce]

@mortenfa did you try using LoadListDataAsStreamAsync (see #1044).

[mortenfa]

@bajce : yes, tried that also