Could the function be adjusted/used to identify.So with respect to my objective and the Flatten-Object function, I am looking for advice/direction on the following: 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. A PK field at the level2, would be included as a foreign key at level3 and so on. 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. The idea is to create a csv file for data at each level. 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. PowerShell convert nested JSON array into separate columns in CSV file I am new to Powershell and json, but I did discover the ConvertFrom-JSON cmdlet that got my interest. MSAccess does not provide an intrinsic function to do this. I have searched looking for examples of converting complex json (embedded arrays] into csv file(s) using Powershell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |