Question Re: Nested JSON file in BODS in Technology Q&A

Nested JSON file in BODS

malinisomu — Wed, 10 May 2023 11:52:37 GMT

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" } ]}

Re: Nested JSON file in BODS

akhileshkiran — Thu, 11 May 2023 18:32:16 GMT

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

Re: Nested JSON file in BODS

malinisomu — Thu, 11 May 2023 19:04:46 GMT

Thank you akhileshkiran