Convert xml from ebscohost to csv using xml2json and jq

convert-xml.sh

# tools required:
# npm install -g xml2json-cli
# brew install jq

# This command will flatten the resulting array of objects so that the headers are just the json path to the key joined with dots.

xml2json file.xml | jq '[.records.rec[] | . as $in | reduce leaf_paths as $path ({}; . + { ($path | map(tostring) | join(".")): $in | getpath($path) })]' | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv' > test2.csv