You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hopefully without employing VBA or Python (which I am terrible at), I want to grab the Atlassian ID of my users from within Excel. My use case is I have an Excel sheet with a list of restricted apps, DBs and folders, as well as their approvers. I want to populate the Excel with the Atlassian ID of the approvers to then import the sheet (as CSV) into Assets in Jira. I have the user's email (could also use username if need be) in cell A1 and I've created an API key, Base64 encoded it and put it into cell B1. Now in cell C1, I have...
=WEBSERVICE("https://<COMPANY>.atlassian.net/rest/api/3/user/email?accountId=true&emailAddress="&A1&"Authorization: Basic "&B1)
This sheet will replace our current IT Policy as the golden source of restricted systems and their approvers so:
1) Our Ops Risk team (owns and) updates the Excel.
2) Sheet gets exported to CSV and imported into Assets.
3) Approvers autoselected in Jira when access to the restricted app/folder/database is requested (this is in place).
Since this is auditable, I need to automate as much as possible to prevent any fat-fingering by me or my team.