Problem parsing json

Getting Started
1

I have been banging my head against the wall for the past few hours trying to work out how to parse the following JSON data. No matter what I do I just can’t find a way to access the keys/values under the “details” section. I can read the top level e.g. status, keystatus using JSONitem but can’t find a way to read the data like product_name, category etc. I have tried lookup and value but no luck. Any ideas? Thanks

{
“status”: 0,
“keystatus”: “valid”,
“result”: [
{
“barcode”: “9780140157376”,
“type”: “EAN”,
“details”: {
“product_name”: “Haroun and the Sea of Stories”,
“prod_details”: “eBooks - Odyssey Editions”,
“barcode_formats”: “”,
“category”: “Books/Children’s Books/Science Fiction & Fantasy/Fantasy & Magic”,
“author”: “Salman Rushdie”,
“publisher”: “Odyssey Editions”,
“artist”: “”,
“manufacturer”: “Odyssey Editions”,
“actor”: “”,
“director”: “”,
“manufacturer_part_number”: “”,
“model”: “”,
“features”: null,
“long_description”: “When Haroun Khalifa\u2019s father, the renowned storyteller Rashid Khalifa, loses his gift of gab, Haroun knows he has to help. Soon, he\u2019s tumbled headfirst into an adventure story of his own, journeying toward the legendary Sea of Stories on the back of a flying Hoopoe bird. There, he finds a host of comical, unforgettable new friends, from Iff the Water Genie to Blabbermouth the page, and at the end of his quest, a formidable enemy \u2013 the Prince of Silence, Khattam-Shud himself. At once vastly humorous and deeply tender, Haroun and the Sea of Stories is a fantastical, witty contemporary fable and a powerful statement about the importance of storytelling. Salman Rushdie has created an instant classic - a dazzling read for children and adults alike that both celebrates and embodies the magic of fiction.”,
“brand”: “”,
“label”: “Odyssey Editions”,
“clothingsize”: “”,
“color”: “”,
“genre”: “”,
“product_group”: “eBooks”,
“product_type_subcategory”: “”,
“height”: “”,
“length”: “”,
“width”: “”,
“weight”: “”
},
“images”: {
“0”: “http://ecx.images-amazon.com/images/I/41QM8DkG3wL.jpg”
},
“stores”: {
“0”: {
“min_price”: “”,
“max_price”: “”,
“title”: “Haroun and the Sea of Stories”,
“category”: “Books/Children’s Books/Science Fiction & Fantasy/Fantasy & Magic”,
“manufacturer”: “Odyssey Editions”,
“url”: “https://www.amazon.com/Haroun-Sea-Stories-Salman-Rushdie-ebook/dp/B00D4CMJ5U%3FSubscriptionId%3DAKIAJL6OJYQM2ZLPMWEA%26tag%3D%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB00D4CMJ5U”,
“advertiser”: “Amazon.com”,
“currency”: “$”
},
“1”: {
“min_price”: “1.99”,
“max_price”: “”,
“title”: “Haroun And The Sea Of Stories”,
“category”: “Languages & Literature > British Literature > Other 20th and 21st Century British Literature”,
“manufacturer”: “Penguin Ra”,
“url”: “http://www.anrdoezrs.net/click-7724505-11390067?url=http%3A%2F%2Fwww.textbooks.com%2FHaroun-and-the-Sea-of-Stories%2F9780140157376%2FSalman-Rushdie.php”,
“advertiser”: “Textbooks.com”,
“currency”: “$”
},
“2”: {
“min_price”: “3.95”,
“max_price”: “”,
“title”: “Haroun And The Sea Of Stories”,
“category”: "Better World Books ",
“manufacturer”: “”,
“url”: “http://www.jdoqocy.com/click-7724505-10549075?url=http%3A%2F%2Fwww.betterworldbooks.com%2Fharoun-and-the-sea-of-stories-id-9780140157376.aspx”,
“advertiser”: “Betterworld.com - New, Used, Rare Books & Textbooks”,
“currency”: “$”
},
“3”: {
“min_price”: “7.99”,
“max_price”: “18.19”,
“title”: “Haroun And The Sea Of Stories”,
“category”: “Nonfiction”,
“manufacturer”: “”,
“url”: “http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10042&campid=1&customid=&lgeo=1&vectorid=229466&item=182337363662”,
“advertiser”: “Ebay.com”,
“currency”: “$”
},
“4”: {
“min_price”: “9.28”,
“max_price”: “”,
“title”: “Haroun And The Sea Of Stories”,
“category”: “Children’s Books”,
“manufacturer”: “”,
“url”: “http://linksynergy.walmart.com/link?id=dEVrlOMDETI&offerid=223073.518868&type=15&murl=http%3A%2F%2Fwww.walmart.com%2Fip%2FHaroun-and-the-Sea-of-Stories%2F518868”,
“advertiser”: “Wal-mart.com Usa, Llc”,
“currency”: “$”
},
“5”: {
“min_price”: “9.59”,
“max_price”: “”,
“title”: “Haroun And The Sea Of Stories”,
“category”: “Fiction > General”,
“manufacturer”: “”,
“url”: “http://www.anrdoezrs.net/click-7724505-10876509?url=http%3A%2F%2Fwww.booksamillion.com%2Fp%2FHaroun-Sea-Stories%2FSalman-Rushdie%2F9780140157376”,
“advertiser”: “Booksamillion.com”,
“currency”: “$”
},
“6”: {
“min_price”: “20.92”,
“max_price”: “”,
“title”: “Haroun And The Sea Of Stories”,
“category”: “Books”,
“manufacturer”: “Penguin Gr”,
“url”: “http://www.tkqlhce.com/click-7724505-11793338?url=https%3A%2F%2Fwww.neweggbusiness.com%2FProduct%2FProduct.aspx%3FItem%3D9SIV0UN4FF1359%26nm_mc%3Dafc-cjb2b%26cm_mmc%3Dafc-cjb2b--Books--Penguin%2BGroup--9SIV0UN4FF1359",
“advertiser”: “Newegg Business”,
“currency”: “$”
},
“7”: {
“min_price”: “20.92”,
“max_price”: “”,
“title”: “Haroun And The Sea Of Stories”,
“category”: “Books”,
“manufacturer”: “Penguin Gr”,
“url”: "http://www.jdoqocy.com/click-7724505-12165498?url=http%3A%2F%2Fwww.newegg.com%2FProduct%2FProduct.aspx%3FItem%3D9SIA9UT4183865%26nm_mc%3DAFC-C8Junction-MKPL%26cm_mmc%3DAFC-C8Junction-MKPL--Books--Penguin%2BGroup--9SIA9UT4183865”,
“advertiser”: “Newegg.com”,
“currency”: “$”
}
},
“reviews”: [
{
“source”: “”,
“title”: “”,
“user”: “”,
“date”: “”,
“rating”: “”,
“text”: “”,
“url”: “”,
“available”: “N”
}
]
}
]
}

2

The value of the “result” key is an array. You access it by index. The 0-th element of the array is a jsonitem containing keys “barcode”, “type”, “details”, “images”, “stores”, etc.

dim js_complete, js_array, js_result, js_details as JsonItem
dim product_name, category as string

js_complete = New JsonItem(json_string)
js_array= js_complete.value("result")
js_result = js_array.value(0)
js_details = js_result.value("details")
product_name = js_details.value("product_name")
category = js_details.value("category")
3

Thanks Tim, you have said my sore head :wink: I was going about it totally the wrong way!!