How to export specific fields of powershell output to csv?

Question

I have recently started using powershell and struggling to achieve something. I am calling an API in my powershell script, and the output is a list of reports, where each report has a set of properties like reportID, reportname, workspaceId etc. I need to export this entire output to csv in a proper table format, and also export only one property (workspaceId) of each report to another csv file.

If someone is aware of how to do this, please help.

Below is a part of my script:

$reports = Invoke-PowerBIRestMethod -Url 'https://api.powerbi.com/v1.0/myorg/admin/reports?$top=10' -Method Get
$reports | Out-File -Path "D:\2709\PS4.csv"

output

use export-csv to generate a csv: $reports | export-csv "D:\2709\PS4.csv" — Toni
– Toni, Commented Oct 4, 2022 at 10:48
Invoke-PowerBIRestMethod -Url 'https://api.powerbi.com/v1.0/myorg/admin/reports?$top=10' -Method Get |export-csv "D:\2709\PS4.csv"? — iRon
– iRon, Commented Oct 4, 2022 at 10:54
See: Convert nested JSON array into separate columns in CSV file — iRon
– iRon, Commented Oct 4, 2022 at 11:49

Toni · Accepted Answer · 2022-10-04 11:04:31Z

0

#to export all properties
$reports | export-csv "D:\2709\PS4.csv"

#to export a selection of properties
$reports | select-object -property workspaceId  | export-csv "D:\2709\PS4.csv"

ok I see, $reports contains a json. in principle you can convert the json to csv by doing this:

ConvertFrom-Json -InputObject $reports | export-csv "D:\2709\PS4.csv"

But this gives you only a usefull output if the structure is flat. If thats not the case we have to flattern the structure first before we can export it as csv.

edited Oct 4, 2022 at 11:04

answered Oct 4, 2022 at 10:53

Toni

1,8261 gold badge5 silver badges13 bronze badges

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

3 Comments

Deepa Over a year ago

Hi, thank you for answering, I did try export-csv earlier, but I got the output as below. Length 9697

Deepa Over a year ago

Yes, this is giving me system.object[] , not the values inside. odata.context odata.count value wabi-us-east2-c-primary-redirect.analysis.windows.net/v1.0/… 33954 System.Object[]

Toni Over a year ago

yes as expected. iRon provided a link above showing how flattern the structure...

Collectives™ on Stack Overflow

How to export specific fields of powershell output to csv?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related