Dynamic column header for JSON output

Help Hub
,
1

Looking for specific help here to show the API returned data in tabular format.

I am calling an API to fetch data from SQL Server database. I am getting the data in below format. The returned columns and data is dynamic.

"columnNames":[
        "COL1",
        "COL2",
        "COL3",
        ],

"data":[
        [
            "Data1",
            "Data1.1",
            "Data1.2",
        ],
        [
            "Data2",
            "Data2.1",
            "Data2.2",
        ],
        [
            "Data3",
            "Data3.1",
            "Data3.2",
        ]
      ]

I need to display the data in tabular format with column headers. such as below

|COL1|COL2|COL3|

|Data1|Data1.1|Data1.2|
|Data2|Data2.1|Data2.2|
|Data3|Data3.1|Data3.2|

How can we show the output data in a tabular format when we do not know the returned columns upfront ?

2

Sorry we didn’t get to this sooner. This isn’t the experience we want for our users.

This sounds like the type of thing that Postbot can help with, check out more about this here.