How nested object JSON data source is processed in Report Designer

The nested object json datasource will be converted into flatten data format while connecting to the datasource. The steps involved in creating sample nested object data source and its processing details are provided as follows.

1. Open the data source panel, click New Data and select the JSON datasource.

2. Choose the inline JSON type.

   You can choose the JSON type as per your requirement.

3. Now, add the inline JSON data with nested object, which needs to be placed in the inline text box.

   {   "employees":
    [{
            "name":"John",
            "email":"[email protected]",
            "age":32,
            "address": [{ "address" : "1/45 Western Street, berlin, Germany" }, { "address" : "1/45 Western Street, cologne, Germany" }]
   },
   {
            "name":"Smith",
            "email":"[email protected]",
            "age":21,
            "address": [{ "address" : "14/45 Western Street, berlin, Germany" }, { "address" : "14/45 Western Street, cologne, Germany" }]
   
   },
   {
            "name":"Chard",
            "email":"[email protected]",
            "age":21,
            "address": [{ "address" : "14/45 Western Street, berlin, Germany" }, { "address" : "14/45 Western Street, cologne, Germany" }]
   
   },
   {
            "name":"kristen",
            "email":"[email protected]",
            "age":21,
            "address": [{ "address" : "14/45 Western Street, berlin, Germany" }, { "address" : "14/45 Western Street, cologne, Germany" }]
   
   }]
   }

   

   In the previous sample JSON data, each employee has two address in hierarchical level, which will be converted into flatten data format while connecting to the data source.

4. Click Connect.

5. Query Designer will be opened, in which you need to add the dataset to the report.

6. Click Run to see the JSON data converted into flatten data format.

   In the above JSON data each employee has two address in hierarchical level, which is converted into flatten data format.

7. Click Finish to successfully add dataset to the report.

8. Add a table and assign the necessary values.

   If you need to perform grouping to the data in the table, then you can refer to this Add Grouping and Totals section.

9. Now, the report preview can be visualized as follows.

   The previous report is grouped based on name of the employee.