Tables
The connector models the data in Jira as a list of tables in a relational database that can be queried using standard SQL statements.
CData Python Connector for Jira Tables
| Name | Description |
| Attachments | Provides access to issue attachments in Jira. Supports querying, inserting, and deleting file attachments associated with issues. |
| Boards | Query, insert and delete the agile Boards in Jira. |
| Comments | Manages comments added to issues. Supports creating, reading, updating, and deleting issue comments. |
| IssueCustomFieldOptions | Create, modify, delete and query the configured Issue Custom Field Options in Jira. |
| Issues | Provides full access to Jira issues. Supports creation, updates, deletions, and queries for issue records across all projects. |
| IssueTypes | Query the available Issue Types in Jira. |
| ProjectComponents | Manages components within Jira projects. Supports creating, updating, deleting, and querying project components. |
| ProjectRoleActors | Manages role assignments within projects. Retrieves and updates users and groups assigned to project roles. |
| Projects | Provides access to all Jira projects. Supports querying, creating, updating, and deleting project records. |
| ProjectVersions | Provides access to project version management. Supports querying, creating, updating, and deleting versions. |
| RoleActors | Manages default role actors, who are automatically assigned to roles when new projects are created. |
| Roles | Lists all roles configured in Jira, such as 'Service Desk Team' or 'Project Manager'. |
| Sprints | Manages Jira sprints. Supports creating, modifying, deleting, and querying sprint data from agile boards. |
| Users | Provides access to Jira users. Supports querying user details including account ID, email, and group memberships. |
| Watchers | Query, insert and delete the available issue Watchers in Jira. |
| Workflows | Manages the available workflows in Jira, which define the sequence of statuses and transitions for issues. |
| WorkflowSchemes | Handles the configuration of workflow schemes that assign workflows to issue types across projects. |
| Worklogs | Provides full access to Jira worklogs. Supports creating, updating, deleting, and querying logged work hours on issues. |