C# getting json with array in it from Cosmos db

Question

I need to retrieve the following JSON from my CosmosDb, but I think the C# code (which works for a simple JSON structure), needs help. The response just shows

{ RolePermission[0]  } 



var response = this.client.CreateDocumentQuery<RolePermission>(
                       UriFactory.CreateDocumentCollectionUri("demo", "RoleMenus"), queryOptions)
                       .Where(f => f.RoleName == roleName).AsEnumerable().ToArray();

and the JSON is:

{
"id": "1",
"RoleName": "Admin",
"Menus": [
    {
        "Item": "Admin",
        "Display": "Admin",
        "Granted": true
    },
    {
        "Item": "Users",
        "Display": "Users",
        "Granted": true
    }
],
}

The Class defn, I want to get it into is:

public class RolePermission
{
    [DisplayName("Role Name")]
    public string RoleName { get; set; }
    public List<Menus> Menus { get; set; }
}

public class Menus
{
    public string Item { get; set; }
    public string Display { get; set; }
    public bool Granted { get; set; }
}

I just need the menus part of the JSON

Thanks

Ok, just realized I did'nt put in the class, but have now, in the question — Neal Rogers
– Neal Rogers, Commented Feb 22, 2022 at 16:05
@Jay , then the f.RoleName fails as List<RolePermission> does not contain a defn for RoleName — Neal Rogers
– Neal Rogers, Commented Feb 22, 2022 at 16:16

Sajeetharan · Accepted Answer · 2022-02-22 17:31:24Z

1

According to the data that you provided and the code , it should return the list you need "Menus" with the below query

var response = this.client.CreateDocumentQuery<RolePermission>(UriFactory.CreateDocumentCollectionUri("demo", "RoleMenus"), queryOptions).Where(f => f.RoleName == roleName).ToList();

Make sure you have the correct data inserted with the field RoleName in the container.

answered Feb 22, 2022 at 17:31

Sajeetharan

223k65 gold badges370 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# getting json with array in it from Cosmos db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related