Atlassian JIRA search deprecation

[AL-Cythera]

The Redash JIRA query runner references an Atlassian API endpoint which had been announced as deprecated over a year ago.

redash/redash/query_runner/jql.py

Line 163 in f95156e

jql_url = "{}/rest/api/2/search".format(self.configuration["url"])

https://developer.atlassian.com/changelog/#CHANGE-2046

We’re deprecating the following Jira Platform REST endpoints:

GET /rest/api/2|3|latest/search - Search for issues using JQL (GET)

This query runner is now completely broken

[yoshiokatsuneo]

Thank you for the report !
I think we need to update the endpoint.
But, I'm not using JIRA as a data source.
I think we are welcome Pull Request for this issue if there is anyone who want to contribute.

[artemsafiyulin]

Hello @AL-Cythera !
We had same problem about week. I created PR with our solution (updated jql.py for using new API).
But I am not sure how correct I created PR and how fast they merge it (if they merge) - so as fast solution you can just use this update code in your installation. If you use docker compose as we:

1. copy updated jql.py to your server
2. update docker-compose.yml and mount this file to correct path:

x-redash-service: &redash-service
  image: redash/redash:25.1.0
  depends_on:
    - postgres
    - redis
  env_file: /opt/redash/env
  restart: always
  volumes:
    - ./jql_apiv3.py:/app/redash/query_runner/jql.py:ro

3. restart docker-compose

[yoshiokatsuneo]

@artemsafiyulin

Thank you very much for the Pull Request !
I just reviewed and merged the PR. So, using the latest master branch should fix the issue.