JIRA : Connexion with OAuth1

[dranny]

Hi,

I hope that someone could help me... 

I want to retreive Data from Jira usint Jira API Rest.

In all example or in Jira Content Pack, we use API KEY or user/Password. In my case I must use OAuth method with client ID, RSA key, Token...

A collegue wrote me a Python code to test and it's works...

import requests

from requests_oauthlib import OAuth1
from oauthlib.oauth1 import SIGNATURE_RSA

CONSUMER_KEY = 'KEY'
ACCESS_TOKEN = '99999999999999'
ACCESS_TOKEN_SECRET = '9999999999999'
PRIVATE_KEY= '''-----BEGIN RSA PRIVATE KEY-----xxxxx'''

auth = OAuth1(CONSUMER_KEY,
'doesnt_matter', # not used, can be any string
ACCESS_TOKEN,
ACCESS_TOKEN_SECRET,
signature_method=SIGNATURE_RSA,
rsa_key=PRIVATE_KEY,
signature_type='auth_header')

r = requests.get('https://jira.xxxxxxx.com/rest/api/2/search', auth=auth)
print(r.text)

And I don't know to do the same on Power BI, passing parameter on Header and Autorization part...

[v-shex-msft]

HI @dranny,

Normally you need to use web connect to handling api link and send request.

Working with Web Services in Power Query

You can also refer to below link to know more about this.

Regards,

Xiaoxin Sheng

[dranny]

Thanks,

very interesting but I didn't have API Key, I want connect with OAuth, and I don't know how to pass the parameter....

[v-shex-msft · Accepted solution]

Hi @dranny,

Maybe you can take a loot at following link:

Get Data from Twitter API with Power Query

Regards,

Xiaoxin Sheng