Excel GET request for Atlassian ID

[Benjamin Leidner]

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