MSPBots WIKI : Jira Public Datasets
Here are the published or alpha version Jira datasets that you can use to create the widgets and dashboards.
In total, there are 18 publish/alpha Datasets
| Name | Description | Created Date | Last updated | Fields |
|---|---|---|---|---|
| Jira Users | Jira user information | Aug 24, 2020 | Jul 07, 2023 | ["id", "tenant_code", "key", "name", "email_address", "display_name", "active", "sync_time", "ad_email_address", "user_post", "sys_user_id", "sys_status", "manager", "manager_up"] |
| Jira Spint information | Jira Spint information | Aug 24, 2020 | May 19, 2021 | ["board_name", "sprint_id", "name"] |
| Jira Project information | Jira Project information | Aug 24, 2020 | Aug 25, 2020 | [] |
| Jira Issues | Jira Issue List | Apr 04, 2021 | Jan 04, 2024 | ["suemail", "form_time", "manager", "id", "link", "number", "tenant_code", "summary", "status", "issuetype", "sprint", "sprint_status", "duedate", "remainingday", "createtime", "updatetime", "assignee", "email", "assignee_post", "storypoint", "priority", "project", "fixversion", "epickey", "epicsummary", "creator", "creator_email", "components", "test_case", "qa_owner", "dev_owner", "resolution_name", "resolution_description", "labels", "qa_check_logdate", "cause_analyze_form", "staytime", "module", "client", "parent_key", "parent_ticket_summary", "parent_sprint", "time_estimate", "time_original_estimate", "classification", "report_name", "report_email_address", "root_cause", "billable_seconds", "release_date", "released", "create_time_utc", "verified_time", "resolved_time", "issue_links", "description", "logged_hour"] |
| Jira Changelog info | Jira issue changes log, work log | May 31, 2021 | Dec 10, 2022 | ["issue", "number", "tenant_code", "summary", "status", "issuetype", "sprint", "duedate", "remainingday", "createtime", "updatetime", "assignee", "email", "assignee_post", "story_point_day", "priority", "project", "fixversion", "story_point", "part_story_point", "person_log", "all_log", "log_percent", "change_time", "change_time_cct", "changelogs_id", "changelog_author", "changelog_email", "changelog_post", "assignee_change", "field", "change_to", "change_from", "to_string", "from_string", "worklog_id", "logwork_author", "worklog_time", "worklog_time_cct", "log_work", "worklog_comment", "logtimes", "components", "rank"] |
| jira_issue_subtask | jira_issue_subtask | Sep 27, 2021 | Jan 19, 2022 | ["id", "tenant_code", "issue_id", "subtask_id", "key", "self", "status_id", "status_name", "status_self", "status_icon_url", "status_description", "status_category_id", "status_category_key", "status_category_name", "status_category_self", "status_category_color_name", "summary", "priority_id", "priority_name", "priority_self", "priority_icon_url", "issue_type_id", "issue_type_name", "issue_type_self", "issue_type_icon_url", "issue_type_subtask", "issue_type_avatar_id", "issue_type_description", "issue_key", "issue_parent_key", "issue_summary"] |
| Jira Server Worklog - API | ODS Dataset which generated from Jira Server Worklog | Jan 06, 2022 | Mar 07, 2023 | ["id", "tenant_code", "worklog_id", "issue_id", "author_display_name", "comment", "time_spent", "time_spent_seconds", "create_time", "update_time", "starte_time", "sync_time", "self", "author_key", "author_name", "author_time_zone", "author_active", "author_email_address", "update_author_key", "update_author_name", "update_author_time_zone", "update_author_active", "update_author_email_address", "update_author_display_name"] |
| Jira Server Project - API | ODS Dataset which generated from Jira Server Project | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "project_id", "key", "name", "description", "lead_display_name", "project_type_key", "assignee_type", "archived", "sync_time"] |
| Jira Server User - API | ODS Dataset which generated from Jira Server User | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "key", "name", "email_address", "display_name", "active", "sync_time"] |
| Jira Server Sprint - API | ODS Dataset which generated from Jira Server Sprint | Jan 06, 2022 | Jan 20, 2022 | ["id", "tenant_code", "sprint_id", "state_key", "name", "board_name", "date", "type", "sync_time"] |
| Jira Server Issue - API | ODS Dataset which generated from Jira Server Issue | Jan 06, 2022 | Aug 03, 2023 | ["qa", "id", "tenant_code", "issue_id", "key", "summary", "description", "fix_versions_names", "sprint_name", "epic_link", "story_points", "priority_name", "team_name", "type_name", "creator_display_name", "project_name", "due_date", "assignee_display_name", "status_name", "create_time", "update_time", "sync_time", "components", "bot_status", "module", "client", "contact_email", "forum_url", "root_cause", "labels", "parent_key", "time_estimate", "time_original_estimate", "is_blocked_by", "resolution_name", "resolution_description", "qa_owner", "dev_owner", "report_name", "report_email_address", "create_time_utc", "update_time_utc", "organization_id", "organization_name", "code_project", "request_type", "current_status", "root_cause_for_qa", "issue_link", "assignee_email_address", "end_date", "asset_type_dataset_count", "asset_type_bot_count", "asset_type_dashboard_count", "asset_type_widget_count", "asset_type_asset_type_blocker", "detail_client_escalation", "client_followed_up", "bg_designprovided", "new_integration", "client_concierge_hours", "estiimated_effort", "client_ticket_type", "subscription_legacy", "purpose", "ageing", "vip", "scope_of_work", "missing_sow", "client_subscription", "hubspot_link", "bg_migration_link", "sharepoint_link", "migration_type", "onboarding_type", "budget_hours", "integrations", "approver_name", "approver_key", "next_step", "skip_onboarding", "client_risk_level", "concierge_type", "subtype", "subscription", "tier_level", "needs_kb_article", "onboarding_task", "parent_id", "team_select", "aggregatetimespent", "description_html"] |
| Jira Server Project Version - API | ODS Dataset which generated from Jira Server Project Version | Jun 01, 2022 | Jun 01, 2022 | $row.get($key) |
| Jira Server Board Sprint - API | ODS Dataset which generated from Jira Server Board Sprint | Jun 07, 2022 | Jun 07, 2022 | $row.get($key) |
| Jira Server request Comment - API | ODS Dataset which generated from Jira Server request Comment | Nov 10, 2022 | Nov 10, 2022 | ["id", "tenant_code", "other_id", "body", "public_name", "author_name", "author_key", "email_address", "display_name", "active", "time_zone", "links", "created_iso8601", "created_jira", "friendly", "epoch_millis", "sync_time", "issue_id"] |
| jira subtasks | ODS Dataset which generated from jira subtasks | Mar 22, 2023 | Mar 22, 2023 | ["id", "tenant_code", "issue_id", "subtask_id", "key", "self", "status_id", "status_name", "status_self", "status_icon_url", "status_description", "status_category_id", "status_category_key", "status_category_name", "status_category_self", "status_category_color_name", "summary", "priority_id", "priority_name", "priority_self", "priority_icon_url", "issue_type_id", "issue_type_name", "issue_type_self", "issue_type_icon_url", "issue_type_subtask", "issue_type_avatar_id", "issue_type_description", "issue_key", "issue_parent_key", "issue_summary"] |
| Jira Server Queues - API | ODS Dataset which generated from Jira Server Queues | Mar 29, 2023 | Mar 29, 2023 | ["id", "tenant_code", "queue_id", "name", "jql", "links", "fields", "sync_time"] |
| Jira Server Queues Issue | ODS Dataset which generated from Jira Server Queues Issue | Mar 29, 2023 | Mar 29, 2023 | ["id", "issue_id", "key", "queue_id", "sync_time", "tenant_code"] |
| Automated List Of Client Contacts For The Recipients | MB-30716 | Nov 16, 2023 | Dec 07, 2023 | ["name", "business_type", "gadget_id", "status"] |