JSON 101 Help

[cf1flyboy]

New to JSON and unable to get any results out of my test script
Seems like I am missing something simple, anyone have any ideas???

Code: Select all

/*
MyJSON:
{
"getallpricesresult": {
"items": {
"item": {
"itemid": "ItemA",
"description”: "Test Item A",
"upc": "1234567890123",
"currenteffectivedate": "9/1/2017"
"currentprice": "26.00",
"nexteffectivedate": "11/1/2017",
"nexteffectiveprice": "28.00"
}
"item": {
"itemid": "ItemB",
"description”: "Test Item B",
"upc": "1234567890124",
"currenteffectivedate": "9/1/2017"
"currentprice": "29.00",
"nexteffectivedate": "11/1/2017",
"nexteffectiveprice": "24.00"
}
"item": {
"itemid": "ItemC",
"description”: "Test Item C",
"upc": "1234567890125",
"currenteffectivedate": "9/1/2017"
"currentprice": "29.00",
"nexteffectivedate": "",
"nexteffectiveprice": ""
}
}
}
}
*/

LabelToVar>MyJSON,sJSON
JSONParse>sJSON,items,result1
JSONParse>sJSON,itemid,result2
JSONParse>sJSON,Item[2].UPC,result3

[Marcus Tettmar]

Well apart from the syntax of the JSONParse statement, that's not valid JSON. Arrays should be in [ ] and identifiers need to be unique so "item" is erroneous. You also have the wrong quote character after description and a missing comma after the currenteffectivedate value.

Here's the fixed up version and a working example to get the description values:

Code: Select all

/*
MyJSON:
{  
   "getallpricesresult":{  
      "items":[  
         {  
            "itemid":"ItemA",
            "description":"Test Item A",
            "upc":"1234567890123",
            "currenteffectivedate":"9/1/2017",
            "currentprice":"26.00",
            "nexteffectivedate":"11/1/2017",
            "nexteffectiveprice":"28.00"
         },
         {  
            "itemid":"ItemB",
            "description":"Test Item B",
            "upc":"1234567890124",
            "currenteffectivedate":"9/1/2017",
            "currentprice":"29.00",
            "nexteffectivedate":"11/1/2017",
            "nexteffectiveprice":"24.00"
         },
         {  
            "itemid":"ItemC",
            "description":"Test Item C",
            "upc":"1234567890125",
            "currenteffectivedate":"9/1/2017",
            "currentprice":"29.00",
            "nexteffectivedate":"",
            "nexteffectiveprice":""
         }
      ]
   }
}

*/


LabelToVar>MyJSON,sJSON
JSONParse>sJSON,getallpricesresult.items[0].description,res
JSONParse>sJSON,getallpricesresult.items[1].description,res
JSONParse>sJSON,getallpricesresult.items[2].description,res

Paste your version of the JSON into the validator/formatter here and it will give you a list of problems:
https://jsonformatter.curiousconcept.com/

[cf1flyboy]

THANKS!!!
That really helps,
Also the validation Web site will come in handy