Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get nodeassociation Details in Jira Cloud API

Jatin Kompelli December 28, 2022

Hello,

 

We are migrating from on prem to Jira cloud and while migrating we have observed that there is no API which gives the information of the "nodeassociation" table.

We have few reports which we run by joining multiple tables including "nodeassociation" in sql but now when we move to API, we will need equivalent API which fetches similar data.

 

Can someone help with that ?

 

Regards,

Jatin

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 29, 2022

Welcome to the Atlassian Community!

You don't need to be looking at the table.  In fact, you never should have been using SQL to read the Jira database, it's the worst possible way to read data out of a Jira system.

It's not just that one table, you will need to throw away all of your SQL and do your reporting properly.  The REST API doesn't expose data in a shape that even vaguely resembles the database.

You will need to look at all your reports, work out what they're actually reporting on (which is issues, not tables) and look at the REST API to see how it exposes the data (it exposes issues, not tables)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events