Convert JSON file to Excel
Budget: £20 – £250 GBP
See attached JSON file.
The structure is quite complex as it's the output from an app that lets you change the the way the data is presented, thus you get a series of data objects containing arrays of more data objects in a hierarchy, with properties of those objects defining what data you are looking at.
It's further complicated by the fact some of the data is stored in a different object, (you'll see three objects at the top of the hierarchy). So this won't go through any existing parser, it will probably need to be decoded programatically.
In simple terms read through a series of nested arrays, in the first data object, look up supplementary data from a set of arrays in the third data object, (matched by a unique ID) and output as a rows in Excel.
First worksheet - I've tried to walk through the logic required in the attached Excel, you'll see a reference to the JSON with examples and psuedo code to the right referencing how to create the Excel output from that example.
Second worksheet gives you an idea what the finished file will look. Presenting sporting event data.
I'd love this to be done in some sort of scripting language or if possible via a macro in the Excel spreadsheet, so I could step through the code and learn how the process works but the main goal is that I can run this repeatedly on a Mac to create these files from live data.
The structure is quite complex as it's the output from an app that lets you change the the way the data is presented, thus you get a series of data objects containing arrays of more data objects in a hierarchy, with properties of those objects defining what data you are looking at.
It's further complicated by the fact some of the data is stored in a different object, (you'll see three objects at the top of the hierarchy). So this won't go through any existing parser, it will probably need to be decoded programatically.
In simple terms read through a series of nested arrays, in the first data object, look up supplementary data from a set of arrays in the third data object, (matched by a unique ID) and output as a rows in Excel.
First worksheet - I've tried to walk through the logic required in the attached Excel, you'll see a reference to the JSON with examples and psuedo code to the right referencing how to create the Excel output from that example.
Second worksheet gives you an idea what the finished file will look. Presenting sporting event data.
I'd love this to be done in some sort of scripting language or if possible via a macro in the Excel spreadsheet, so I could step through the code and learn how the process works but the main goal is that I can run this repeatedly on a Mac to create these files from live data.