confluence REST API using in Alteryx.....

[Raj_007]

Hi All,

Thanks for your time. could anyone help or guide me in connecting to the confluence page using the REST API from Alteryx.

I have the URL to the confluence page and there is  a table object with some data and i want to pull this data through Alteryx

[apathetichell]

you use the download tool. you use the confluence rest api guide. What are you having an issue with?

[Raj_007]

Hi, Thanks a lot; I took the URL of the confluence page where the table object is existing.. when i put the URL in browser i can see the data but when i get into download tool

i get 302 error.. i do not have the confluence REST API details... could you please help if you have any details on the confluence REST API 

[apathetichell]

Hey -> so you may want to review what a rest api is. You're using that term -> but throwing a url in the download tool is just webscraping. It won't work. To use the rest api - you'll need to follow the confluence api instructions. You should create a PAT and follow numerous guides here on how to get that base 64 encoded and set up your authorization. you then feed your authorization into your download tool with the rest endpoint (example:

{{protocol}}://{{host}}/wiki/rest/api/content/{{page number}}?expand=body.storage

where you fill in those values. you set up your content_type to application/json -> and then you run a get request. you'd then need to parse what's returned (html values) to get your table.

[Raj_007]

Hi, confluence REST API authentication is based on OAuth1.0  - I could not find any examples on oAUth1.0 - i was able to test the rest API URL or endpoint in postman but not able to get the same setup in Alteryx

[Raj_007]

PAT is disabled in my firm they have a different setup to get the access token - through devshell we run few commands - tried few settings within header but it is still 400 error

[apathetichell]

Oauth 1.0 -> not 2? Ie this- > https://developer.atlassian.com/cloud/jira/software/jira-rest-api-oauth-authentication/ ? it's really not used. I'd try generating the token via the CLI commands -> taking that token -> testing the token in Postman. If it works -> look at the headers you are sending in Postman and add them to Alteryx - specifically Content-Type which you have to manually set. That can lead to a 400 error - but also issues with missing/incorrect parts of an Oauth 2.0 grant process would lead to a 400.

The pain point here should be converting the .html table to Alteryx data. So it doesn't get easier.

[Raj_007]

correct oauth1.0 - i already got the access token using the process that is documented but when i tried to use that access token within the header along with some other header values 

it is when i got the 400 error - i think its better to go with python

[apathetichell]

Hey - so there are lots of reasons this could be happening. I can't troubleshoot this for you without seeing your set up in Postman and your setup in Alteryx. Probably easiest is to just use Python. My hunch (high 90s% probability) is that what you are doing in Postman should work in Alteryx but getting there really requires testing things out/diving into the actual postman details and your actual Alteryx payloads.

tldr - stick with Python.