Connecting Alteryx to USPS Crosswalk API

[JanieD]

Hi,

Does anyone have any experience connecting the USPS Crosswalk API using the Download tool?  I've been successful with other APIs just adding the key to the Header tab in the configuration window, but this API is vexing me.

My access key works when I test it on their site, but the error that I'm getting in Alteryx is:

{"error":"Unauthenticated"}

HTTP/1.1 401 Unauthorized

I know API keys in the header can be sensitive, and I've tried every combination that I can think to name the key in the header configuration of the Download tool, but I'm stumped. 

Thanks in advance for any ideas!

Jane

So I was wondering if anyone else has experience with this API and can provide insight on how to configure the head or if there are other ideas on how to execute the API call to solve for the authentication error?

[apathetichell · Accepted solution]

You should be using a formula token to add your Bearer token to a field called Authorization. Your formula tool should be set up as:

"Bearer "+[token] - and then you should add Authoriation to your headers. Confirmed - this works.

Also - make sure you are using a PAT which you generate on the API screen vs your username/password.

[JanieD · Accepted solution]

That worked. Thank you!

[apathetichell]

Can you mark my answer as correct - thanks!