Mapping XML Simple Elements to JSON Values

Q

What is the standard to map XML simple elements to JSON values?

✍: FYIcenter.com

A

There seems to be no industry standard on how to map XML simple elements to JSON values.

But there are some commonly used conventions:

1. Converting each XML simple element to a single JSON object property. The property name is set to the element name and the property value is set to the element text content. For example:

XML:
<address>
  <street>21 2nd Street</street>
  <city>New York</city>
  <state>NY</state>
</address>

JSON:
{
  "address": {
    "street": "21 2nd Street",
    "city": "New York",
    "state": "NY"
  }
}

2. Converting empty XML elements to JSON properties with Null values. If the text content of an XML simple element is an empty string, it is converted to the JSON Null value. For example:

XML:
<address>
  <street>21 2nd Street</street>
  <city>New York</city>
  <county/>
  <state>NY</state>
</address>

JSON:
{
  "address": {
    "street": "21 2nd Street",
    "city": "New York",
    "county": null,
    "state": "NY"
  }
}

3. Converting each XML simple element with a single CDATA to a single JSON object property.. The property name is set to the element name and the property value is set to the CDATA content. For example:

XML:
<html><![CDATA[<hr><p>Hello World!<hr>]]></html>

JSON:
{
    "html": "<hr><p>Hello World!<hr>"
}

 

Mapping Repeating XML Elements to a JSON Array

Mapping XML Attributes to JSON Values

XML to JSON Conversion

⇑⇑ JSON Tutorials

2023-07-08, 1210🔥, 0💬