More complex flattening?

[grwhumphries]

Wondering if you could provide an example of a very deep nested JSON?

Something like:

{
    "results": [
        {
            "project_name": "Test",
            "start_date": "2020-03-25",
            "associated_references": [
                {
                    "full_reference": "Reference A",
                    "year": 2010,
                },
                {
                    "full_reference": "Reference B",
                    "year": 2010
                },
            ],
            "hierarchy":[{
                      "hierarchy_id": "top level event",
                       "event":[
                           {
                                  "event name": "event 1"
                            },
                            {
                                  "event name": "event 2"
                            },
                            {
                                  "event name": "event 3"
                            }]
                       },
                       {"hierarchy_id":"second level event",
                        "event":[
                           {
                                  "event name": "event 1"
                            },
                            {
                                  "event name": "event 2"
                            }
                            }]]
                             
              }]
      ]}}

The header structure to be returned here would be something like:

Project_name	start_date	associated_references.full_reference	associated_references.year	hierarchy.hierarchy_id	event.event_name

In this case, the row values for each column are replicated (e.g., project_name and start_date) up to the number of instances of the sub-queries..

[crazyprogrammer]

+1

[Cor-J]

I have a similar issue to deals with, @grwhumphries how did you deals with yours?