Querying Role Assignment Data

[kentlhastings]

Hello all,

I would like to query a particular folder and read its RoleAssignments in order to assign the same roles to some other folders and files, but this seems to require a call to QueryOptions as it's a nested property from the parent folder.

What is the proper way to execute this query, if ListItemAllFields doesn't have a QueryOptions member?

var source = await context.Web.GetFolderByServerRelativeUrlAsync(folderPath, x => x.ListItemAllFields.RoleAssignments);

Thank you!

[jansenbe]

You can use the QueryProperties LINQ method to realize this:

var source = await context.Web.GetFolderByServerRelativeUrlAsync(folder.ServerRelativeUrl, x => x.ItemCount, x => x.Folders, x => x.Files, x => x.ListItemAllFields.QueryProperties(p => p.RoleAssignments));

[jansenbe]

So this does not work?

var source = await batchContext.Web.GetFolderByServerRelativeUrlAsync(sourceFolderPath, x => x.ListItemAllFields.QueryProperties(x => x.RoleAssignments));

[kentlhastings]

Correct, I noticed with some other call I was trying to make yesterday that adding more parameters stopped the "unresolved tokens" error, but no luck in this case. I've been assuming that "unresolved tokens" means that we're trying to query incomplete data because properties are fetched piecemeal?

[kentlhastings]

@jansenbe Hi Bert, I was able to go deeper into the issue. The initial query (context.Web.GetFolderByServerRelativeUrlAsync(sourceFolderPath, x => x.ListItemAllFields.QueryProperties(x => x.RoleAssignments)) returns successfully, but we are failing immediately after by using the resulting IFolder.ListItemAllFields.RoleAssignments in a ForEach. When the GetEnumerator is called, the resulting query returns "unresolved tokens" error. I hope this helps!!

[jansenbe]

You need to add AsRequested() on the collection before querying it as otherwise we try to do a new server query

[kentlhastings]

Thank you!