JSON COMPARE AND GROUP HOW TO

If the JSON and XML have come from different sources (which were meant to be the same) or from the same source but by different processes, then the order of the data items may differ. Multiple similar data items would probably be represented in XML as child elements within a single parent and this might be converted to a JSON array. Very often data that is in both formats will have some differences, and one that is pertinent to the paper mentioned above is order of the data. If you have a schema you can use this to normalise the data, but that is an additional step in the process. The Saxon XSLT processor will write JSON out from an XML representation though you may need to do some transformation to get it into the correct XML first.Īnother reason for using JSON is that it understands numbers whereas XML content is handled as text. If you have access to XSLT then this is a good way to convert from XML to JSON. I would suggest converting from XML into JSON because data is easier to compare in JSON because it is a simpler representation. This depends on the tools you are familiar with and also how you would prefer to see the changes, whether in JSON or XML.

Is it easier to convert XML to JSON or vice versa? One benefit of DeltaXML tools is that the changes are represented directly in these formats so they are easy to process and you do not need to load large files into an editor to review changes. The reason is simply that unless your data is small and you can look at it all easily, you will likely need to do some post-processing to get the changes into a form that you can easily review, and this is easier if the changes are represented in JSON or XML. If some of your data is in CSV then it is probably best to convert this to JSON or XML and then compare. Unfortunately comparing the different formats directly is not possible so some pre-processing is needed. Related to this is the question we sometimes get in our support channel: how do I compare the same data in XML and in CSV (Comma Separated Value)? there is data that is in XML and also in JSON and it is necessary to check that the information is the same or to find out where it differs.

JSON COMPARE AND GROUP HOW TO

One question that arose was how to compare one with the other, i.e.

I presented a paper at the Balisage conference recently on the significance (or not!) of element order in XML, “Element order is always important in XML, except when it isn’t”. Data is often published in different formats or serialised from one data source in XML and from another in JSON.

Json compare and group