Help with reading Json file

[Raj]

please help in reading Json file. the file is attached below for refference

[PhilipMannering · Accepted solution]

Hi @Raj,

Looks like you're JSON is malformed. If you're willing to forgo some of the functions (example: ObjectId() or ISODate() ) then you can get the data parsed out. See attached.

[Raj · Accepted solution]

@PhilipMannering can you share the .yxzp format . I want to check the configuration of input tool

[PhilipMannering · Accepted solution]

Hi @Raj 

Yes, certainly. See attached.

[Raj · Accepted solution]

Can I get help in converting it to tabular as well?

Facing some issues at my end 

Thanks in advance

[PhilipMannering · Accepted solution]

Hey @Raj, 

Here is my attempt at converting the JSON to a proper tabular format. I've included all fields here, which you may not need, so delete as appropriate.