How can I retrieve all comments posted today

[Med FutureXAI]

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?

[Ashok Shembde]

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]

@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?