Query against the JIRA API

Anonymous · ‎12-04-2017

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	{…}

Anonymous · ‎12-06-2017

@Anonymous,

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