Jira table names for Defect and Task

[Bhuvana Venkatesh]

I am trying to integrate ServiceNow and Jira. I need to know the table name for bugs/defects/ issues and tasks and subtasks in Jira.

Kindly let me know the table names and also point me to URL so I can get other table names for future integrations.

[Matt Doar _Adaptavist_]

JIra does a lot of caching of data from DB tables, so modifying the database directly is never a recommended approach. Reading from a Jira Data Center database, you'll want to look at the jiraissue table and the issuetype table. For Jira Cloud, there is no database access, you must use the Jira Cloud REST API

[Sunny Ape]

I am trying to integrate ServiceNow and Jira.

That must be a very common homework assignment for Computer Studies students, because that exact same question gets asked at least once a month. If you search this forum for 'Integrate ServiceNow with Jira' you'll find all the times that other students have asked the exact same questions on that topic.

I need to know the table name for bugs/defects/ issues and tasks and subtasks in Jira. Kindly let me know the table names.

You know, you really can save yourself a lot of time and trouble by just using Google to search on a topic and doing some research, before you ask the question.

If you had Googled "What is the database schema of Jira Data Center?" or "What is the database schema of Jira Cloud?" you'd have instantly gotten the answer to either of those questions.