Table |
Description |
Columns |
Keys |
builds |
Created from the getBuildList Bamboo CLI action |
| Column | Data type | Nullable |
|---|
| project | text | YES | | project_name | text | YES | | plan | text | YES | | name | text | YES | | build | text | NO | | number | bigint | YES | | state | text | YES | | build_reason | text | YES | | test_summary | text | YES | | tests_successful | bigint | YES | | tests_failed | bigint | YES | | tests_skipped | bigint | YES | | tests_quarantined | bigint | YES | | started | timestamp with time zone | YES | | completed | timestamp with time zone | YES | | relative_time | text | YES | | duration | numeric | YES | | duration_seconds | bigint | YES | | duration_description | text | YES | | issues | text | YES | | revisions | text | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
plans |
Created from getPlanList Bamboo CLI action |
| Column | Data type | Nullable |
|---|
| project | text | YES | | project_name | text | YES | | plan | text | NO | | name | text | YES | | description | text | YES | | short_key | text | YES | | full_name | text | YES | | enabled | boolean | YES | | active | boolean | YES | | building | boolean | YES | | favorite | boolean | YES | | average_build_time | numeric | YES | | link | text | YES | | build | text | YES | | number | bigint | YES | | state | text | YES | | build_reason | text | YES | | test_summary | text | YES | | tests_successful | bigint | YES | | tests_failed | bigint | YES | | tests_skipped | bigint | YES | | tests_quarantined | bigint | YES | | started | timestamp with time zone | YES | | completed | timestamp with time zone | YES | | relative_time | text | YES | | duration | numeric | YES | | duration_seconds | bigint | YES | | duration_description | text | YES | | issues | text | YES | | revisions | text | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
projects |
Created from getProjectList Bamboo CLI action |
| Column | Data type | Nullable |
|---|
| key | text | NO | | name | text | YES | | plan_count | bigint | YES | | refreshed | timestamp with time zone | NO | |
|
rooms |
Created from getRoomList HipChat CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | NO | | name | text | YES | | topic | text | YES | | xmpp_id | text | YES | | access | text | YES | | created | timestamp with time zone | YES | | owner_id | bigint | YES | | owner_name | text | YES | | owner_mention_name | text | YES | | members_url | text | YES | | participants_url | text | YES | | statistics_url | text | YES | | guest_access_url | text | YES | | guest_access | boolean | YES | | archived | boolean | YES | | message_count | bigint | YES | | last_active | timestamp with time zone | YES | | refreshed | timestamp with time zone | NO | |
|
links |
Created from getApplicationLinkList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| name | text | YES | | type | text | YES | | id | text | YES | | url | text | YES | | application_url | text | YES | | refreshed | timestamp with time zone | NO | |
|
commits |
Created from the getCommitList Bitbucket CLI action |
| Column | Data type | Nullable |
|---|
| project | text | NO | | repository | text | NO | | id | text | NO | | display_id | text | YES | | author | text | YES | | author_name | text | YES | | commit_date | timestamp with time zone | YES | | message | text | YES | | parents | text | YES | | jira_keys | text | YES | | refreshed | timestamp with time zone | NO | |
| Column |
|---|
| project | | repository | | id | |
projects |
Created from getProjectList Bitbucket CLI action |
| Column | Data type | Nullable |
|---|
| key | text | NO | | name | text | YES | | description | text | YES | | id | bigint | YES | | type | text | YES | | public | boolean | YES | | link | text | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
requests |
Created from the getPullRequestList Bitbucket CLI action |
| Column | Data type | Nullable |
|---|
| project | text | NO | | repository | text | NO | | id | bigint | NO | | version | bigint | YES | | name | text | YES | | description | text | YES | | state | text | YES | | created | timestamp with time zone | YES | | updated | timestamp with time zone | YES | | to | text | YES | | author | text | YES | | reviewers | text | YES | | participants | text | YES | | url | text | YES | | from | text | YES | | refreshed | timestamp with time zone | NO | |
| Column |
|---|
| project | | repository | | id | |
repositories |
Created from getRepositoryList Bitbucket CLI action |
| Column | Data type | Nullable |
|---|
| project | text | NO | | slug | text | NO | | name | text | YES | | id | bigint | YES | | scm | text | YES | | state | text | YES | | status | text | YES | | public | boolean | YES | | forkable | boolean | YES | | clone_url | text | YES | | clone_ssh_url | text | YES | | link | text | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
attachments |
Created from getAttachmentList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| space | text | YES | | title | text | YES | | id | bigint | NO | | parent_title | text | YES | | parent_id | bigint | YES | | file_name | text | YES | | file_size | bigint | YES | | content_type | text | YES | | comment | text | YES | | creator | text | YES | | created | timestamp with time zone | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
blogs |
Created from getBlogList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| space | text | YES | | title | text | YES | | id | bigint | NO | | author | text | YES | | created | timestamp with time zone | YES | | version | bigint | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
comments |
Created from getCommentList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| space | text | YES | | title | text | YES | | page_id | bigint | YES | | parent_id | bigint | YES | | id | bigint | NO | | author | text | YES | | created | timestamp with time zone | YES | | modifier | text | YES | | updated | timestamp with time zone | YES | | contents | text | YES | | refreshed | timestamp with time zone | NO | |
|
pages |
Created from getPageList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| space | text | YES | | title | text | YES | | id | bigint | NO | | parent_id | bigint | YES | | author | text | YES | | created | timestamp with time zone | YES | | modifier | text | YES | | modified | timestamp with time zone | YES | | version | bigint | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
permissions |
Created from getPermissionList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| view | text | YES | | refreshed | timestamp with time zone | NO | |
|
questions |
Created from getQuestionList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | NO | | title | text | YES | | date_asked | timestamp with time zone | YES | | author | text | YES | | author_name | text | YES | | answers | bigint | YES | | votes | bigint | YES | | refreshed | timestamp with time zone | NO | |
|
permissions |
Created from getSpacePermissionList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| space | text | NO | | space_name | text | YES | | space_type | text | YES | | id_type | text | NO | | id | text | NO | | view | boolean | YES | | delete_own | boolean | YES | | pages_add | boolean | YES | | pages_delete | boolean | YES | | blog_add | boolean | YES | | blog_delete | boolean | YES | | attachments_add | boolean | YES | | attachments_delete | boolean | YES | | comments_add | boolean | YES | | comments_remove | boolean | YES | | restrictions | boolean | YES | | mail_delete | boolean | YES | | space_export | boolean | YES | | admin | boolean | YES | | refreshed | timestamp with time zone | NO | |
|
spaces |
Created from getSpaceList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| key | text | NO | | name | text | YES | | description | text | YES | | id | bigint | YES | | home_page | text | YES | | home_page_id | bigint | YES | | type | text | YES | | categories | text | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
topics |
Created from getTopicList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| name | text | YES | | id | bigint | NO | | description | text | YES | | featured | boolean | YES | | watching | boolean | YES | | number_of_questions | bigint | YES | | refreshed | timestamp with time zone | NO | |
|
trash |
Created from getTrashList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | NO | | type | text | YES | | space | text | YES | | title | text | YES | | created | timestamp with time zone | YES | | creator | text | YES | | modified | timestamp with time zone | YES | | modifier | text | YES | | refreshed | timestamp with time zone | NO | |
|
users |
Created from getUserList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| id | text | NO | | name | text | YES | | email | text | YES | | url | text | YES | | refreshed | timestamp with time zone | NO | |
|
watches |
Created from getWatchList Confluence CLI action |
| Column | Data type | Nullable |
|---|
| space | text | NO | | title | text | YES | | id | bigint | NO | | userid | text | YES | | refreshed | timestamp with time zone | NO | |
|
attachments |
Created from the getAttachmentList null CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | NO | | id | bigint | NO | | name | text | YES | | mime_type | text | YES | | size | bigint | YES | | date_created | timestamp with time zone | YES | | author | text | YES | | refreshed | timestamp with time zone | NO | |
|
boards |
Created from getBoardList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| name | text | YES | | id | bigint | NO | | description | text | YES | | type | text | YES | | filter_id | bigint | YES | | refreshed | timestamp with time zone | NO | |
|
comments |
Created from the getCommentList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | NO | | id | bigint | NO | | author | text | YES | | created | timestamp with time zone | YES | | update_author | text | YES | | updated | text | YES | | visibility | text | YES | | comment | text | YES | | refreshed | timestamp with time zone | NO | |
|
components |
Created from getComponentList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| project | text | YES | | id | bigint | YES | | name | text | YES | | description | text | YES | | lead | text | YES | | assignee_type | text | YES | | refreshed | timestamp with time zone | NO | |
|
fields |
Created from getCustomFieldList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| id | text | NO | | name | text | YES | | description | text | YES | | orderable | boolean | YES | | navigable | boolean | YES | | searchable | boolean | YES | | custom | boolean | YES | | custom_id | bigint | YES | | custom_type | text | YES | | type | text | YES | | item_type | text | YES | | refreshed | timestamp with time zone | NO | |
|
groups |
Created from getGroupList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| name | text | NO | | refreshed | timestamp with time zone | NO | |
|
history |
Created from the getIssueHistoryList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | NO | | history_id | bigint | NO | | author | text | YES | | created | timestamp with time zone | YES | | field | text | NO | | type | text | NO | | from_string | text | YES | | to_string | text | YES | | from | text | YES | | to | text | YES | | refreshed | timestamp with time zone | NO | |
| Column |
|---|
| issue | | history_id | | field | | type | |
types |
Created from getIssueTypeList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | NO | | subtask | boolean | YES | | name | text | YES | | description | text | YES | | icon | text | YES | | refreshed | timestamp with time zone | NO | |
|
links |
Created from the getLinkList null CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | NO | | to_issue | text | NO | | type_name | text | YES | | type_id | bigint | NO | | link_description | text | YES | | link_direction | text | YES | | link_id | bigint | YES | | refreshed | timestamp with time zone | NO | |
| Column |
|---|
| issue | | to_issue | | type_id | |
types |
Created from getLinkTypeList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | NO | | name | text | YES | | inward | text | YES | | outward | text | YES | | refreshed | timestamp with time zone | NO | |
|
categories |
Created from getProjectCategoryList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | YES | | category | text | NO | | description | text | YES | | projects | text | YES | | refreshed | timestamp with time zone | NO | |
|
roles |
Created from getProjectRoleList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| name | text | YES | | description | text | YES | | id | bigint | NO | | refreshed | timestamp with time zone | NO | |
|
projects |
Created from getProjectList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| key | text | NO | | id | bigint | YES | | name | text | YES | | description | text | YES | | lead | text | YES | | default_assignee | text | YES | | project_type | text | YES | | project_url | text | YES | | jira_url | text | YES | | issue_security_scheme | text | YES | | notification_scheme | text | YES | | permission_scheme | text | YES | | refreshed | timestamp with time zone | NO | |
|
links |
Created from the getRemoteLinkList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | NO | | id | bigint | NO | | name | text | YES | | link | text | YES | | global_id | text | YES | | application | text | YES | | type | text | YES | | url | text | YES | | information | text | YES | | refreshed | timestamp with time zone | NO | |
|
screens |
Created from getScreenList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | YES | | name | text | YES | | description | text | YES | | refreshed | timestamp with time zone | NO | |
|
levels |
Created from getSecurityLevelList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| project | text | NO | | id | bigint | NO | | name | text | YES | | description | text | YES | | refreshed | timestamp with time zone | NO | |
|
status |
Created from getStatusList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | NO | | status | text | YES | | description | text | YES | | category_id | bigint | YES | | category_key | text | YES | | category_color | text | YES | | refreshed | timestamp with time zone | NO | |
|
transitions |
Created from the getTransitionList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | NO | | id | bigint | NO | | name | text | YES | | description | text | YES | | to_status | text | YES | | to_status_id | bigint | YES | | field_names | text | YES | | field_ids | text | YES | | required_field_names | text | YES | | required_field_ids | text | YES | | refreshed | timestamp with time zone | NO | |
|
users |
Created from getUserList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| user | text | YES | | key | text | NO | | name | text | YES | | email | text | YES | | time_zone | text | YES | | avatar_url | text | YES | | active | boolean | YES | | groups | text | YES | | last_authenticated | timestamp with time zone | YES | | last_password_change | timestamp with time zone | YES | | invalid_password_attempts | bigint | YES | | password_change_required | boolean | YES | | refreshed | timestamp with time zone | NO | |
|
versions |
Created from getVersionList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| project | text | NO | | id | bigint | NO | | name | text | YES | | sequence | bigint | YES | | released | boolean | YES | | release_date | timestamp with time zone | YES | | start_date | text | YES | | description | text | YES | | refreshed | timestamp with time zone | NO | |
|
voters |
Created from the getVoterList null CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | NO | | voter | text | YES | | key | text | NO | | name | text | YES | | avatar_url | boolean | YES | | refreshed | timestamp with time zone | NO | |
|
watchers |
Created from the getWatcherList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | NO | | watcher | text | YES | | key | text | NO | | name | text | YES | | avatar_url | boolean | YES | | refreshed | timestamp with time zone | NO | |
|
work |
Created from the getWorkList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| issue | text | YES | | id | bigint | NO | | start | timestamp with time zone | YES | | time_spent | text | YES | | time_spent_seconds | bigint | YES | | author | text | YES | | update_author | text | YES | | created | timestamp with time zone | YES | | updated | timestamp with time zone | YES | | comment | text | YES | | visibility | text | YES | | refreshed | timestamp with time zone | NO | |
|
workflows |
Created from getWorkflowList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| name | text | NO | | description | text | YES | | last_modified | text | YES | | last_modifier | text | YES | | step_count | bigint | YES | | default | boolean | YES | | refreshed | timestamp with time zone | NO | |
|
schemes |
Created from getWorkflowSchemeList JIRA CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | NO | | name | text | YES | | description | text | YES | | default_workflow | text | YES | | draft | boolean | YES | | refreshed | timestamp with time zone | NO | |
|
fields |
Created from getFieldList ServiceDesk CLI action |
| Column | Data type | Nullable |
|---|
| service_desk_id | bigint | YES | | project_key | text | YES | | project_id | bigint | YES | | type_id | bigint | YES | | type_name | text | YES | | field_id | text | YES | | name | text | YES | | required | boolean | YES | | type | text | YES | | item_type | text | YES | | system_field | text | YES | | values | text | YES | | value_labels | text | YES | | refreshed | timestamp with time zone | NO | |
|
projects |
Created from getProjectList ServiceDesk CLI action |
| Column | Data type | Nullable |
|---|
| id | bigint | NO | | project_key | text | YES | | project_id | bigint | YES | | name | text | YES | | description | text | YES | | refreshed | timestamp with time zone | NO | |
|
types |
Created from getRequestTypeList ServiceDesk CLI action |
| Column | Data type | Nullable |
|---|
| service_desk_id | bigint | YES | | project_key | text | YES | | project_id | bigint | YES | | id | bigint | NO | | name | text | YES | | description | text | YES | | help_text | text | YES | | request_type_groups | text | YES | | refreshed | timestamp with time zone | NO | |
|