JIRA API Usage Notes

Submitted by code_admin on Wed, 07/25/2018 - 15:45

https://developer.atlassian.com/jiradev/jira-apis

https://jira.cc.ic.ac.uk/rest/api/2/groupuserpicker?maxResults=false&sh…

SELECT cwd_user.display_name as [Name],cwd_user.user_name as [Username], dateadd(second,cast(cast(cwd_user_attributes.attribute_value as nvarchar(255)) as bigint)/1000,'19700101 00:00:00:000') as [Last Logged in on]
FROM cwd_user, cwd_user_attributes
WHERE cwd_user.id = cwd_user_attributes.user_id AND cwd_user_attributes.attribute_name = 'login.lastLoginMillis'
AND dateadd(second,cast(cast(cwd_user_attributes.attribute_value as nvarchar(255)) as bigint)/1000,'19700101 00:00:00:000') < '2013-01-01 00:00:00.0'
order by cwd_user_attributes.attribute_value DESC

https://jira.cc.ic.ac.uk/rest/api/2/group?groupname=jira-users

https://jira.cc.ic.ac.uk/rest/api/2/group/member?groupname=jira-users&a…

https://jira.cc.ic.ac.uk/rest/api/2/group/member?groupname=jira-users&m…

https://jira.cc.ic.ac.uk/rest/api/2/user?username=rjmetcal

https://jira.cc.ic.ac.uk/rest/api/2/user/search?includeInactive=false?p…{}

https://jira.cc.ic.ac.uk/rest/api/2/user/properties?username=rjmetcal

RJM Article Type
Work Notes