Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

OData authentication with Download tool

DavidP
17 - Castor
17 - Castor

Hi everyone,

 

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

1 REPLY 1
DavidP
17 - Castor
17 - Castor

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.

 

DavidP_0-1639008987254.png

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

 

DavidP_1-1639009283081.png

 

The macro is attached for anyone that is interested.

Labels
Top Solution Authors