Forum Discussion

ionutbarna's avatar
ionutbarna
New Contributor II
4 years ago

Flatten multilevel/nested JSON Objects and Arrays

Hello there, Is there a way to flatten a nested JSON (multiple objects inside objects/arrays) without using a Script Snap? Take this input for example: { "msg":"Hello, World", "num":1, ...
tstack's avatar
tstack
Former Employee
7 years ago
Copy LinkReport

I just wanted to ask a clarifying question. It sounds like you’re wanting to get the Authorization header that is passed to a triggered task, is that right? What API are you going to be calling in the pipeline that would use the SnapLogic user credentials?

  • hemangjalali's avatar
    hemangjalali
    New Contributor II
    2 years ago
    Copy LinkReport

    Wow! That's a powerful snap! Worked like a charm for my use case.
    Thank you for the suggestion.

    • Michael's avatar
      Michael
      Employee
      2 years ago
      Copy LinkReport

      Indeed it is! This snap can flatten structures, split columns, mask data, rename columns, handle nulls, and more, much faster than relying on python or expressions.