Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jira Connector: "issues" stream structure changed unexpectedly #5256

Closed
jgtvares opened this issue Aug 6, 2021 · 4 comments · Fixed by #5523
Closed

Jira Connector: "issues" stream structure changed unexpectedly #5256

jgtvares opened this issue Aug 6, 2021 · 4 comments · Fixed by #5523
Assignees
Labels

Comments

@jgtvares
Copy link

jgtvares commented Aug 6, 2021

Enviroment

  • Airbyte version: 0.28.2-alpha
  • OS Version / Instance: AWS EC2
  • Deployment: Docker
  • Source Connector and version: Jira 0.2.8
  • Destination Connector and version: Postgres 0.3.7
  • Severity: Medium
  • Step where error happened: Update connector

Current Behavior

The stream issues used to contain a lot more information in the fields object.
Attributes like: project, statuscategorychangedate, summary and others, are missing.
I'm using Grafana to query through data and create dashboards and since those attributes are now missing, my dashboards are broken.

I've tried to downgrade the connector to version 0.2.7, but no success.

Expected Behavior

The stream issues should return all issue information (just as the Jira Rest API provides).
With that behaviour we won't need to perform join queries to retrieve complementary issue data.

Steps to Reproduce

  1. Create a Jira connection
  2. Perform a sync (with the issues stream selected)
  3. Try to retrieve the project that issue belongs to:
    SELECT * FROM issues I
    WHERE I.fields -> 'project' ->> 'key' = '<your-project-key>';

Are you willing to submit a PR?

No.

@jgtvares jgtvares added the type/bug Something isn't working label Aug 6, 2021
@marcosmarxm
Copy link
Member

@vovavovavovavova any reason why this field was removed in #4947 ?

@yevhenii-ldv
Copy link
Contributor

@jgtvares

We just merged this fix into master and released a new version of the connector.

Upgrade your connector to version 0.2.10 and get started. To upgrade your connector version, go to the admin panel in the left hand side of the UI, find this connector in the list, and input the latest connector version.

Please let us know if you have any further questions.

Enjoy!

@jgtvares
Copy link
Author

jgtvares commented Sep 3, 2021

@yevhenii-ldv It is behaving the same as before for me. A lot of props are still missing from fields column.

@GiannisDimitriou
Copy link

@yevhenii-ldv As @jgtvares mentioned some attributes in the field object is still missing, should we expect a new release soon ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

8 participants