I am having a little trouble with my program and hope you can point me in the right direction. I wrote a simple program to allow our distributors to do pricing on their phone. We had a price increase this week and I am trying to update the json file to recompile the program.
I converted the prices from an Excel spreadsheet to json, but my program is not reading them. Looking at the old json file, it is formatted like this:
{
_ “fields”: [“Attribute”, “Description”, “UOM”, “Price”],_
_ “data”: [_
_ [“6100550-ATT”,“Attribute to use to modify p/n 6100550”,“EA”,113.45 ],_
_ [“ADDSR”,“Additional Layer of SR”,“SQIN”,0.2 ],_
All the online converters I am trying to use are formatting the json file like this:
[
_ {_
_ “Attribute”: “6100550-ATT”,_
_ “Description”: “Attribute to use to modify p/n 6100550”,_
_ “UOM”: “EA”,_
_ “Price”: 115.7_
_ },_
_ {_
_ “Attribute”: “ADDSR”,_
_ “Description”: “Additional Layer of SR”,_
_ “UOM”: “SQIN”,_
_ “Price”: 0.21_
_ },_
Am I correct that this is where my problem is? If so, do you know of a converter that will format the data correctly?