How can I display a Jira Customer list in Confluence?

Question

Hello,

I'm trying to create a list of customers in Confluence using the customers of a specific project resp. organization of that project.
When I use the "/jira issue"-macro I can only create a list of Jira tickets, even when I use JQL to specify the project and / or user group.
Is there a way to accomplish my goal?
Thanks for any response on my question.

Regards,

K. Kriebisch

Johnny Jenkins · Answer

Hi any answer this one? Really wanting to do this to help create Service Desk summary pages for customers without needing to manually update them, tickets are dynamic, but list of solicited contacts are not! And with customer details we flag particular customers are being approvers or if they're part of major incident management and I want our summary page to show them who is current set as part of their incident management contact group

Karin Kriebisch · Answer

Addendum:
In the meantime we added extra attributes to our customers under the Organization so we can now add the telefonnumbers and operational roles ((so we solved the "next big thing") ... BUT we are not able to query the extra attributes via the rest api of JSM. 
Does anyone know a way to do that? Or do we have to issue a improvement request?

Thanks so far anyway.

Regards,

Karin

Karin Kriebisch · Answer

Hi Roma,

Yes, your assumptions are correct so far.

But I don't know the exact rule yet but it should be something like:
project=projectname and organization="org x" and account_type=external

I know I can only get the username and email, so how I attach a telefon number ito each user is the next big thing...
Do you have any idea to get this user list into Confluence?

Thanks so far anyway.

Regards,

Karin