Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Excel GET request for Atlassian ID

Benjamin Leidner April 10, 2023

HI all-

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.

Thanks!

-Ben

 

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events