JSON data from JIRA

[Anonymous]

Hi Everyone!

I'm trying to modify the code from the JIRA content pack because I need to show in my dashboard the Timetracking of the issues.
My schema in JSON is like that:

expand	"schema,names"
startAt	0
maxResults	50
total	8201
issues	{
 0
      {
      expand	"operations,versionedRepr…nsitions,renderedFields"
      id	"16605"
      self	"http://jira.mycompany.com/rest/api/2/issue/16605"
      key	"TZIR-1"
      fields	
      issuetype	Object
      components	[]
      timespent	111600
      timeoriginalestimate	null
      description	null
      project	Object
      fixVersions	[]
      aggregatetimespent	111600
      resolution	null
      workratio	-1
      summary	"Bla bla bla"
      ...
      }
 1	Object {}
 2	Object {}
 3	Object {}
 4	Object {}
 5	Object {}
 6	Object {}
 7	Object {}
 8	Object {}
 9	Object {}
 10	Object {}

}

The only way that I see to show the timetracking of every issue is taking the url of every issue and using it to take the field that I need . So I need to go over all issues and taking the field "self" but I don't know how to do it in Power Query.

Any help please?

Thanks.

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

If I understand you correctly, you can firstly try inserting all the urls(or just issure ids) into a new table.

Then, create a function using syntax like below.

let functionName = (param1 as datatype) =>
let
 Source = Json.Document(Web.Contents("http://jira.mycompany.com/rest/api/2/issue/" & param1).
in
 Source
in functionName

After you have inserted the urls into a new table, then you can add a custom column to the table that calls/invokes the function above. 

Reference:
http://datachix.com/2014/05/22/power-query-functions-some-scenarios/

http://satalyst.com/power-query-creating-a-parameterized-function-in-m/

Regards

[Anonymous]

Thanks @v-ljerr-msft!

The second link gives me the solution.
It was easier than I thought.

You made me happy on Friday.