Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      OK, Thanks Anonymous!