How to send last comment with the Automate and lookup issues?

[Mikhail Singaevsky]

Hello all!

I'm writing report using Automate and lookup Issues. And I need to send the last comment.
If I use any smart values with comment, I don't get comments in the email.

Please, help me, how can I send last comments for lookup issues in one email?
Maybe there is another way to configure Automate for this or another request?

{{#lookupIssues}}

<a href="{{url}}">{{key}}</a> {{now.mediumDateTime}}
{{summary}}

<b>Description:</b>
{{description}}

<b>last Comment:</b>
{{lastComment}}, {{Comment}}, {{comment.body}}, {{issue.lastComment}}, 
{{issue.fields.lastComment}} -- any smart values with comment that I used don't work

{{/}}

[Bill Sheboy · Accepted solution]

Hi @Mikhail Singaevsky -- Welcome to the Atlassian Community!

For Jira Cloud automation, lookup issues only supports a limited number of fields, and comments are not included.  There is a suggestion to add more fields, and it is in the "future consideration" status: JRACLOUD-75018

One complicated work-around for this would be to use a web request action to call the REST API with a JQL search, and then parse the response with text and list functions to build your email.

Best regards,
Bill

[Mikhail Singaevsky]

Hello and thank you!

[Михаил Сингаевский]

Please tell me how to continue using Automate tools to work with the received JSON?

Please show me an example?

[Bill Sheboy]

Hi @Михаил Сингаевский -- Welcome to the Atlassian Community!

You may access the response using the smart value:
https://support.atlassian.com/jira-software-cloud/docs/smart-values-general/#Smartvaluesgeneral---webhookResponse--

You will need to understand the structure of your specific request/response in order to parse it.

To parse it, you may dereference the fields with dot-notation and/or extract pieces using:

• text functions https://support.atlassian.com/jira-software-cloud/docs/smart-values-text-fields/
• list functions https://support.atlassian.com/jira-software-cloud/docs/smart-values-lists/

Best regards,
Bill