Interdimensional | Spatial scrolling for your web pages | Frontend Framework library

I have searched looking for examples of converting complex json (embedded arrays] into csv file(s) using Powershell. The goal is to accept json data into a MSAccess database. MSAccess does not provide an intrinsic function to do this. I am new to Powershell and json, but I did discover the ConvertFrom-JSON cmdlet that got my interest. The best info I have found is the

Flatten-Object function by iRon

in response to this article

PowerShell convert nested JSON array into separate columns in CSV file

While this function works to create a single csv, I am interested in creating multiple csv files if there are embedded arrays in the json. The idea is to create a csv file for data at each level. Level 2 and lower will require a link field (id/name) to be used as a primary key in level1, and as foreign key in level2. A PK field at the level2, would be included as a foreign key at level3 and so on. Since Access can import csv data to a table, my feeling is that getting the data into "normalized" csv files would be a repeatable method to get json data into an MSAccess database.

So with respect to my objective and the Flatten-Object function, I am looking for advice/direction on the following:

• Could the function be adjusted/used to identify
• the levels in the json file,
• to create a csv for each of those levels with a selectable PK field(s) to relate
• the csv data files in a normalized manner for import to MSAccess??

I do realize that some human intervention will be required for each json file. So I'm looking for an approach that simplifies the effort and is repeatable.

I have created a simple script to take a simple json file (no embedded array) and convert it to CSV. I have used the Shell command in vba to execute the PS script.

Below is my JSON file

I have two variables var1 and var2 exported in my shell.