API for Nested Tables

[Syed Arif]

Hi - Am trying to get Jira Data using below API - what i see is multiple Nested tables - do we have a solution inside of API which can expand all the Nested tables

https://jira.xxxx.com/jira/rest/api/2/search?jql=project in (xxxx,xxxx) AND created >= startOfYear()&maxResults=1000  

Snapshot: Power Query

[Darryl Lee]

Hi @Syed Arif

When you query the REST API directly you're going to get JSON back. Those aren't tables, but rather structured data that looks like this:

 "votes": {
   "self": "https://MYJIRA/rest/api/2/issue/ABC-25250/votes",
   "votes": 0,
   "hasVoted": false
},

If you really want to use the REST API, I suggest reading @Brendan Walker's comment, which uses Json functions in Power Query to parse the data:

• Importing into Excel Using Jira APIs 

However it may be simpler to try @Dave Ahlers's instructions to generate a CSV file from a filter referenced earlier in those comments.

[Darryl Lee]

Also, if it's just a matter of expanding the nested tables automatically in Excel, a colleague who is an expert in Power Query (hi @Michael Rothstein suggested this article:

Expand All Columns Dynamically in Power Query 

[Syed Arif]

Hi Lee, Thanks - I tried this but it's not helping - i have table in multiple columns - again each column has nested table inside of it .. so kind of stuck