Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here

Alteryx connect to VSTS via API URL (Azure) using Personal Access token

Highlighted
5 - Atom

Hi 

I am trying to access VSTS API URL (Azure) from Alteryx using download tool. Normal configuration with email id password couldnt establish the connection. Then while searching came accross the use of Personal Access token. Could you please share the sample code if you have done something similar to this.

 

Regards,

Margret

Highlighted
5 - Atom

In the connection Download tool header option you need to use PAT token as well as convert the PAT to 64 bit using powershell

Highlighted
8 - Asteroid

@MaryMargret Are you able to share an example workflow or screens shots of the configuration of the download tool? We are facing this exact problem. 

Am I correct in understanding that the normal PAT token is 32 bit and we need to have both 32 bit and 64 bit in the text input going into the download tool?

 

Any help you can provide would be very much appreciated. 

 

Thank you,

Cameron

Highlighted
8 - Asteroid

Hi All, 

 

Attached is an example of how to successfully connect to VSTS/Azure DevOps via Rest API for a GET request. Adjustable for PUT or POST requests as well. 

 

Hope this helps some users looking to do this. Need to update the first API endpoint with your proper URL and then paste in your personal authentication token. Both of these changes are made in the text input tool. The API endpoint provided will take a query and return all of the work item IDs from the query. 

 

Other endpoints can be found in the Microsoft ADO documentation: https://docs.microsoft.com/en-us/rest/api/azure/devops/?view=azure-devops-rest-5.0

 

Feel free to reach out if anyone has questions.

 

Cheers,

Cameron

Highlighted
5 - Atom

Hey Cameron. Your post really helps. But can we also update a column in TFS WorkItem through Alteryx.

Highlighted
6 - Meteoroid

How to find the token then? In the example, there is a field called "Token".

Highlighted
6 - Meteoroid

I figured out how to generate the personal access token. It is in DevOps area. Here is the instruction from MS:

 https://docs.microsoft.com/en-us/azure/devops/organizations/accounts/use-personal-access-tokens-to-a...

 

However, I have received the token truncated error message. So, I wonder if anyone can help a bit further. 

 

Highlighted
5 - Atom

Hi there - were you able to get this to work?  I'm getting the Token was truncated error as well.

Highlighted
5 - Atom

Struggling with this also.  The token truncated warning I solved in the first formula tool - instead of modifying the existing fixed length string, I made a new string of a longer length.  However my API call to Azure DevOps is still not working.  I get a 404 not found error:

HTTP/1.1 200 Connection established

HTTP/1.1 404 Not Found

When setting authorization = "Basic" + Base64_encoded and accept = "application/json".
I've checked, and these headers and encoding work perfectly when calling the same endpoint using the Python requests library, and a cURL version also works.  So it's specifically an Alteryx issue for me.  Anyone else seen this?

Labels