Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Tempo API calls for workedHours - unusual data hierarchy Edited

Hi, 

I'm trying to pull Tempo data using an API call (https://{JIRA_BASE_URL}/rest/tempo-planning/1/api/folio/{folioId}/team) and am struggling to get the workedHours data from the return.

I'm getting a return for the following data items which is what I've come to expect from Jira: 

$success$members$kind

$success$members$id

$success$members$folioId

$success$members$name ... etc., but when it comes to the hours worked, it looks like this: 

$success$members[[3]]$workedHours[[61]]
$success$members[[3]]$workedHours[[61]]$startDate
[1] "2021-03-28"

$success$members[[3]]$workedHours[[61]]$endDate
[1] "2021-03-30"

$success$members[[3]]$workedHours[[61]]$effort
[1] 10

$success$members[[3]]$workedHours[[61]]$otEffort
[1] 0

What I really need to get is a sum of all hours spent (i.e., $success$members[[3]]$workedHours[[61]]$effort) for each employee on each folio but I can't quite understand how to get around this different hierarchy of data. 

I'm using R for my scripting but any help would be greatly appreciated. 

1 answer

Just to follow up on this question, here is a more straightforward view of the hierarchy: it looks like there are 61 lists of 4 within the workedHours list - what I need is to be able to get these all into one dataframe where I can aggregate a total per team member per folio. 


workedHours Jira.PNG

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

New Cloud Apps Roundup - Spring 2021

Atlassian's marketplace partners have had a very productive start to 2021! Since our last roundup, our developer community has added over 160 new cloud apps to the Atlassian Marketplace to help you...

83 views 1 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you