How to parse JSON files
I would like to be able to parse JSON files into Libre Calc. I'm attempting to read a file from a vehicle tuner and want to populate a spreadsheet with the data. Then be able to do editing to the data and then save it back to JSON file. I know Microsoft Excel does this but I'm not a Microsoft owner. Is it possible to do this in Calc?
This is not based on a server. The JSON file is exported from a vehicle tuner as a file.
All I want to do is read the JSON file populate a spreadsheet and then after editing to save the data back to the JSON file again. I'm not sure how python is going to populate a Calc spreadsheet being it's not on a server but a simple 559 byte file you export from a mobile device.
{"profileName":"Economy Beta","vehicleName":"V2 Dodge 1998-2002","settingsMap":{"125":"103","133":"134","128":"113","127":"109","139":"20","111":"15","19":"0","116":"83","17": "1.5","118":"86","112":"15","22":"40","131":"125","61":"3","115":"82","62":"30","129":"117","126": "106","114":"81","136":"149","121":"92","140":"23","130":"121","119":"88","104":"3200","85": "1200","60":"50","138":"18","113":"80","124":"100","122":"94","135":"144","132":"129","59": "5","15":"8","134":"139","110":"0","120":"90","137":"15","123":"97","18":"100","141":"27","117":"84"}}