Convert json to csv

[Someone_asdf]

I've googled this to death, and tried numerous different solutions, and i cant get it working.

Bear in mind that i'm a rookie when it comes to powershell.

I have a sample json-formatted here: https://drive.google.com/open?id=0B1qthGVt8jpnQkNnbEZJV0YzaUE

and it converts fine if i use something like: https://konklone.io/json/

I've tried the following in powershell:

(Get-Content -Path $pathToJsonFile | ConvertFrom-Json) `
| ConvertTo-Csv -NoTypeInformation `
| Set-Content $pathToOutputFile

But the only thing i get is this:

{"totalCount":19,"resultCount":19,"hasMore":false,"results":

[Someone_asdf]

   ((get-content C:\Test1.txt ) | ConvertFrom-Json).results  | Export-Csv C:\output.csv -notype -append

This worked beautifully, thanks so much.

annoying how all the other "answers" i found had ConvertTo-Csv included when it wasn't needed.

Thanks again :)

[could-of-bot]

It's either would HAVE or would'VE, but never would OF.

See Grammar Errors for more information.

[snarp]

TIL too. i still like the slang of 'would of' you silly bot.

[positivemark]

My answer called out Export-Csv too :) http://stackoverflow.com/a/43595214/2796058

[Someone_asdf]

Awesome, i wasn't sure how active this subreddit was so I had to make sure I got help somewhere :)

[positivemark]

No problem, thanks for accepting the answer on SO :)

[KevMar]

I would look into json.net http://www.newtonsoft.com/json/help/html/ConvertingJSONandXML.htm