Convert table rows to an XML string in X++ D365

To convert table rows to an XML string in X++, you can use the XMLWriter class to construct the XML document. Below is an example demonstrating how to achieve this:
 
Assuming you have a table named MyTable with fields Field1, Field2, and Field3, and you want to convert its rows to an XML string:
 
static void ConvertTableRowsToXml(Args _args)
{
    MyTable myTable;
    XMLWriter xmlWriter;
    XMLDocument xmlDocument;
    str xmlString;
 
    // Create a new XML document
    xmlDocument = new XMLDocument();
    xmlWriter = new XMLWriter(xmlDocument);
 
    // Start the root element
    xmlWriter.writeStartDocument();
    xmlWriter.writeStartElement("Rows");
 
    // Retrieve data from the table
    while select * from myTable
    {
        // Start an element for each row
        xmlWriter.writeStartElement("Row");
 
        // Add fields as sub-elements
        xmlWriter.writeElement("Field1", myTable.Field1);
        xmlWriter.writeElement("Field2", myTable.Field2);
        xmlWriter.writeElement("Field3", myTable.Field3);
 
        // End the row element
        xmlWriter.writeEndElement();
    }
 
    // End the root element
    xmlWriter.writeEndElement();
    xmlWriter.writeEndDocument();
 
    // Get the XML string
    xmlString = xmlDocument.toString();
 
    info(xmlString);
}
This example uses the XMLWriter class to construct an XML document by iterating through the rows of the MyTable table and adding elements for each field within a "Row" element. The resulting XML string is then obtained using the toString method of the XMLDocument class.