This question already has an answer here:
- Find by key deep in a nested object 7 answers
I have to fight with JSON returns (which i get out of a XML response from Amazon Marketplace API). It contains arrays, subarrays and so on. At the moment i need to get only 2 values (AmazonOrderId and OrderItem object), but i don't find a way to address them directly. I still try for hours. Recursive things scare me a bit.
There are so many tools out there, also for beatifying or editing JSON. So is there possibly also a solution which shows all the property links recursively? Up to now i have not found something like this.
UPDATE: With the code from squint's answer i have build a quick and dirty tool which does what i wanted. Here it is: http://output.jsbin.com/gunixo
like:
myJSON.ListOrderItemsResponse.ListOrderItemsResult[0].OrderItems[0].OrderItem[0].QuantityOrdered
myJSON.ListOrderItemsResponse.ListOrderItemsResult[0].OrderItems[0].OrderItem[0].Title
...
This would really save time, in such a case.
{
"ListOrderItemsResponse": {
"$": {
"xmlns": "https://mws.amazonservices.com/Orders/2013-09-01"
},
"ListOrderItemsResult": [{
"OrderItems": [{
"OrderItem": [{
"QuantityOrdered": ["1"],
"Title": ["My Product Title"],
"ShippingTax": [{
"CurrencyCode": ["EUR"],
"Amount": ["0.00"]
}],
"PromotionDiscount": [{
"CurrencyCode": ["EUR"],
"Amount": ["0.00"]
}],
"ConditionId": ["New"],
"ASIN": ["BXXXI5W6M8"],
"SellerSKU": ["KNDR-BTTWSCH-BGSBNNY"],
"OrderItemId": ["67050234000659"],
"GiftWrapTax": [{
"CurrencyCode": ["EUR"],
"Amount": ["0.00"]
}],
"QuantityShipped": ["1"],
"ShippingPrice": [{
"CurrencyCode": ["EUR"],
"Amount": ["4.90"]
}],
"GiftWrapPrice": [{
"CurrencyCode": ["EUR"],
"Amount": ["0.00"]
}],
"ConditionSubtypeId": ["New"],
"ItemPrice": [{
"CurrencyCode": ["EUR"],
"Amount": ["15.77"]
}],
"ItemTax": [{
"CurrencyCode": ["EUR"],
"Amount": ["0.00"]
}],
"ShippingDiscount": [{
"CurrencyCode": ["EUR"],
"Amount": ["0.00"]
}]
}]
}],
"AmazonOrderId": ["304-6107803-0000000"]
}],
"ResponseMetadata": [{
"RequestId": ["dd64dd40-d939-4ea1-875d-xxxxxxxxxxxx"]
}]
}
}