Time tracking to slack

[Dirk Fehse]

Hi there,

I want to push all information from every time tracking/time logging to a slack channel, but I can't access some values.

Those expressions are working:

1. timeSpent: {{worklog.timeSpent}}

2. originalEstimate:{{timetracking.originalEstimate}}

3. remainingEstimate:{{timetracking.remainingEstimate}}

4. worklog.issueId: {{worklog.issueId}}

5. issue.duedate: {{issue.duedate}}

6. issue.key: {{issue.key}}

7. issue.summary : {{issue.summary}}

But how can I access those informations:

1. The person who logged his/her time.
2. The description from the logged time.

Any hints would be so nice!

Thanks in advance
Dirk

[Richard White _TechTime_]

Hi Dirk,

I believe the description is under: {{worklog.comment}}

There is no documentation for the worklog author, but according to this old question, it should be available under {{worklog.author.<user-field>}} or {{worklog.updateAuthor.<user-field>

Note, if you are using Tempo, the author field will be the app, rather than the user.

[Dirk Fehse]

Reply does not work... 

[Dirk Fehse]

Hi Richard,

thank you for your feedback.

This is the output of {{worklog.comment}} :  time-tracking :-) 

And here comes the author: {{worklog.updateAuthor.displayName}} Tempo Timesheets

And yes, we are using tempo... 

Should I contact the tempo-support for that?

Cheers,
Dirk

[Susanne Götz _Tempo_]

Hi @Dirk Fehse ,

To get information about the worklog comment and worklog owner, you will need to use the Tempo API's as this information is anonymized when worklogs are created in Tempo and synced to JIRA. 

Information about the Tempo REST API's can be found on https://tempo-io.github.io/tempo-api-docs/

Best regards,
Susanne Götz
Tempo team 

[Dirk Fehse]

Hi Susanne,

thank you for your feedback. Can you make a short example how to access the tempo-api in the JIRA-Automation? Are there any docs available?

Best regards,
Dirk

[Susanne Götz _Tempo_]

Hi @Dirk Fehse ,

Sorry, I was not aware that you are using the new JIRA Automation to do this.

As far as I am aware, all rules that can be created are based on JIRA native functionalities.

You might need to check this directly with Atlassian if it is possible to set up rules to fetch data via an API provided by a 3rd party plugin.

Best regards,
Susanne

[Maarten van der Valk]

Is there any solution for this issue to use in automation? {{worklog.updateAuthor.displayName}} returns "Tempo Timesheets". 

@Dirk Fehse Any progress so far?

[Dirk Fehse]

Hey @Maarten van der Valk ,

sad but true, but until now, no reaction from @Attlassian Team .

What do you thing we should do?

Best regards,
Dirk

[Maarten van der Valk]

Hi @Dirk Fehse ,

Ok, tnks for the update.

I dont know, I think Tempo should add extra information of the user to the workflow. Maybe they can help us.

Best regards, Maarten

[Sergey Shoshin]

Hello, Susanne and Richard! @Susanne Götz _Tempo_ @Richard White _TechTime_ 

Do you have any updates regarding Jira Automation + Tempo connection? We have absolutely the same ask as others. 

Automation is must have to be available ... 

Thanks!

[Sergey Shoshin]

Finally, I was able to solve the problem using Alexander Eck _Tempo_'s answer below. Using Rest API.

[Oleh Henaliuk]

Trying now. Doesn't work. Would appreciate if you share how your process works.

I just want the employee name in the email sent after the time tracked. @Sergey Shoshin 

[Sergey Shoshin]

@Oleh Henaliuk 

1) Send a request to tempo.

• Type: GET
• Action Type: "Send web request"
• URL: https://api.tempo.io/core/3/worklogs/jira/{{worklog.id}}, where worklog will be taken from the trigger event.

2) Handle response in the next action (e.g. Send Slack Message) using

• {{webResponse.body.author.displayName}}
• etc. smart values.

[Oleh Henaliuk]

Worked. Problem was with double brackets, + created API key in Tempo settings, +marked delayed execution checkmark below

[Martin Kovalcik]

I can successfully log {{webResponse.body.author.displayName}} to rule audit log, but I am unable to send email to {{webResponse.body.author.displayName}}.

I get error

"Send email
Could not send email, the 'To' address field is empty. If you have referenced a field it may be empty."

please help

[Dirk Fehse]

Moin Moin @Susanne Götz _Tempo_ ,

is there a new posibility for that problem?

Best regards from Karlsruhe

Dirk

[Alexander Eck [Tempo]]

Hi,

you can query the Tempo REST API to get the worklog author (Display name or Atlassian accountID) by using a setup from below:

However I couldn´t figure it out on how to use the response for a follow-up action. Maybe that´s only the paid version? 

BR

[Sergey Shoshin]

@Alexander Eck [Tempo] You can use it in that way: 

{{webResponse.body.author.displayName}}

[Alex Ziegltrum]

Hello @Alexander Eck [Tempo] 

I tried your proposal in my automation and I get the following error response: 

Could you help on with that?

Thanks! :)

[Susanne Götz _Tempo_]

Hi Alexander, 

The version 4 of the Tempo REST API does not include an API to retrieve worklogs by jira worklog id. 
If you have only the jira worklog id available, you will need to add a separate step to retrieve the Tempo worklog id from JIRA. 

This can be done with the JIRA REST API 

YOUR_JIRA/rest/api/3/issue/{issueIdOrKey}/worklog/{id}?expand=properties

(https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-worklogs/#api-rest-api-3-issue-issueidorkey-worklog-id-get)

The tempo worklog id is returned in the "properties" section of the response, similar to 

The "tempo_id " is the worklog id in the Tempo database, and you can create a variable for it with  {{webhookResponse.body.properties.value.tempo_id}}

Once you have this information, you can use the Tempo REST API to retrieve information for this specific worklog 

https://api.tempo.io/4/worklogs/{id}    

(https://apidocs.tempo.io/#tag/Worklogs/operation/getWorklogById)


Best regards,
Susanne

[Alex Ziegltrum]

Hey @Susanne Götz _Tempo_ 

thanks a lot for that hint! Very appreciated. Another step forward for me :)

I am now able to retrieve the worklogs (plural) of an issue. That can be checked by the "validate" function in the automation.

Since my automation rule is triggered on a worklog created or updated, I need to identify the very last worklog, in order to check the time logged.

Got another hint how to identify the last worklog of an issue, as of time of creation / update?

Best regards, 

Alex

[Susanne Götz _Tempo_]

When you are using the worklog created or updated trigger, you should be able to catch the jiraworklogid (similar to the manually triggered automation).

You might want to take a look at https://tempo-io.atlassian.net/wiki/spaces/KB/pages/3050340390/Add+worklog+description+and+time+spent+as+comment+to+the+issue, which is an example for an automation that uses the worklog created/ updated event.

Best regards,
Susanne

[Alex Ziegltrum]

@Susanne Götz _Tempo_ I was able to reproduce the mentionend example, which now allows me, to check and react on the time logged in a Tempo worklog.

Thank you very much for your support!