JSONUTIL Deserialize Object with multi layer JSON input.
I have a Jsonstring with Multichild releation and trying to Deserialize the object and assigning to datatable using jsonutil. But JSONUTIL not deserilize the string .
Is it possible to deserialize multilayer jsonstring in JSONUTIL? if yes do we have any example .
Json Format
I have a Jsonstring with Multichild releation and trying to Deserialize the object and assigning to datatable using jsonutil. But JSONUTIL not deserilize the string .
Is it possible to deserialize multilayer jsonstring in JSONUTIL? if yes do we have any example .
Json Format
{ "firstName": "John", "lastName": "Smith", "isAlive": true, "age": 27, "address": { "streetAddress": "21 2nd Street", "city": "New York", "state": "NY", "postalCode": "10021-3100" }, "phoneNumbers": [ { "type": "home", "number": "212 555-1234" }, { "type": "office", "number": "646 555-4567" }, { "type": "mobile", "number": "123 456-7890" } ], "children": [], "spouse": null }
Infosys
IN
Example explained here
Cognizant Technology Solutions
US
Thanks ,. This demo has JSON string with parent alone . The json doesnt have child properties . in my above example phone number is parent and it has child like home , office , mobile.
when we do the deserize method with JSONUTIL this is failed ? Any one tried with this scnario and its working ? please guide us .
Infosys
IN
Write custom component code in c# as below.
First convert the json to class as per json structure using http://json2csharp.com/#
Copy the generated c# code into component class
In main class write below code
public RootObject JSONConvertObject(string json)
{
RootObject root = JsonConvert.DeserializeObject<RootObject>(json);
return root;
}
Generate the proxy for result and extract your required data.
RPA/RDA Practitioner
US
Hi
How might we do the same for this with an array?
[{
"firstName": "John",
"lastName": "Smith",
"isAlive": true,
"age": 27,
"address": {
"streetAddress": "21 2nd Street",
"city": "New York",
"state": "NY",
"postalCode": "10021-3100"
},
"phoneNumbers": [
{
"type": "home",
"number": "212 555-1234"
},
{
"type": "office",
"number": "646 555-4567"
},
{
"type": "mobile",
"number": "123 456-7890"
}
],
"children": [],
"spouse": null
},
Hi
How might we do the same for this with an array?
[{
"firstName": "John",
"lastName": "Smith",
"isAlive": true,
"age": 27,
"address": {
"streetAddress": "21 2nd Street",
"city": "New York",
"state": "NY",
"postalCode": "10021-3100"
},
"phoneNumbers": [
{
"type": "home",
"number": "212 555-1234"
},
{
"type": "office",
"number": "646 555-4567"
},
{
"type": "mobile",
"number": "123 456-7890"
}
],
"children": [],
"spouse": null
},
{
"firstName": "Aaron",
"lastName": "Anderson",
"isAlive": true,
"age": 29,
"address": {
"streetAddress": "20 2nd Street",
"city": "New York",
"state": "NY",
"postalCode": "10021-3100"
},
"phoneNumbers": [
{
"type": "home",
"number": "212- 661-1234"
},
{
"type": "office",
"number": "212 555-4567"
},
{
"type": "mobile",
"number": "123 456-7880"
}
],
"children": [],
"spouse": null
}]