I was trying to use Advanced Query on list items but its throws error ?

Question

Hello,

I was trying to Use Query filter with Graph SDK v5 (latest ).
was referring this article :
https://learn.microsoft.com/en-us/graph/filter-query-parameter?context=graph%2Fapi%2F1.0&view=graph-rest-1.0&tabs=csharp

Call in the .net c# code looks like

var lists = GraphServiceClient.Sites["siteid"].Lists.GetAsync((x) =>
            {
               
                    x.QueryParameters.Filter = "listProp/template eq 'genericList'";


            }).Result;

i have verified that there are properties ListProp and inside that there is a string property template which has values genericList/ documentLibrary but when i try to query it throws error.

also i have tried linq in filter like

x.QueryParameters.Filter = "items/any(s:s/ContentType.Name eq 'Folder')";

but this too throws error.

can anybody please help !

Answer 1

Hi @Parth Jani

It is not yet supported to use the $filter query parameter to filter the list attribute, you can only traverse the site list set, and then execute the if conditional statement to filter the result set:

var graphClient = new GraphServiceClient(requestAdapter);

var result = await graphClient.Sites["{site id}"].Lists.GetAsync();

for (int i = 0; i < result.Value.Count; i++) {

    if (result.Value[i].ListProp.Template == "genericList") {

        Console.WriteLine(result.Value[i].Id);

    }

}

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Answer 2

Hello,

Thanks for reaching out. There is no property called listProp. Please refer to article https://learn.microsoft.com/en-us/graph/api/resources/list?view=graph-rest-1.0 for available list of properties for the get lists endpoint. There is a property called 'list' of type 'listinfo' that contains a sub-property Template. You can find more information on the 'list' property here. Additionally, filtering is not supported for the list property. I would suggest client-side filtering after retrieving the lists.

The any filter can only be used in a collection. The 'list' property is not a collection.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Thanks.