How to get data from different level from JSON

[miha.osojnik]

Hello

 

For data source we use JSON. In a report I need to use data from two different "levels". Here is JSON example:

{
   "JasonDataExample":{
      "Data1":"something123",
      "field":[
         {
            "subData1":"aaa",
            "SubData2":"bbb",
            "SubData3":"ccc"
         }
      ]
   }
}

For my report I need to use subData1, subData3 and Data1.

How do I do that, hod do I define this source in "Dataset and Query" ? Hope I explained my problem good enugh.

[majdoleen]

Did You find a solution for this?