I’m trying to convert the .JSON data contained at https://gitlab.com/-/snippets/2590066/raw/main/location.txt.md
Location
Invoke-WebRequest -URI 'https://gitlab.com/api/v4/users/7984176?access_token=glpat-KMNv5hmu7xuMbNUWpfqd' | ConvertFrom-Json | Select-Object -ExpandProperty location
| Type | Data |
| - | - |
| Start | +2023-08-25T16+01:00 |
| End | |{ "Co-ordinate": "[]()", "Name": "", "Number": "3", "Street": "Orchard Close", "Plus address": "", "Town": "HLT", "City": "NRW", "County": "NFK", "Country": "ENG", "Country": { "Number": "826", "Label": "[GBR](https://www.iso.org/obp/ui/#iso:code:3166:GB)" }, "Continent": "EUR", "Post code": "NR T", "Celestial body": { "Type": "Planet", "Position": "Sol-3" }, "Celestial body": "Local Group", "Celestial body": "Virgo Supercluster", "Celestial body": "Laniakea Supercluster" }| Type | Data |
| - | - |
| Start | +2015-08+01:00 |
| End | +2023-08-25T16+01:00{ "Co-ordinate": "[31U 382475.747 5851357.121](geo:52.79987835312052,1.257420202584376)", "Name": "Bure House", "Number": "56", "Street": "Millgate", "Plus address": "9F43Q7X4+WW", "Town": "AYH", "City": "NRW", "County": "NFK", "Country": "ENG", "Country": { "Number": "826", "Label": "[GBR](https://www.iso.org/obp/ui/#iso:code:3166:GB)" }, "Continent": "EUR", "Post code": "NR11 6HX", "Celestial body": { "Type": "Planet", "Position": "Sol-3" }, "Celestial body": "Local Group", "Celestial body": "Virgo Supercluster", "Celestial body": "Laniakea Supercluster" }
0. **Location** ```pwsh Invoke-WebRequest -URI 'https://gitlab.com/api/v4/users/7984176?access_token=glpat-KMNv5hmu7xuMbNUWpfqd' | ConvertFrom-Json | Select-Object -ExpandProperty location ``` 0. | *Type* | *Data* | | - | - | | **Start** | +2023-08-25T16+01:00 | | **End** | | ```json { "Co-ordinate": "[]()", "Name": "", "Number": "3", "Street": "Orchard Close", "Plus address": "", "Town": "HLT", "City": "NRW", "County": "NFK", "Country": "ENG", "Country": { "Number": "826", "Label": "[GBR](https://www.iso.org/obp/ui/#iso:code:3166:GB)" }, "Continent": "EUR", "Post code": "NR T", "Celestial body": { "Type": "Planet", "Position": "Sol-3" }, "Celestial body": "Local Group", "Celestial body": "Virgo Supercluster", "Celestial body": "Laniakea Supercluster" } ``` 0. | *Type* | *Data* | | - | - | | **Start** | +2015-08+01:00 | | **End** | +2023-08-25T16+01:00 ```json { "Co-ordinate": "[31U 382475.747 5851357.121](geo:52.79987835312052,1.257420202584376)", "Name": "Bure House", "Number": "56", "Street": "Millgate", "Plus address": "9F43Q7X4+WW", "Town": "AYH", "City": "NRW", "County": "NFK", "Country": "ENG", "Country": { "Number": "826", "Label": "[GBR](https://www.iso.org/obp/ui/#iso:code:3166:GB)" }, "Continent": "EUR", "Post code": "NR11 6HX", "Celestial body": { "Type": "Planet", "Position": "Sol-3" }, "Celestial body": "Local Group", "Celestial body": "Virgo Supercluster", "Celestial body": "Laniakea Supercluster" } ```
into a database in order to reduce duplication of work necessary to maintain multiple versions with the same key-types. However, I’ve been unable to ascertain how to create nested/hierarchical keys like a file manager allows using directories.
and
just goes over my head. I realize you can’t fix stupidity, but can anyone assist?