Created a BASH script to convert json to csv

ScottZ.

Well-Known Member
Nov 5, 2018
44
2
48
I have created a bash script that will strip the special characters from the .json file and organize via comma delimited CSV file. Original JSON file provided by the pvesh get <resource> --output-format json

You will have duplicate headers but it's still useful for SQL import commands.

Read the commands at the top of the script and make sure to do chmod +x on the file if you plan to use it.

Only trying to make life easier for admins.

Thanks,
Scott.
 

Attachments