export csv from json file using powershell

Question

I do have a json file like this: { "skip" : 0, "take" : 100, "rows" : [ { "WG": "1013", "Werkgever": "1013", "Cao": "0000" } ]}

Now I do need to convert this to csv file like this using powerhsell

"WG","Werkgever","Cao"
"1013","1013","0000"

The script is:

Json conversion to CSV

Get-Content -Raw $file |
  ConvertFrom-Json |
  select @{n='WG';e={$_.WG | select -Expand WG}},
         @{n='Werkgever';e={$_.Werkgever | select -Expand Werkgever}},
         @{n='Cao';e={$_.Cao| select -Expand Cao}}|
Export-Csv $FileName1 -NoType

Only I do miss the value.... It comes out like:

"WG","Werkgever","Cao"
"","",""

What do I do wrong?

$File = "$PSScriptRoot\Getconnector.json" $FileName1 = "$PSScriptRoot\output.csv" — jafeth
– jafeth, Commented Mar 4, 2017 at 16:20
With the powershell pipeline, often the best solution with something like this to "half split the problem" and break the pipe. It's been years since I worked with PS, but a quick Google found Show-Object as an option. — rbellamy
– rbellamy, Commented Mar 4, 2017 at 18:37

4c74356b41 · Accepted Answer · 2017-03-04 16:36:41Z

1

Just use rows property to export data

$content = Get-Content -Raw $file | ConvertFrom-Json
$content.rows | export-csv 'somepath' -NoTypeInformation

answered Mar 4, 2017 at 16:36

4c74356b41

71.4k7 gold badges118 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Esperento57 · Accepted Answer · 2017-03-05 10:50:20Z

0

try this

get-content "C:\temp\test.txt" | ConvertFrom-Json | % {$_.Rows} | export-csv "C:\temp\test2.txt" -NoType

answered Mar 5, 2017 at 10:50

Esperento57

17.6k6 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

export csv from json file using powershell

Json conversion to CSV

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Json conversion to CSV

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related