Download data from a Google Sheet and send it to Azure DevOps API using PATCH method

[palczo]

This is the Alteryx workflow I've currently got: 

I know the Google Sheets Input tool is deprecated, but I'm working on a version of Alteryx provided by my company that's still using it, hence its presence here.

When I run the workflow, the error that I get at the very end is HTTP/1.1 401 Unauthorized, despite having set the headers (Authorization and Content-Type) correctly.


From what I've found so far on the forum the issue is that the API expects Basic authentication which is a Base64 encoded username:password string (which I have already prepared), but I've got no idea how to marry the two, so that it all works together.

Basic Authentication:

[apathetichell]

what is your configuration of your download tool - ie are you passing in your basic auth field in your header? Are you sure that this works outside of Alteryx - ie if you throw the endpoint in postman and use basic auth does it give you a 200/201?

[palczo]

Yes, I am and I'm still getting a 401, unfortunately.

It works in Postman, I'm always getting a 200 OK status.