Here, I'm taking it from a file but it could just as easily come from any command that returns peoperly-formatted JSON, such as Invoke-Method. Use example 1: Providing the path to a properly-formatted JSON file. I simply named this Get-StudentsFromJson.ps1 so I could provide some use examples below but you can call it what you like. Here's a more complete, yet still basic script. Thanks for the pretty much in line with what I had above. 'student_user_id' will always be populated with a 'value' however not all 'name' headers will have a 'value'. Some other details that might be relevant: 'name is the column header. The 'name' represents the headers and 'value' represents the data, and each 'columns' array should be a new row. Keep in mind that this is just one 'columns' worth of data, and we can expect there to be ~1000 'columns' arrays. That file is then recalled to process the CSV export. To give you the entire workflow, we call for the API, the JSON output is saved to a JSON file. Each 'columns' array is the data we need, and ALL the 'columns' arrays are nested in a single 'rows' array. We are trying to get data that is exported through an API converted to a CSV.

Convert json to csv