Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
Hi @Anonymous,
Thank you for sharing with the whole community.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |