Connecting Alteryx to USPS Crosswalk API

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?

Error Message

Accepted answers

apathetichell

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

That worked. Thank you!

All comments

apathetichell

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

That worked. Thank you!

apathetichell

Can you mark my answer as correct - thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703