Skip to content

[Story]: Jira CSV issue connector adapter #160

Description

@adoLime

User Story

As an admin, I want to import a Jira issue export (CSV) and ingest the issues into the canonical artifact store, so that project tickets become searchable knowledge in the chat without a live Jira API integration.

Context & Motivation

Dependencies

Acceptance Criteria

  • Given a Jira CSV export uploaded via the ingestion endpoint, when parsed, then each row becomes a canonical artifact with: summary -> title, description -> body, plus key, status, type, assignee, labels as metadata.
  • Given a CSV with custom/unexpected columns, when parsed, then known fields map and unknown columns are preserved as raw metadata (no data loss, no crash).
  • Given a re-import of the same export, when processed, then issues are matched by Jira key + hash and updated, not duplicated.
  • Given a malformed row, when parsing, then that row is reported as failed and the rest import (partial success).
  • Given each imported issue, when stored, then provenance is set: source_system=jira, source_id=<issue key>, ingestion_run_id.
  • OpenAPI documented; a sample Jira export imports end-to-end on dev and is queryable via chat.

Sub-Tasks

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requeststoryteam:backendBackend team (sprintstart-backend, Kotlin/Spring Boot)

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions