Forum Discussion

mohamadelmardin's avatar
mohamadelmardin
New Contributor III
9 years ago

Parsing XML Array to JSON array is inconsistent

When using XML parser snap to parse XML documents we are facing a problem when handling XML array type. This is because XML parser parses XML Array at runtime to either a JSON array if the particular...
ptaylor's avatar
ptaylor
Employee
5 years ago
Copy LinkReport

I’m not understanding your example. If Column 2 is supposed to be your rownum() value, why wouldn’t the values be 1, 2, 3, 4, 5 instead of 1, 1, 1, 2, 3?

dipanjan_pan's avatar
dipanjan_pan
New Contributor
5 years ago
Copy LinkReport

rownum based on some partition by column. In this case I want the output based on column 1. thats why it is 1,1,1,2,3

  • nshruthi's avatar
    nshruthi
    New Contributor II
    7 years ago
    Copy Link

    Hi,

    Am also looking for solution for similar kind of issue with multiple elements having array structure, Did you find any solution in xml parser or added multiple mappers?

    TIA,
    Shruthi

    • mohamadelmardin's avatar
      mohamadelmardin
      New Contributor III
      7 years ago
      Copy Link

      @nshruthi
      No I didn’t. Unfortunately SnapLogic doesn’t have an out-of-box solution in the XML parser to handle XML array transformation gracefully. I have an enhancement request opened with support but I haven’t heard any resolution on it yet and still waiting…

      • Jimmy_J's avatar
        Jimmy_J
        New Contributor
        7 years ago
        Copy Link

        Hi

        I am new to SnapLogic. I need to use the Snap to parse XML file which has multiple elements and nested structure. Do you know where can I start to learn the XML parser or some Snaps? I found really limited resource available on Youtube, Google.

        Regards,
        Jim