Nested JSON file in BODS

[#1]

Hi,

Can anyone help me with the nested Json file? I am extracting data from Windchill system and the file is in JSON format.I like to get only Source,Number and Short_Description in the output.

{ "source":"HI", "incidents":[ { "number":"INC0000001", "short_description":"Can't read email" }, { "number":"INC0000002", "short_description":"Error loading XML file" } ]}

[akhileshkiran · Accepted solution]

Hi malinisomu,

Handing the JSON file is same as the consuming the XML file or dealing with any nested schemas in the SAP DS.

Source : I have used you source data as a example.

Step - I : Create a File Format for the JSON File using the file.

Step : II Call the file in the Dataflow.

Step : II.I Provide the path of the file in the Source FF.

Step : III : Un-Nest the sub schema in the Q_

Step : IV: Map the required fields..

Step V : Execute

Regards,

Akhilesh Kiran N

[malinisomu]

Thank you akhileshkiran