API's, Download Tool, and Basic Auth Oh My!!

smoskowitz

Hi All --

I have been struggling with this issue for quite some time. I have a work around, but it no longer will be usable.

I have had a series of API's built for me that get information from an internally developed system. I take the URL for a particular API and put int into Postman. I then choose Basic Auth add enter my domain credentials. Postman then returns the data without any issue.

I first tried putting the same URL and credentials into Alteryx and running the workflow. When I run the workflow, I always receive the below error:

However, if I go into Postman and copy the the Basic Auth and put it into Headers of Alteryx -- Viola that works. It has come to my understanding that header is sort of unique to me and if my coworker now puts his domain credentials into Alteryx and tries to run the same workflow -- it fails with an unauthorized error.

The question now becomses, how do I do what Postman automatically does for each user? If a user puts in their username and password, how do I generate and pass that to the URL's API so I can retreive data and more importantly -- so others can so as well.

Thank you for your help.

Seth

smoskowitz

Hi again!

I found this article from @TashaA and it gets me close.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Guide-to-Creating-Your-Own-Connector-Authentication/ta-p/23582

I can't seem to figure out how to set up the formula correctly. Below is what I did:

I then Base64_encoded it and added Basic to the front of it.

Then in the download tool:

However, I still don't get back any information. I receive a:

HTTP/1.1 400 Bad Request
Content-Type: text/html; charset=us-ascii
Server: Microsoft-HTTPAPI/2.0
Date: Wed, 17 Feb 2021 21:00:27 GMT
Connection: close
Content-Length: 311

Any assistance would be greatly appreciated.

Thanks,

Seth