How to get nodeassociation Details in Jira Cloud API

[Jatin Kompelli]

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

[Nic Brough -Adaptavist-]

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)