Jira Cloud and Power BI without connector

Question

Hello guys,

I would like to ask if it is possible to pull data from Jira Cloud via REST API to Power BI.
I want to get all my projects and their total number of issues for a statistic board on Power BI. Is it possible to get all projects and all their issues in one REST API GET? (i can't use the Jira - Power BI connector).

Thanks in advance.

ΠΑΝΑΓΙΩΤΗΣ ΧΑΒΑΡΑΝΗΣ_jzroum · Answer

Hello @Fabio Racobaldo _Catworkx_ and thank you,

the link that you gave me was helpful and i saw at the Projects section the REST API that i need, my problem is that in the Get projects paginated REST API, at the Response section, it shows that in the JSON it will give me the totalIssuecount for the project, when i put the REST API it doesn't shows the totalIssuecount section in the JSON response in the browser. Did i do something worng?

Thanks. (sorry for my english)

Fabio Racobaldo _Catworkx_ · Answer

Hi @ΠΑΝΑΓΙΩΤΗΣ ΧΑΒΑΡΑΝΗΣ  and welcome,

you should be able to retrieve all issues through the following REST API https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-get . Please, keep in mind that result is paginated.

Hope this helps,

Fabio