Forum Discussion

bourner's avatar
bourner
New Contributor
4 years ago

Multi child xml to csv help required

HI, I have an xml file that has multiple child arrays within it. I’m struggling to get it into a flat format for export to csv, could someone spread a little snap love on this and help 🙂 xml l...
API
pipeline
tstack's avatar
tstack
Former Employee
6 years ago
Copy Link

I think you’re looking for the JSONSplitter snap. The Splitter will break up the array into multiple documents that you can feed into a REST POST snap. You’ll probably want to configure the Splitter with a path like $payload.input[*]. You can include parts of the original document in the documents output by the Splitter using the “Include scalar parents” and “Include paths” options.

  • bourner's avatar
    bourner
    New Contributor
    4 years ago
    Copy Link

    That’s great,

    I have a slight problem in that the actual xml also had some additional levels

    <asx:abap version=“1.0” xmlns:asx=“ABAP Development”>
    asx:values

    Example xml here

    </asx:values>

    </asx:abap>

    As soon as I use this xml it fails. Could you possibly point me in the right direction, and possibly explain what it’s doing ?

    Apologies, I’m new to SL.

    Thanks

    • robin's avatar
      robin
      Former Employee
      4 years ago
      Copy Link

      Could you try again to provide the XML sample (either as an attachment or using Markdown to enter a code block)