Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Getting TEMPO Worklogs in Power Bi

Hi Team,   I am currently working on a project to extract Worklogs from Atlassian's TEMPO Timesheets using Power BI. Over the past few weeks, i have done enormous research on TEMPO Rest API's and e...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    Please change your current query to a function:

    let
    parameterSource = (Project as text)=>


let
Source = Json.Document(Web.Contents("https://api.tempo.io", [Headers=[Authorization="Bearer xxxxxxxxxxxxx"],RelativePath="rest-legacy/tempo-timesheets/3/worklogs", Query=[projectKey = ""&Project&""]]))

in

Source

in

   parameterSource


    Then create the following table and invoke the above function in the new table.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

Please change your current query to a function:

let
    parameterSource = (Project as text)=>


let
Source = Json.Document(Web.Contents("https://api.tempo.io", [Headers=[Authorization="Bearer xxxxxxxxxxxxx"],RelativePath="rest-legacy/tempo-timesheets/3/worklogs", Query=[projectKey = ""&Project&""]]))

in

Source

in

   parameterSource


Then create the following table and invoke the above function in the new table.


Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks a lot guys!. its working for me

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      This is working fine for me but going further, we might create a staging database to store all the worklogs of all users and analyse the timesheet for different teams within the organization. 

       

      We might need a more robust solution to extract worklogs. Is it possible to extract all the worklogs from REST API using SSIS. If yes, can you please share few tips in achieving this?.

       

      Thanks,

      Arjun