Forum Discussion

Marimuthu86's avatar
Marimuthu86
New Contributor II
7 years ago

Convert Nested Json file to Excel

Hi, I’m working on a requirement to convert Nested Json file to .xls format, but facing some bottlenecks in getting required output. The output shows list of values in cells instead of breaking int...
alchemiz's avatar
alchemiz
Contributor III
2 years ago
Copy LinkReport

Hi Matthias ,

Good day, I don't know if this helps but you can also set basic authentication through the http header 
e.g

Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQ (encoded base64 username:password)


Matthias's avatar
Matthias
New Contributor III
2 years ago
Copy LinkReport

well that's kindof the opposite of what i need
the endpoint i need to connect to doesn't accept Basic auth - but requires the username / password to be provided via post body.

  • Marimuthu86's avatar
    Marimuthu86
    New Contributor II
    7 years ago
    Copy LinkReport

    Yes, along with Transcript, i would need to split all levels inside the file.
    For each level of split, i’m forced to use multiple JSON Splitter. Attaching the full version of file along with pipeline that i created. Could you please help me out with the steps to read this JSON file and write output to Excel format.

    Test-Full_2018_09_08.slp (25.9 KB)
    Arno_Sample1.txt (1.9 MB)