Hi All, I am trying to read the following JSON and put it into a table. I find it very easy to get the top level values such as id, siteId etc but face issues when trying to expand out the system.object value types such as clientIPs, I also have difficulties when I hit a nested object such as acti…

jwh, Welcome to the forum. :wave:t4: Before we proceed … could you please go back, edit your question and fix the formatting of your code or sample data? And please share the code you have so far. BTW: When you post code, sample data, console output or error messages please format it as code usin…

[image] jwharris: I am trying to read the following JSON and put it into a table. When you’re saying table you’re probably talking about a structured data format like CSV. JSON data on the other hand are hierarchical data by default. So in easy cases may it be possible to transform JSON input…

Reading JSON into table format

PowerShell Help

jwharris July 14, 2022, 11:39pm 3

Thanks Olaf, I have updates my post

Topic		Replies	Views
Format JSON Output to Readable Text PowerShell Help	8	4653	February 4, 2020
Help with formatting result PowerShell Help	13	388	November 12, 2018
Trouble targeting JSON data PowerShell Help	6	559	April 22, 2022
Powershell List / JSON Output PowerShell Help	4	941	November 19, 2021
Json & Powershell query Select PowerShell Help	1	166	January 26, 2018

Reading JSON into table format

Related topics