Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
7 years ago
Solved

How to create multiple hierarchy sets in for API output

Hello, I am having issues structuring the API output i am working in. I have attached both the Source data and the JSON output structure expected in the attachment. I have attached the source file ...
  • Aleksandar_A's avatar
    Aleksandar_A
    2 years ago

    Hello ashis1upreti,

    You can try by using the Date.parse() function in a Mapper Snap.

    In your case, as a second argument you need to provide the format in which the date is in.

    Date.parse("20240311113047","yyyyMMddhhmmss")

    Also, you can take a look at the Date.toLocaleDateTimeString() function if you want to format the date.

    Please let me know if this helps you.

    Regards,

    Aleksandar.

koryknick's avatar
koryknick
Employee
8 months ago
Copy LinkReport

Andrei_Y - There is a new PipeLoop snap that can help solve this.  I have not tested this solution, but you should be able to put the HTTP Client snap in a child pipeline and call the child repeatedly with the output of the previous execution as input, allowing you to feed the new body content to the POST request.  Simply call your child pipeline using PipeLoop (similar to Pipeline Execute) and you can set the End Condition when your return result array is less than your page size. 

To help with the looping input, I also recommend using the Record Replay snap in the child before the HTTP Client snap to capture the data from your first execution an allow you to iterate the development - then remove the Record Replay once you have the looping logic working correctly.

Hope this helps!

Andrei_Y's avatar
Andrei_Y
New Contributor III
5 months ago
Copy LinkReport

The approach will work but it's not ideal. It requires passing previous results as input to a child pipeline in a loop and keeping everything in memory and complicates the implementation. A better solution would be to add an option to send and modify the body content for subsequent calls.