How do I convert an XML string that is generated by the XML generator? I used the generate XML snap, run it through the XML format snap and then through an XML Parser. But it isn’t breaking up the string so that I can manipulate it. It’s still just a string.
This pipeline shows how we do what you are looking for.
The XML Generator contains the following in the edit window:
With that data we map it in the mapper as follows, the output of the XML Generator is a string called xml.
We map that to the content field and also add the content-type for the Document to Binary Snap. This enables us to put the information in a native XML form, with the necessary metadata.:
Then we need to ensure no encoding takes place on the Doucment to Binary Snap, which converts the document input to a binary stream, like the output of a file reader:
After that, the XML parser can read the input stream as an XML binary document.
The output of the XML parser reads the data as follows:
Which we then need to split using the JSON splitter to process as individual documents:
And the final output of the splitter:
Let us know if this helps.
Thank you! That worked!
I have another question for you. I am trying to integrate with Quickbooks desktop and it has a proprietary XML. I need a declaration <?qbxml version = "8.0"?>
but every time I pass it through the XML Parser, it cuts it out. Is there some way to set that?
