How to convert an XML file to a JSON file

Question

How do I save the extract data from my Linux directories to JSON? I tried saving it to an XML file already where, if I run the script, it will generate an XML file like "data.xml".

I don't know how to convert it to a JSON file.

This is my XML template inside my Bash script:

file=~/data.xml
  template=" <Data>\n\
  <date>%d</date>\n\
  <time>%d</time>\n\
  <age>%d</age>\n\
  <place>%s</place>\n\
  <name>%d<name>\n\</Data>\n"

  echo '<?xml version="1.0"?>' >> $file
  echo '<List2>' >> $file

template

printf "$template" "$date"\
                    "$time"\
                    "$age"\
                    "$place"\
                    "$name"\$file   
#closing tag
echo '</List>' >> $file

Answer 1

github.com/mikefarah/yq supports this out of the box:

yq -p=xml -o=json file.xml

You can use jq like expression syntax to chop and change the data if required.

Disclaimer: I wrote yq