C#•4y ago

❔ How can I query a JSON doc for only objects with a specific property value?

I have a JSON object that looks like this:

{
    "pagedata": [
        {
            "id": "settings_tab_1",
            "data": {
                "oneSetting": {
                    "id": "InitialExperience",
                    "value": "1505209",
                    "options": [
                        {
                            "value": "option1"
                        }
                    ]
                },
                ...
        },
        {
            "id": "settings_tab_5",
            "data": {
                "someOtherSetting": {
                    "id": "ResultSortOrder",
                    "value": "1064235",
                    "options" [
                        {
                            "value": "option1"
                        }
                    ]                
                },
                ...
            }
        }
    ],
    "selectedTabId": "settings_tab_5",
    "statuscode": "OK",
    "props": {
        "type": "settings",
        "baseurl": "/settings"
    }
}

{
    "pagedata": [
        {
            "id": "settings_tab_1",
            "data": {
                "oneSetting": {
                    "id": "InitialExperience",
                    "value": "1505209",
                    "options": [
                        {
                            "value": "option1"
                        }
                    ]
                },
                ...
        },
        {
            "id": "settings_tab_5",
            "data": {
                "someOtherSetting": {
                    "id": "ResultSortOrder",
                    "value": "1064235",
                    "options" [
                        {
                            "value": "option1"
                        }
                    ]                
                },
                ...
            }
        }
    ],
    "selectedTabId": "settings_tab_5",
    "statuscode": "OK",
    "props": {
        "type": "settings",
        "baseurl": "/settings"
    }
}

{
    "pagedata": [
        {
            "id": "settings_tab_1",
            "data": {
                "oneSetting": {
                    "id": "InitialExperience",
                    "value": "1505209",
                    "options": [
                        {
                            "value": "option1"
                        }
                    ]
                },
                ...
        },
        {
            "id": "settings_tab_5",
            "data": {
                "someOtherSetting": {
                    "id": "ResultSortOrder",
                    "value": "1064235",
                    "options" [
                        {
                            "value": "option1"
                        }
                    ]                
                },
                ...
            }
        }
    ],
    "selectedTabId": "settings_tab_5",
    "statuscode": "OK",
    "props": {
        "type": "settings",
        "baseurl": "/settings"
    }
}

{
    "pagedata": [
        {
            "id": "settings_tab_1",
            "data": {
                "oneSetting": {
                    "id": "InitialExperience",
                    "value": "1505209",
                    "options": [
                        {
                            "value": "option1"
                        }
                    ]
                },
                ...
        },
        {
            "id": "settings_tab_5",
            "data": {
                "someOtherSetting": {
                    "id": "ResultSortOrder",
                    "value": "1064235",
                    "options" [
                        {
                            "value": "option1"
                        }
                    ]                
                },
                ...
            }
        }
    ],
    "selectedTabId": "settings_tab_5",
    "statuscode": "OK",
    "props": {
        "type": "settings",
        "baseurl": "/settings"
    }
}

The

pagedata

pagedata

pagedata

pagedata array here has two items, with

id

id

values of

settings_tab_1

settings_tab_1

settings_tab_1

settings_tab_1 and

settings_tab_5

settings_tab_5

settings_tab_5

settings_tab_5. How could I extract a version of this JSON with only one

pagedata

pagedata

pagedata

pagedata item, the one with an

id

id

value of

settings_tab_5

settings_tab_5

settings_tab_5

settings_tab_5?

Angius•12/12/22, 10:25 PM

Deserialize and LINQ

AAngius Deserialize and LINQ

Brady KellyOP•12/12/22, 10:39 PM

My first line of thought is to use LINQ before the data gets serialized, but I'm not certain to what extent I will be able to change the fetch & serialize code. I would prefer to avoid serializing, deserializing just to query, and then serializing again to return to the client. I guess it comes down to whether that brings a higher perf cost than filtering the JSON in place.

Angius•12/12/22, 10:40 PM

JSON will have to be converted into something understandable by C# one way or another

Sunder•12/12/22, 10:43 PM

deserializing the whole thing would probably the simplest and probably even the fastest

Sunder•12/12/22, 10:43 PM

if you want to filter it before deserializing you could do something like this

Sunder•12/12/22, 10:43 PM

var items = JsonSerializer
    .Deserialize<JsonElement>("json goes here")
    .GetProperty("pagedata")
    .EnumerateArray()
    .Where(element => element.GetProperty("id").GetString() == "settings_tab_5")
    .Select(element => element.Deserialize<Model>());

var items = JsonSerializer
    .Deserialize<JsonElement>("json goes here")
    .GetProperty("pagedata")
    .EnumerateArray()
    .Where(element => element.GetProperty("id").GetString() == "settings_tab_5")
    .Select(element => element.Deserialize<Model>());

Sunder•12/12/22, 10:43 PM

which is most likely slower then just deserializing

AAngius JSON will have to be converted into something understandable by C# one way or an...

Brady KellyOP•12/12/22, 10:56 PM

No, it comes from C# before I want to filter it, but then it's destined for an Angular client which has one deserialize method per

pagedata

pagedata

item as they all have different shapes

SSunder ```cs var items = JsonSerializer .Deserialize<JsonElement>("json goes here")...

Brady KellyOP•12/12/22, 11:01 PM

Thank you, it seems

JsonElement

JsonElement

is key to my last resort tactic, but in your example, in Deserialize<Model>Deserialize<Model>, what is

Model

Model

Brady KellyOP•12/12/22, 11:03 PM

That does look like some awfully slow LINQ though (no offence, it's not your fault, it's LINQ's fault), so I am probably better off with first just deserializing the whole object.

Sunder•12/12/22, 11:28 PM

Model is a class with whatever properties you want

Accord•12/13/22, 11:28 PM

Was this issue resolved? If so, run

/close

/close

otherwise I will mark this as stale and this post will be archived until there is new activity.

❔ How can I query a JSON doc for only objects with a specific property value?

Similar Threads

Similar Threads

Similar Threads