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
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:
However it may be simpler to try @Dave Ahlers's instructions to generate a CSV file from a filter referenced earlier in those comments.
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
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
It looks like you're new here. Sign in or register to get started.
