powershell json restapi csv

save_json_response_as_csv.ps1

# several commands via Invoke-RestMethod
$request = 'https://piwikdomain/index.php?module=API&method=Live.getLastVisitsDetails&idSite=1&period=day&date=today&format=JSON&token_auth=<token>'
$RestCall = Invoke-RestMethod -Uri $request
$RestCall | Export-Csv -Delimiter "`t" -Encoding "UTF8" -path whatever1.csv -NoTypeInformation


# single line with pipes
$request = 'https://piwikdomain/index.php?module=API&method=Live.getLastVisitsDetails&idSite=1&period=day&date=today&format=JSON&token_auth=<token>'
( Invoke-RestMethod -Uri $request ) | Select * | Export-Csv -Delimiter "`t" -Encoding "UTF8" -path whatever2.csv -NoTypeInformation

# alternative calls via Invoke-WebRequest
$request = 'https://piwikdomain/index.php?module=API&method=Live.getLastVisitsDetails&idSite=1&period=day&date=today&format=JSON&token_auth=<token>'
$result = Invoke-WebRequest $request
$visits = $result.Content | ConvertFrom-Json
$visits | Select *
$visits | Export-Csv -Delimiter "`t" -Encoding "UTF8" -path whatever3.csv -NoTypeInformation

# alternative as one-liner
( Invoke-WebRequest $request | ConvertFrom-Json ) | Select * | Export-Csv -Delimiter "`t" -Encoding "UTF8" -path whatever4.csv -NoTypeInformation



( Invoke-RestMethod -Uri $request ) | Select idVisit -expand customVariables | Select *, @{Name='Orga';Expression={ ($_.1).customVariableValue1 }}