How to convert nested JSON output into a single table

[lightsection]

How do we convert nested JSON data into a clean straight table format. 

Using REST Connector, the nested data look like this:

Data Model: Multiple tables get created for each hierarchy instead of 1 single fact table. 

How do we convert these into a single table in a dynamic fashion.

[dplr-rn]

What do you mean by "convert in a dynamic fashion"?
Principle to convert this into a start schema is same as converting a transnational DB tables to a star schema

[lightsection]

This is just 1 JSON file, containing data for 1 element of the whole data model.
I have similar JSON files that will add more tables to the whole data model.

The idea is be able to view each file in a single table format , instead of multiple sub tables

[dplr-rn]

Not an expert by any mean on JSON
but IMHO JSON nesting basically means its different json objects or "tables"/"datastructures" (for the lack of a better term) underneath the hood. Which is why you are getting multiple tables.

like i mentioned before to covert to a flat structure you need to de-normalize.

Hope i understood correctly

[fernandobibian]

Hi Lightsection,

I understand your struggle. We also faced this problem working with JIRA API and we added this feature as an out-the-box feature of our connector.

I hope it helps you!

Here is a video to see it in action: