Confluence CLI: What are the names for the --columns parameter?

[Peter Hochstrasser]

I'd like to generate a list of all group memberships for our Atlassian instance.
I know that this is available on the GUI using the Export button in the groups page.

However, I want to extract this list automatically (via a script) on a daily basis.

Now, the --action getGroupList action does almost what I want - it outputs for each group its members, using their UUID. I'd like to get the user name or the email instead. How do I get that from this action?

[Naveen Kumar_Appfire · Accepted solution]

Hi @Peter Hochstrasser

Good day, I am Naveen from the Bobswift support team.

We have created a support request https://appfire.atlassian.net/servicedesk/customer/portal/11/SUPPORT-95366  to better track your request. However, we have added you as a reporter to this support request

Please sign up using this link sign up and share with us the user name or id.

Using the below CLI action you can get a list of users who are present in the particular group.

--action runFromGroupList --common "--action getUserList --group @group@ --columns "User,Name""

Looking forward to your response!

Thanks,
Naveen

[Peter Hochstrasser]

Howdy Naveen

Thanks for the statement above; it lead me to the solution, not quite as good as I hoped, but good enough for the moment.

First, I found that not quoting parameter values is no good - we have a group named "Bauer AG" which broke the statement. So, I used a trick found in your master class videos: use \" inside the common section.

Then, I got the message that columns need to be numbered - but what numbers, please?
So, I just added 1-10. And acli supplies the names to the numbers - good to know for all --column instances.

The final statement is:

-a runFromGroupList --common "--action getUserList --group \"@group@\" --columns \"1,2,3,4,5,6,7\" -f \"~/Downloads/test.csv\" --append "

However, the result holds some inadequacies, I think:

• User and Name often are equal. Is that really the case?
• Email is empty but for two persons, one being myself. I am Site Admin and Administrator, so consider me to be God ;-) - all values should be visible to me.
• Type: this is always "known". I would have expected this to be User, Group, or App. That would help to filter the resulting list, while known does not add anything interesting, AFAICT.

Can you help me with that a bit more? Thanks.

Yours truly

Peter