OData authentication with Download tool

[DavidP]

Hi everyone,

Does anyone have any experience with using OData with the Download tool? Specifically, how to implement authentication.

[DavidP · Accepted solution]

For anyone stumbling onto this post looking for information on how to connect to OData with the Download tool, here is the solution that worked for me. I based my solution on this post, which explains how to implement Basic Authentication within the header of the Download tool.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Guide-to-Creating-Your-Own-Connecto...

My workflow looks like this, with placeholders in the Text input tool for the API URL, username and password.

I went one step further and wrapped it in a Standard Macro

The macro is attached for anyone that is interested.