Select object based on condition inside a nested array

Question

I have a Jarray of response and inside Jarray there is an array of Clients and based on the condition I need to select the object in Array Json is

JArray response = JArray.Parse(@"[
                  {
                    'ProviderTransactionID': '4c4c5b43-0dd6-490c-9a59-062e25c04019',
                     'IsSuccess': 'False',
                     'ErrorMessages': 'Some error',
                      'ClientInfo': [
                       {
                         'InternalID': '98367',
                         'UniqueID': '',
                         'ErrorMessages': 'ERROR:'
                       },
                       {
                         'InternalID': '98368',
                         'UniqueID': '',
                         'ErrorMessages': 'ERROR:'
                       }
                     ]
                   }
            ]");

For example, I need to select the ClientInfo Object where InternalID=98367

But

response.SelectToken("ClientInfo") returning null

response.SelectToken("ClientInfo") as JArray returning null

response.SelectTokens("ClientInfo") not returning any result

response.Children().Where(lst=>lst.SelectToken("ClientInfo").HasValues) is throwing Arg_PlatformNotSupported exception

response.SelectTokens("ClientInfo").Where(lst=>lst.Value<int>()==98367).FirstOrDefault() is returning null

can anyone please help me with how to get all ClientInfo object matching ID in an array of responses?

newtonsoft.com/json/help/html/Introduction.htm

JohnPete22
– JohnPete22

2019-10-25 13:59:53 +00:00
Commented Oct 25, 2019 at 13:59 — JohnPete22
– JohnPete22, Commented Oct 25, 2019 at 13:59

tcconstantin · Accepted Answer · 2019-10-25 14:59:24Z

6

Based on the documentation (https://www.newtonsoft.com/json/help/html/SelectToken.htm) a possible solution can be:

response.SelectTokens("$..ClientInfo[?(@.InternalID=='98367')]").ToList();

answered Oct 25, 2019 at 14:59

tcconstantin

3891 silver badge5 bronze badges

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

1 Comment

Chris Over a year ago

Great answer! Taught me something too so thank you.

Chris · Accepted Answer · 2019-10-25 14:55:57Z

If you don't want to use a class then you need something like this:

JArray jArray = JArray.Parse("[\r\n                  {\r\n                    'ProviderTransactionID': '4c4c5b43-0dd6-490c-9a59-062e25c04019',\r\n                     'IsSuccess': 'False',\r\n                     'ErrorMessages': 'Some error',\r\n                      'ClientInfo': [\r\n                       {\r\n                         'InternalID': '98367',\r\n                         'UniqueID': '',\r\n                         'ErrorMessages': 'ERROR:'\r\n                       },\r\n                       {\r\n                         'InternalID': '98368',\r\n                         'UniqueID': '',\r\n                         'ErrorMessages': 'ERROR:'\r\n                       }\r\n                     ]\r\n                   }\r\n            ]");

const string internalId = "98367";

foreach (JToken obj in jArray)
{
    IEnumerable<JToken> clientInfoObjects = obj.SelectToken("ClientInfo").Where(clientInfoJToken => clientInfoJToken["InternalID"].Value<string>() == internalId);
}

So because you are parsing into a JArray you need to iterate through the objects (although only one in your case).

Then you are at your object level so you can use .SelectToken("ClientInfo") which gives you a JToken (JArray) enabling you to use .Where() to filter the objects to your requirements.

The result is an IEnumerable<JToken> which will be the ClientInfo objects with the id you specify.

Amogh Sharma · Accepted Answer · 2019-10-29 09:14:25Z

You can query JSON with LINQ as below:

var Result = (from p in response
                           select new
                           {
                               Errors = (from z in p["ClientInfo"]
                                         where (string)z["InternalID"] == "98368"
                                         select new
                                         {
                                             InternalID = (string)z["InternalID"],
                                             UniqueID = (string)z["UniqueID"],
                                             ErrorMessages = (string)z["ErrorMessages"],
                                         }).ToList()

                           }).ToList();

we can use anonymous type .net will create class intrenally. if you want to use Parent data element also say ProviderTransactionID below code will work for that also

        var Result = (from p in response
                           select  (from z in p["ClientInfo"]
                                         where (int)z["InternalID"] == 98368
                                         select new
                                         {
                                             ProviderTransactionID = (string)p["ProviderTransactionID"],
                                             InternalID = (int)z["InternalID"],
                                             UniqueID = (string)z["UniqueID"],
                                             ErrorMessages = (string)z["ErrorMessages"],
                                         }
                                         ).ToList()

                           ).ToList();

Collectives™ on Stack Overflow

Select object based on condition inside a nested array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related