List of Teams and their IDs

[Raj]

Hello All,

We are using Jira data center version 8.20.6 and looking for an API to get list of all Advance Roadmap teams and their respective IDs.

If there is no API, how to get the same from SQL database? Appreciate your help.

Thanks,

Raj

[Aditya Verma · Accepted solution]

Hi @Raj 

REST APIs are currently not available for Advanced Roadmaps. There is a feature request here.

You can get this data from the Database, please use below SQL query.

select * from "AO_82B313_TEAM"

Thanks,
Aditya

[Raj]

Thanks @Aditya Verma . Is this table shows all existing ones or even deleted teams as well?

[Aditya Verma]

Hi @Raj ,

I was not able to verify it from DB but my educated guess is that it should only give you a list of current Teams and not deleted ones.

Thanks,
Aditya

[Raj]

Thanks @Aditya Verma