Convert XML to JSON?

[severdia]

Is there an easy way to so a simple XML to JSON conversion in BBedit? Oxygen and some other tools seem to do this, but short of creating a TextFactory or similar, I don't see an easy way to do it. 

[jj]

You could try yq.

 Install it from Terminal with homebrew:

    brew install python-yq
   
Create this simple BBEdit text filter in ~/Library/Application\ Support/BBEdit/Text\ Filters/xml2json.sh
   
    #!/bin/sh
    xq '.'

and call the filter from menu Text > Apply Text Filter > xml2json.

HTH,

Jean Jourdain

[severdia]

I don't see a menu item called "Apply Text Filter". There's "Apply Text Transform", but when I open that I don't see the script in dialog that opens with that menu. Can you elaborate? Ideally I could process a folder of XML files and convert then to JSON. I'm using BBedit 14.6.1.

Thanks!

[jj]

Check out that the "Apply Text Filter" checkbox is activated in the Settings > Menus & Sortcuts > Text list:

Check out that the shell script has execute permission.

Warning: 

The proposed solution "as is" only works for very simple XML.

XML and JSON formats are not homeomorphic, many things can fail : entities, cdata, element repetitions, attributes, etc.

However,  combined with 'jq' there seems to be more powerful customizations.

For example, see: https://unix.stackexchange.com/a/658021

For a Text Factory to batch a folder refer to the BBEdit manual and the "Run Unix Filter" command.

HTH,

Jean Jourdain

[severdia]

Excellent. I don't know why that menu items was disabled, but it works now. Also seems to work OK for the XML files I have. Thank you!