nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Setting up REST in Azure Data Factory Linked Service

Mark Northcott_clxwl6

Hello all,

I'm trying to connect to Jira Align via REST in Azure and I am having trouble setting up Azure Data Factory Linked Service .

I try Basic Authentication (as OAuth2 is not avialble with JA) and have tried username and password as well as varied versions of API Token, with or without "Bearer", with or without userxxxx| but I don't seem to get it to pass. All I get is "Rest call failed with client error, status code 401 Unauthorized, please check your activity settings."

I can get them to work in Swagger and Postman so I know the API Token is working, but I just don't know how to configure them in Data Factory.

Any help would be appreciated.

Accepted answers

Mark Northcott_clxwl6

I got a reply from Atlassian and this works.

When setting up the Linked Account in Azure Data Factory to connect to Jira Align via REST API, and you use pretty much anything ...... it will show as connected but when you try to create a source connection in the CopyData activity, it will fail.

So, going back to the Linked Service you are trying to create, firstly, rather than set it as Basic, set the Authentication Type : Anonymous

Now move down to the Auth Headers. I then selected Authorization from the Name dropdown and under Value dropdown I added the string Bearer useryyy:|xxxxxxxxxxxxxxxxxxx with yyy being your User ID and xxxxxxx being your API Token (See User Menu>> Edit Profile >> API Token .

NOTE: You can add the string to your Key Vault as well and attach it

Now, when you then go to your CopyData Activity which is connected to this Linked Service, and you Preview Data ....... It works.

So .... that's it.

All comments

Mark Northcott_clxwl6

Marco Ycaza Lengua

Hello @Mark Northcott ,

I tried what you said , I put exactly Bearer useryyy:|xxxxxxxxxxxxxxxxxxx and didn't work. I guess that the pipe '|' should be omitted. So I tried like this.

Bearer user70999:xxxxxxxxxxxxxxxxxxxxxxxxxxx but got no data in response , maybe there something else I need to take into consideration:

Thanks for the contribution,

Mark Northcott_clxwl6

Hello Marco, I think it is the base URL that's the problem

You need to trim it to https://marcoycaza.atlassian.net

The full URL you add to the dataset as the Relative URL

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-align