You can translate the question and the replies:

Connecting Jira REST API as a Data Source Using Basic Authentication

Hi Denodo, I am trying to connect to the Jira REST API as a data source. Could you let me now the best way to retrieve all Issues? What authentication method should I use? I tried using Basic authentication, but it requires a username/password. I have generated an API Token in Jira, but can't find where I can input this. The Jira REST API documentation is located here: https://developer.atlassian.com/cloud/jira/platform/rest/v3/ for reference.
Authentication Jira REST API
user
30-06-2023 00:49:08 -0400
code

1 Answer

Hi, In order to connect to Jira you can use a Json Data Source. I was able to connect with the following configuration: * Data Route: HTTP Client. * Base URL: *`https://<your_user>.atlassian.net/rest/api/latest/`*. * Authentication: Basic. * Login: <your_email>, used to authenticate on atlassian.com. * Password: the token you generated (I got mine from [here](https://id.atlassian.com/manage-profile/security/api-tokens)). To retrieve all the issue: * Create a base view over you json data source with GET method and relative URL: *search* (this will return all the issues). * Use a Flatten View to transform the Base View in a tabular format. In particular I would flatten at issues level and delete some field from the output (expand, startat, etc.). Please refer to [JSON Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources#direct) and also [HTTP Path](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path) of the VDP user guide. Hope this helps
Denodo Team
03-07-2023 05:12:28 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here