Reply
Highlighted
Member
Posts: 131
Registered: ‎08-01-2016

Query against the JIRA API

Hi Everyone!

I've been dealing with this for a long time, I need to make a dashboard with the data from Jira.
My connection with Jira works fine but every time that I refresh the data it takes many time and I don't need all the information from Jira. Only with the last 6 months would be enough.

I need to make a query against the api of Jira that gives me this information, anyone know how to do it?

Thanks!

 

expand	"schema,names"
startAt	0
maxResults	50
total	12454
issues	
	0	
		expand	"operations,versionedRepr…nsitions,renderedFields"
		id	"16605"
		self	"http://jira.myname.com/rest/api/2/issue/16605"
		key	"TZIR-1"
		fields	
			issuetype	{…}
			components	[]
			timespent	111600
			timeoriginalestimate	null
			description	null
			project	{…}
			fixVersions	[]
			aggregatetimespent	111600
			resolution	null
			aggregatetimeestimate	0
			resolutiondate	null
			updated	"2017-01-19T08:38:44.000+0100"
			status	{…}
	1	{…}
	2	{…}
	3	{…}
	4	{…}

 

Moderator
Posts: 9,944
Registered: ‎03-10-2016

Re: Query against the JIRA API

@Mozasf,

Please contact JIRA support about how to add date parameter and expand parameter in its REST API to retrieve fields & data in a specific date range, then use Web connector in Power BI Desktop to connect to the API. There are articles about JIRA REST API for your reference.

 

JIRA REST API Tutorials
JIRA REST API examples

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member
Posts: 131
Registered: ‎08-01-2016

Re: Query against the JIRA API

OK, Thanks @v-yuezhe-msft!