Query every JSM Queue for the JQL - put it in a Confluence Database

Question

How can I parse each specific JQL and eventually save the results in a dynamic pace in Confluence?

e.g. New Database page:

Queue1 - JQL-Query-String1

Queue2 - JQL-Query-String2

Update button parses each linked queue for the new JQL String.

Having 100+ queues is a bit cumbersome to maintain manually.

Is it possible to do?

Ilanguak Olsen

Ilanguak Olsen_qplzwz · Answer

Dear Trudy,

Nice to see your suggestion. It is not the easiest way for sure, but let's pave a way through.

I'm going to look into the API, Webhook feature.

Trudy Claspill · Answer

Hello @Ilanguak Olsen

I think you would have to find a way to leverage the Jira Service Management Cloud REST API to get the Queue information.

https://developer.atlassian.com/cloud/jira/service-desk/rest/api-group-servicedesk/#api-rest-servicedeskapi-servicedesk-servicedeskid-queue-get

You might be able to leverage the Automation Rules feature in Jira or in Confluence to execute a Send Web Request action to call that API endpoint and construct/update a Confluence page with the output.

That's a bit beyond what I've done with the Automation Rules feature. I know the feature in Jira is capable of execute web request, and creating and update Confluence pages.