Jira connection

Hello I'm trying to use the download tool to connect to a JIRA site. But i keep getting this message:

{"errorMessages":["You·currently·don't·have·access·to·perform·this·operation."],"errors":{}}

if i call the rest API in my browser i get a result but via the download tool i get this acces denied. I do have my user name and Password set.

Alteryx Jira.PNG

Do i have to set a header or Payload. And how do i do that?

Regards Humberto

API

Download

Accepted answers

jgo

Hi @kelkboom,

Unfortunately, you don't supply this post with enough information to help troubleshoot the issue. That said though, troubleshooting API requests is always going to be tricky because the requirements of the API service varies from site to site.

It is possible that you have to set what headers to send and/or the payload and also what type of request is it (GET, PUT, PULL, ETC...). This information is usually available by the services API documentation.

Hard to say why it works when you call it on your browser directly vs Alteryx, but one thing that I've encountered in the past is that calling the API in the browser sometimes utilizes your same authenticated session if you've already logged into the site. Every time Alteryx attempts to make a call will establish a new session, so authentication would need to be re-established.

The "Username/Password" options in the Download tool sometimes does not satisfy the authentication requirements of the API.

I understand this does not give you any solution, but I'm hoping that this will give you some insight as to why it might not be working and some ideas on how to troubleshoot further.

Coxta45

@kelkboom, @jgo,

After tinkering with JIRA's REST API (which is pretty solid and easy to use) I went ahead and built a JIRA Connector for Alteryx.

Community Post & Documentation: https://community.alteryx.com/t5/Data-Sources/JIRA-Connector/m-p/51562

Link to Connector in Public Gallery: https://gallery.alteryx.com/#!app/JIRA-Connector/58d87c2feffc2a0dd0b5ed8f

Cheers,

Taylor Cox

All comments

jgo

Hi @kelkboom,

The "Username/Password" options in the Download tool sometimes does not satisfy the authentication requirements of the API.

I understand this does not give you any solution, but I'm hoping that this will give you some insight as to why it might not be working and some ideas on how to troubleshoot further.

kelkboom

thnx,

it did push me in the wright direction. The solution is to insert two headers.

Authorization: strating with the word "Basic" and the the user:password hasched as 64bit.
and a content discriping the result as a JSON format

regards Humberto

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335