convert_json_to_csv.sh

#!/bin/bash

# json should be any list of dictionaries with
# each item having the same keys
# example:
#[
#  {
#    "name": "server1.example.com",
#    "online": true,
#  },
#  {
#    "name": "server2.example.com",
#    "online": false,
#  }
#]
#
# jq installation is required: https://stedolan.github.io/jq/download/

if [ "$#" -ne 1 ]; then
    echo "Arguments: <fname.json>"
    exit 1
fi

cat $1 |jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv'

credit for jq crazy query goes to: https://www.freecodecamp.org/news/how-to-transform-json-to-csv-using-jq-in-the-command-line-4fa7939558bf/