Forum Discussion

arunsadhasivam's avatar
arunsadhasivam
New Contributor
6 years ago

Snaplogic iterate over array

Hi , i have json like payload{ input:[ {url: "test.com’,} {url: "test.com’,}, {url: "test.com’,} ] } i need to iterate over payload.input[0].url ,payload.input[1].url and send u...
jhagist's avatar
jhagist
New Contributor III
8 years ago
Copy Link

Perfect! Worked like a charm.

Thanks for the picture!

    • Dhivya_Aroma1's avatar
      Dhivya_Aroma1
      New Contributor III
      6 years ago
      Copy Link

      Hi KoryKnick,

      Thanks for the solution. This worked. I understand that xsd is mandatory for the transformation.

      Regards,
      Dhivya.

  • koryknick's avatar
    koryknick
    Employee
    6 years ago
    Copy Link

    I do not see your xml attached to your post.

  • Dhivya_Aroma1's avatar
    Dhivya_Aroma1
    New Contributor III
    6 years ago
    Copy Link

    Sorry. Only values are pasted and not the tags.

    <catalog>
<plant botanical="Sanguinaria canadensis" zone="4" light="Mostly Shady">Bloodroot</plant>
<plant botanical="Aquilegia canadensis" zone="3" light="Mostly Shady">Columbine</plant>
</catalog>
  • koryknick's avatar
    koryknick
    Employee
    6 years ago
    Copy Link

    Thank you for providing your input. Can you also provide an example of your desired output?

    • Dhivya_Aroma1's avatar
      Dhivya_Aroma1
      New Contributor III
      6 years ago
      Copy Link

      This is the expected result

      <catalog>
    <plant>
        <botanical>Sanguinaria canadensis</botanical>
        <zone>4</zone>
        <light>Mostly Shady</light>
        <plantValue>Bloodroot</plantValue>
    </plant>
    <plant>
        <botanical>Aquilegia canadensis</botanical>
        <zone>3</zone>
        <light>Mostly Shady</light>
        <plantValue>Columbine</plantValue>
    </plant>
</catalog>

      Once all the attributes are converted to element the final value of plant (i.e., Columbine) needs the new tag name, like here, I have provided plantValue.