XML Parsing To Get Values

Hello I am receiving some XML in the following structure/format and want SnapLogic to convert each row to a document with the attributes as the value. So here is the sample of the XML coming in from a DB query where it is stored:

When I tag on the XML Formatter and Parser it doesn’t seem to break it down for me with the retrievable values:

If you don’t need additional fields from the database other than the invoice XML, I think your solution would be to replace the XML Formatter snap with a Document to Binary snap and make sure your mapper maps the XML field name to “$content”

Example:

  • If Get Invoices has a statement like “Select invoiceXML from InvoiceTable”
  • The Mapper would map $invoiceXML to $content
  • The Document to Binary snap would have encoding set to “None”
  • XML Parser should then produce your expected results
2 Likes

YES! that is perfect and it works for me. Thank you Del.