Download JSON file and export it to csv

Question

Hi

I need to download af JSON file through API and convert it to csv as i need to update some attributes in AD server, this need to download the file as schedule job every night.

Any idea ?

Answer 1

invoke-webrequest to start the download
convertfrom-json to parse
export-csv to create the csv

Answer 2

Hi,

Here is an example

$uri = 'https://.../data.json'  
$file = 'D:\data.csv'  
(Invoke-WebRequest -Uri $uri | ConvertFrom-Json)| Export-csv -Path $file -NoTypeInformation  

Best Regards，
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.