get values from nested JSON array

Question

How can I get individual values from this JSON? For example the SSN? Also, some items are arrays that can hold multiples (addresses, phones). What is the best way to parse this? I have tried with JArray.Parse(data), but still can't "find" the individual items. Can anyone point me in the right direction?

[{
    "firstName": "test",
    "middleName": "test",
    "lastName": "test"
},
{
    "addresses":
    [{
        "street": "test",
        "city": "test",
        "state": "test",
        "zip": "test"
    }]
},
{
    "DOB": ""
},
{
    "SSN": "123123123"
},
{
    "occupation": "test",
    "typeOfOccupation": "test"
},
{
    "phones":
    [{
        "phone": "",
        "type": ""
    }]
},
{
    "Email": ""
},
{
    "typeOfId": "",
    "idNumber": "",
    "expirationDate": ""
}]

Show your actual code. Parsing JSON in c# is a topic covered repeatedly and extensively. — tnw
– tnw, Commented Mar 21, 2017 at 18:10
This could be helpful. stackoverflow.com/questions/16079116/… — SWPhantom
– SWPhantom, Commented Mar 21, 2017 at 18:17

Matias Quaranta · Accepted Answer · 2017-03-21 19:55:41Z

0

You said you used JArray.Parse but are you using it as a dynamic? Check Query JSON with dynamic with JSON.Net.

var json = "[{ \"firstName\": \"test\", \"middleName\": \"test\", \"lastName\": \"test\" }, { \"addresses\": [{ \"street\": \"test\", \"city\": \"test\", \"state\": \"test\", \"zip\": \"test\" }] }, { \"DOB\": \"\" }, { \"SSN\": \"123123123\" }, { \"occupation\": \"test\", \"typeOfOccupation\": \"test\" }, { \"phones\": [{ \"phone\": \"\", \"type\": \"\" }] }, { \"Email\": \"\" }, { \"typeOfId\": \"\", \"idNumber\": \"\", \"expirationDate\": \"\" }]";
var data = JArray.Parse(json);
JToken ssn = data.SelectToken("$..SSN")
if(ssn!=null){
    Console.WriteLine(ssn.Value<string>());
}

Working fiddle here.

edited Mar 21, 2017 at 19:55

answered Mar 21, 2017 at 18:19

Matias Quaranta

15.8k1 gold badge25 silver badges52 bronze badges

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

4 Comments

fredjo Over a year ago

Thank you Matias. Is there any way to do this without knowing the position of the data? for example, sometimes the SSN might appear before the DOB (or there may be some other change to the structure)? Can I "find" the SSN anyways?

Matias Quaranta Over a year ago

Since it's an Array and not an Object, no, don't think you can unless you loop in the entire array looking for said attribute, not really efficient.

fredjo Over a year ago

this seems to work: dynamic arr = JArray.Parse(data); JToken ssn = arr.SelectToken("$..SSN"); do you see any problem with it?

Matias Quaranta Over a year ago

Interesting, never tried the dots on the SelectToken method, updated the fiddle with the working code using Value<string>()

Collectives™ on Stack Overflow

get values from nested JSON array

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related