JIRA User list using Power Query / Power BI

Hi all,

I have been looking at various information of how to retrieve the user list information from JIRA as an administrator but none of them were able to provide an easier and precise solution. I thought this may of help to everyone as a reference who are using JIRA and want to retrieve information from JIRA for administration purposes. 

Please feel free to update accordingly (specially the JIRA URL and if you need to remove/include columns). You can give a try with single code instead of writing 26 lines but for some reason it didn't work for me thereby adopted this solution and it works for me ;)

Note: The list at the moment only fetches active users and the inactive users are not available for download as atlassian [ref]

Regards,

Anand

Let

SourceA = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=A")),
SourceB = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=B")),
SourceC = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=C")),
SourceD = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=D")),
SourceE = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=E")),
SourceF = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=F")),
SourceG = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=G")),
SourceH = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=H")),
SourceI = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=I")),
SourceJ = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=J")),
SourceK = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=K")),
SourceL = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=L")),
SourceM = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=M")),
SourceN = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=N")),
SourceO = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=O")),
SourceP = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=P")),
SourceQ = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=Q")),
SourceR = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=R")),
SourceS = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=S")),
SourceT = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=T")),
SourceU = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=U")),
SourceV = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=V")),
SourceW = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=W")),
SourceX = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=X")),
SourceY = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=Y")),
SourceZ = Json.Document(Web.Contents("[JIRA URL]/jira/rest/api/2/user/search?maxResults=1000&username=Z")),

Append=SourceA & SourceB & SourceC & SourceD & SourceE & SourceE & SourceF & SourceG & SourceH & SourceI & SourceJ & SourceK & SourceL & SourceM & SourceN & SourceO & SourceP & SourceQ & SourceR & SourceS & SourceT & SourceU & SourceV & SourceW & SourceX & SourceY & SourceZ,

#"Converted to Table" = Table.FromList(Append, Splitter.SplitByNothing(), null, null, ExtraValues.Ignore),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"name", "emailAddress", "displayName"}, {"name", "emailAddress", "displayName"}),
#"Removed Duplicates" = Table.Distinct(#"Expanded Column1", {"name"})

in

#"Removed Duplicates"