Parse from cXML

Reads cXML documents and turns them into structured data you can map and transform.

Reads cXML documents (the XML format used for purchase orders, invoices, and other procurement messages) and turns them into structured data you can map and transform. cXML files normally begin with a <!DOCTYPE ...> declaration that points at an external definition; this parser removes that declaration before reading the document, so the data loads even when that external definition is not reachable. XML attributes become keys prefixed with @, and nested elements become nested objects.

Fields

Sample data

Field	Value
Automatically convert value’s types	On (default)

Input (a cXML purchase order):

<cXML payloadID="123" timestamp="2024-01-01T10:00:00">
  <Header>
    <From>
      <Credential domain="NetworkID"><Identity>SupplierA</Identity></Credential>
    </From>
  </Header>
  <Request>
    <OrderRequest>
      <OrderRequestHeader orderID="PO-1024" type="new"/>
    </OrderRequest>
  </Request>
</cXML>

Output:

{
    "@payloadID": 123,
    "@timestamp": "2024-01-01T10:00:00",
    "Header": {
        "From": {
            "Credential": {
                "@domain": "NetworkID",
                "Identity": "SupplierA"
            }
        }
    },
    "Request": {
        "OrderRequest": {
            "OrderRequestHeader": {
                "@orderID": "PO-1024",
                "@type": "new",
                "#": ""
            }
        }
    }
}

Because type conversion is on, payloadID="123" comes back as the number 123. With the option off it stays the text "123", and all other values are unchanged.