Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,464 questions
I can connect to Jira via ADF's Jira Connector, but I can't pull any data.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 17%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Gue, David
0
Reputation points
Hi,
I can connect to Jira via ADF's Jira Connector, but I can't pull any data - I get an error:
- "Error code # 9602
- [Microsoft][JIRA] (62) API Connection Failed. Forbidden Request. HTTP Response code: 401".
However, when creating the Source dataset, I can list the Jira tables, and when creating the Copy activity, I can import a table schema.
Thank you. Dave.
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesh Gurram 6,460 Reputation points Microsoft External Staff2025-05-02T02:43:09.9233333+00:00 Based on your description, we understand that you're able to successfully connect to Jira using Azure Data Factory’s Jira connector, list the available tables, and even import the table schema. However, the error message: Error code #9602 [Microsoft][JIRA] (62) API Connection Failed. Forbidden Request. HTTP Response code: 401 suggests that authentication is failing during the actual data retrieval phase, even though initial metadata access is successful.
This behavior typically indicates that:
The credentials used (username/API token) are either incorrect or expired, or The account used lacks necessary permissions to read the data via Jira’s REST API.
While metadata (like table listing) may be accessible with minimal permissions, reading actual issue data through the API requires explicit project-level permissions.
Verify API Credentials - Jira Cloud requires an API token instead of a password. Please follow these steps:
- Go to Jira API Token Management
- Generate a new API token.
- In the ADF linked service - Set the username as your Jira email address. Set the password as the newly generated API token.
- Save and test the connection.
Ensure Correct Permissions in Jira - Please verify that the Jira account used in ADF has at least the following permissions for the relevant project(s): Browse Projects, View Issues
If necessary, your Jira admin can help assign these permissions.
Clear Any CAPTCHA Locks (if applicable) - If there have been multiple failed login attempts, Jira might block API access via CAPTCHA. To resolve this:
- Log into Jira using the same account via a web browser.
- Complete any CAPTCHA challenges shown.
Similar issues: https://learn.microsoft.com/en-us/answers/questions/939302/azure-data-factory-jira-connector-linked-service-e
For more details refer: https://learn.microsoft.com/en-us/azure/data-factory/connector-jira?tabs=data-factory
I hope this information helps.
Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
-
Gue, David 0 Reputation points
2025-05-02T14:04:51.8033333+00:00 Hi, Ganesh Gurram ... thank you very much!
This did the trick:
"In the ADF linked service - Set the username as your Jira email address. Set the password as the newly generated API token."
I was using the API Token Name for the username.
Also, thank you for providing great details (such as):
"While metadata (like table listing) may be accessible with minimal permissions, reading actual issue data through the API requires explicit project-level permissions."
Also, I'm trying to "upvote" your answer, but the upvote does not persist - the upvote reverts to 0 from 1.
You've been a great help! Dave.
Sign in to comment
Sign in to answer