Hi All - I have an API which spits out some JSON which I need to parse into a database table. I'm realtively new to this, and I've been watching various youtube videos to tyr and figure out how to do this. I get some far, but it just alludes me. I've attached a workbook with the start of my attempts. I haven't included the API details, but just download an example JSON data file. After my JSON Parse I'm using a filter just to limit the response to the fileds I am interested in. After this I get lost - I struggling to maintain the relationship between the floor levels and the data I require in the "Zones". I'm trying to create structure like:
| Floor Level | Name | In Use | Total |
| 2 | Blue Zone | 3 | 73 |
| 2 | Red Zone | 5 | 60 |
I've tried a text to colums option, but I just cannot work out how to group the data to map to the fiels I want. It's the variable numbers that are throwing me. I guess I need a regex to group. Not sure? Any pointers would be most welcome!! I'll also attach the json separately as a text file- just in case it's not within the workbook . The upload option wouldn't allow me to upload a JSON file so have renamed it as a text file.
The data is showing PC usage in a library where there are mulitple floors and different areas/zones - each zone has X PCs, and we are capturing how many PCs are in use at that time.
Stephen
