Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you might find the site temporarily inaccessible. Thanks for your patience. Read more.

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

How can I retrieve all comments posted today

Med FutureXAI September 23, 2024

Hello, I am currently working on a problem where I need to retrieve all comments that have been posted today. The goal is to get these comments and save the details along with the commenter's name, the date, and the time the comment was posted. I understand that this might be achievable using global automation, JQL (Jira Query Language), or webhooks, but I am unsure of how to implement these methods effectively. Additionally, I have access to third-party automation tools like Make.com and Power Automate, though these platforms don't seem to offer a trigger specifically for fetching comments. Could you advise on how to approach and solve this issue using these tools or other potential methods?

1 answer

0 votes
Ashok Shembde
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 23, 2024

Hi @Med FutureXAI ,

If you prefer a more direct approach, you can query Jira’s REST API to retrieve all comments made today using a custom script or tool.

/rest/api/3/search?jql=updated>=startOfDay()&fields=comment

This query retrieves all issues updated today along with their comments

Med FutureXAI September 23, 2024

@Ashok Shembde 

Where should this query be written, and should it run just once or be scheduled to execute daily? I want it to run at the end of each day and send all the details to a webhook created in Make.com or Power Automate to save in a daily Excel file. How can I achieve this using Jira automation, since it can send data to the webhook?

Suggest an answer

Log in or Sign up to answer