I would like to have a rest API call that returns the issues' details with their respective Portfolio Teams name.

Problem Definition

There is no rest API call to get an issue with its respective JIRA Portfolio team name.

Suggested Solution

Provide a rest API call to get the JPO's team name.

Workaround

If you currently run:

https://localhost:8080/rest/api/2/issue/issue-key

Part of the response will have:

"customfield_15238":"882"

To correlate the issue with its JPO custom field, you have to:

check that custom field 15238 is the Teams (com.atlassian.teams:rm-teams-custom-field-team) custom field in the database by running the below query

SELECT * FROM customfield WHERE id = 15238;

to match the id from the rest API call to the team's field name, you have to query the AO_82B313_TEAM table as shown below:

SELECT id, title FROM AO_82B313_TEAM where id = {take the id from the rest api call, in the below example "882"}

To summarize, to correlate an issue with its respective JPO team currently you have to:

1. run the rest API call
2. parse its output
3. take the id and then run the above select statement in order get the team's name