cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ranand1482 Regular Visitor
Regular Visitor

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 Smiley Wink

 

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"

 

 

1 REPLY 1
Community Support Team
Community Support Team

Re: JIRA User list using Power Query / Power BI

Hi @ranand1482,

 

Thank you for sharing with the whole community.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.