MongoDB导出JSON转XML遇Newtonsoft.Json序列化异常的解决咨询

Hey there! Let's tackle this error you're hitting when converting your MongoDB JSON export to XML for your ETL pipeline.

What's Causing the Error? #

The exception spells it out clearly: XML requires a single root element to be valid, but your exported JSON has multiple top-level properties (like { "field1": "value1", "field2": "value2" }). Json.NET can't map this multi-property root directly to XML, hence the serialization failure.

Quick Fixes to Resolve This #

1. Wrap Your JSON in a Custom Root Node (Single JSON Object)

If your export is a single JSON object with multiple top-level properties, use Json.NET's overloaded DeserializeXmlNode method to specify a root element name. This automatically wraps your JSON in a valid XML root:

using Newtonsoft.Json;
using System.IO;
using System.Xml;

// Read your MongoDB JSON export file
string jsonContent = File.ReadAllText("mongo-export.json");

// Convert JSON to XML with a custom root node
XmlDocument xmlDoc = JsonConvert.DeserializeXmlNode(jsonContent, "MongoDB_Export");

// Save the valid XML to file
xmlDoc.Save("etl-ready.xml");

This will generate XML structured like:

<MongoDB_Export>
  <field1>value1</field1>
  <field2>value2</field2>
</MongoDB_Export>

2. Handle JSON Lines Format (Multiple Documents per Line)

MongoDB exports often use JSON Lines (one document per line). For this case, process each line individually and nest all documents under a single root:

using Newtonsoft.Json;
using System.IO;
using System.Xml;

// Read each line (each line is a separate MongoDB document)
string[] jsonLines = File.ReadAllLines("mongo-export.json");

// Create a new XML document with a root node
XmlDocument xmlDoc = new XmlDocument();
XmlElement rootElement = xmlDoc.CreateElement("MongoDB_Documents");
xmlDoc.AppendChild(rootElement);

foreach (string line in jsonLines)
{
    // Convert each JSON document to an XML node
    XmlElement docNode = JsonConvert.DeserializeXmlNode(line, "Document");
    // Import the node into the main XML document and add to root
    rootElement.AppendChild(xmlDoc.ImportNode(docNode.FirstChild, true));
}

// Save the combined XML
xmlDoc.Save("etl-ready.xml");

This produces XML with all your MongoDB documents nested under <MongoDB_Documents>, which fits perfectly for ETL processes.

Key Notes #

• If your JSON contains arrays or nested objects, Json.NET will automatically map them to nested XML elements — no extra configuration needed.
• Always validate the output XML to ensure it aligns with your ETL pipeline's schema requirements.

内容的提问来源于stack exchange，提问作者Xavier W.