Convert JSON to XML

XML remains a critical format in enterprise environments, SOAP APIs, configuration systems, and document interchange standards. DataLensia lets you convert JSON to valid XML instantly.

🚩 The Problem

You have a JSON API response that you need to import into a system that only accepts XML:

{
  "catalog": {
    "book": [
      {"id": "1", "title": "Clean Code", "author": "Robert Martin", "year": 2008},
      {"id": "2", "title": "The Pragmatic Programmer", "author": "David Thomas", "year": 1999}
    ]
  }
}

You need valid XML output:

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <catalog>
    <book>
      <id>1</id>
      <title>Clean Code</title>
      <author>Robert Martin</author>
      <year>2008</year>
    </book>
    <book>
      <id>2</id>
      <title>The Pragmatic Programmer</title>
      <author>David Thomas</author>
      <year>1999</year>
    </book>
  </catalog>
</root>

🛠️ How to Convert

1. Open the JSON Convert tool.
2. Paste your JSON into the editor (or upload a file).
3. Select XML from the Config category in the format grid.
4. Preview the generated XML instantly in the output panel.
5. Copy the result or click Download to save as a .xml file.

⚙️ Conversion Rules

DataLensia applies the following rules when converting JSON to XML:

JSON Structure	XML Equivalent
Object keys	XML element names
String/Number values	Text content inside elements
Boolean values	true / false text content
Null values	Empty element or xsi:nil="true"
Arrays	Repeated elements with the same tag name
Nested objects	Nested XML elements

💡 Use Cases

• Legacy system integration: Many enterprise systems (SAP, Oracle) use XML for data exchange.
• SOAP APIs: SOAP web services require XML request and response bodies.
• RSS/Atom feeds: Publishing content in RSS requires XML formatting.
• Android resources: Android strings.xml and layout files are XML-based.
• Configuration files: Maven pom.xml, Spring configs, .NET app.config.

⚠️ Things to Keep in Mind

• Key naming: JSON keys that contain spaces or special characters may not produce valid XML element names. Use the Transform Builder to rename keys before converting.
• Root element: DataLensia wraps the output in a <root> element if the source JSON doesn't have a single top-level key.
• Arrays: Array items are repeated elements — this is the standard XML representation of collections.

🔄 Combined Workflow

1. Fetch → Use a workspace with API Fetch to pull live JSON from an endpoint.
2. Transform → Rename keys to be XML-friendly (remove spaces, use camelCase).
3. Convert → Export as XML.
4. Download → Save the .xml file for import into your target system.

---

🚀 Try it now

Paste your JSON into the Convert Tool and select XML to get a well-formed XML document instantly.