I want to fetch all the Jira tickets assigned to a specific user, I have had a look into all the existing modules but couldn’t find anything suitable. Any pointers on how do we achieve this is appreciated.
My usecase is I want to fetch the Jira tickets details assigned to me and then pass the ticket description to an AI Module to retrieve specific data from the ticket detail and then add that data into a google sheet. Example data is Ticket ID, User, comments etc.
Hey @Nadir_Khan and Welcome to the Make Community!
Can you try the Jira Cloud Platform Search Issues module and search by Assignee?
@Donald_Mitchell I have tried searching by JQL and i get the error Bad Request: request entity too large even though I have put the result limit to 1, here is my blueprint
scenario.blueprint (2).json (3.5 MB)
Hey @Nadir_Khan, there appears to be something wrong with that module’s connection configuration. 3.5MB for a blueprint is just way too large for just a single module.
Please remove it and add a new one and set it up the same way.
If that still doesn’t work, please also create a new Jira connection in additional to replacing your Search Issues module.
@Donald_Mitchell that fixed the issue for me thanks.
Another one please, I am trying to fetch the comments from the tickets (assigned to me) that has “Daily Update” in the text. I have created Watch Issues module but not sure how to use the webhook I created. Any pointers are appreciated.
My usecase is:
Fetch the “Daily Update” comments from all the tickets assigned to me then pass it to OpenAI to modify the data in a certain way and then insert that data in a google sheet.
Glad to hear it’s working!
For comments, are you running this on a schedule or do you want to trigger immediately when a comment contains “Daily Update”?
For the former, I think you’d need to scan all open tickets you’re assigned too (you’re already doing that), then for each issue, List Issue Comments.
There’s not much filtering so you’ll have to filter after receiving the comments.
For example, there may be older comments with “Daily Update” in them so how do you decide which ones to process? Filter on a comment date or something like that.
For the other option, you can set up a Webhook in Jira to fire every time there’s a new comment, then you can use filters in Make to only process those where the issue is assigned to you and the comment contains “Daily Update”.
Another possibility (and probably the best option, if available), you might be able to set up an Issue Automation. Set up an automation to fire every time an issue is commented, issue is assigned to you, and the comment contains “Daily Update” - as many of the filters as you can apply. Have the action fire a Make Webhook with the details.
