Issues in reading Nested Json file

Question

Hi,
I tried executing the example for Json Splitter provided in their home page, but the results i’m getting does not match with what they provided in their page. Could someone please correct me if i am wrong somewhere.
SamplePipeline.slp (6.6 KB)
ExpectedResult.xlsx (8.4 KB)
Thanks,
Muthu

shankarrao2 · Answer

Can you follow as mentioned in the screen shot.
Please check “Include Scalar parents”, You can see desired results.

marimuthu86 · Answer

Hi Shankarao,
Thanks much for your inputs, it works now. Can you also please have a look at below thread and suggest me with the solution. I posted below thread for issue with highly complex nested Json file.
I tried a lot but could not solve it.

Convert Nested Json file to Excel Designing Pipelines

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)

Would Appreciate any help that you provide here.
Thanks
Muthu

Forum Discussion

Issues in reading Nested Json file

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?