GET Project API

[Debraj neogi]

What is the SQL query that gets triggered in the backend when we run the GET Project API call?

[Nic Brough -Adaptavist-]

Quite possibly nothing, if the data you're asking for is indexed.  You could have a look at the Project table to see the basic information, but that's not necessarily being read when you run any specific API call.

[Debraj neogi]

Hi Nic,

Thanks for your response, but we could not understand it well. If we are fetching data from the JIRA database, aren't we running an SQL query after all? We need this query for the GET Project API call. The call is https://jira.corp.X.com/rest/api/2/project

[Nic Brough -Adaptavist-]

No, you might not be.  The data you fetch may be being taken from the cache or index, so although your REST call gets data which matches the database, JIRA might not have run any SQL at all to answer the call.

Although, you really don't care about the SQL anyway - the call over REST answers your question, and correctly.  The SQL is utterly irrelevant to you.