Question 110454 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

XML to JSON – norm?

Say your XML file is:

<CATALOG>
<CD>
    <TITLE>Empire Burlesque</TITLE>
    <ARTIST>Bob Dylan</ARTIST>
</CD>
<CD>
    <TITLE>Empire Burlesque</TITLE>
    <ARTIST>Bob Dylan</ARTIST>
</CD>

If you transform it into JSON, should it be (version 1):

{
"CATALOG": {
    "CD": [
        {
            "ARTIST": "Bob Dylan",
            "TITLE": "Empire Burlesque"
        },
        {
            "ARTIST": "Bob Dylan",
            "TITLE": "Empire Burlesque"
        },
    ]
}

}

Or (version 2):

{
"CATALOG": [
    {
        "CD": {
            "ARTIST": "Bob Dylan",
            "TITLE": "Empire Burlesque"
        }
    },
    {
        "CD": {
            "ARTIST": "Bob Dylan",
            "TITLE": "Empire Burlesque"
        }
    }
]

}

My feeling is that version 1 is more correct but I’m wondering if there is a norm?

Thanks for your feedback – Christian

Tags:

2

Answers


  1. 0

    It depends on what you mean by more correct.

    Both Version 1 and Version 2 JSON formats above are valid under RFC 8259.

    • Read more about it here.
    • Validate your JSON with it here.

    RFC 8259 is the official and standard document used by developers to
    develop JSON SDK/ Libraries in different programming languages.

    However, with that said, most online XML to JSON converters (like this one here) would handle the conversion with Version 1. Making it more compact and readable (and easy to consume).

    When the code is entered in the XML box it applies some rules to
    convert XML:

    • The namespace from the code is removed from the resulting property.
    • The attribute of the code will be counted as a JSON property.
    • The sequenced rows in the XML are translated into a JSON array.
    Login or Signup to reply.
  2. 0

    There is no correct answer and no standard.

    The best answer depends on the semantics of the data, which no tool is likely to know. We can guess the semantics of your data, because we are familiar with words like "artist" and "title". But even knowing that, we have to make guesses. Will all the things in a catalog be CDs, as in your example, or is this just a special case? Is the order of CDs in the catalog significant? Is the order of ARTIST and TITLE significant? Might there be CDs with multiple ARTIST children in the XML, and if so, would you want the single-artist case to use the same structure?

    The ideal conversion works from the data model implemented by the XML — which takes into account questions such as whether a CD has multiple artists and whether the order of their names is signficant — and then designs a JSON data structure to match that data model. Inferring a data model from one example data-set involves a lot of guesswork.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search