โ02-03-2020 01:11 PM
I am pulling data from a db connection with multiple rows, and forming that into an xml. I am able to submit this against a web service, but what I need to do is to break down the xml by record for submission to the web service, one at a time.
For example:
โRecordโ:[{โฆ1.}]โฆ
โRecordโ:[{โฆ2.}]โฆ
โRecordโ:[{โฆ3.}]โฆ
Current xml looks something like this:
"File
Record
โฆ1โฆ
Record
record
โฆ2โฆ
Record
Record
โฆ3โฆ
Record
File
Desired XML
File
Record
โฆ1โฆ
/Record
/File
Put the aboveโฆthenโฆ
File
Record
โฆ2โฆ
/Record
/File
Put #2 the aboveโฆthenโฆ
โฆetc
Is there a way to break up the xml, and loop through the submits in SnapLogic?
Solved! Go to Solution.
โ02-03-2020 05:00 PM
Yes, you can use an XML Formatter at that point to get the document back into XML.
โ02-03-2020 01:28 PM
I think you are just looking for the XML Parser snap. That should be able to split your xml document into smaller sub documents.
โ02-03-2020 01:46 PM
Thank you for the response. The parser takes my xml out of xml format, and back into JSONโฆcorrect?
In which case I do not have xml to use for the SOAP Execute and would need to remap etc to submit โฆ correct?
โ02-03-2020 05:00 PM
Yes, you can use an XML Formatter at that point to get the document back into XML.