Forum Discussion
DeepakMhaskar
Nov 11, 2019Copper Contributor
How to output as csv from invoke-restmethod
output result in csv format for Invoke-restmethod.
- Kevin_MorganIron Contributor
As VasilMichev said, it depends on the type of the response received.
If you get a response in JSON format, the Powershell itself converts the JSON response into Powershell object (psobject), if the returned Powershell object is array, you can simply export it using Export-Csv command.
$apiUrl = "https://graph.microsoft.com/v1.0/users" $response = Invoke-RestMethod -Headers @{Authorization = "Bearer $accessToken"} -Uri $apiUrl -Method Get $users = $response.value $users | Export-Csv -Path "C:\Users.csv" -NoTypeInformation #### $users | Select displayName,userPrincipalName | Export-Csv -Path "C:\Users.csv" -NoTypeInformation
if your response is not in the required format, then you have to form required JSON string from the response and convert to ps object.
Really depends on the output you are getting. Example query might help.