REST API Call

[bakaidora]

Dear All,

I need to use a REST API Call and I am thinking about to use the Alteryx. However I have never seen any examples for that, is feasible at all.

I have the following information:

Can you please let me know how the API can be used in Alteryx? Do you have any example for that?

Thanks in advance,
Dóra

[OllieClarke]

Hi @bakaidora you can absolutely use Alteryx to connect to Rest APIs through use of the Download tool info here: There's a tool mastery blog about doing just that (comparing it to cUrl) available here:

Basically you can set the headers in the tool, or provide them as fields before (so they're not hardcoded), and for the request body you can again either hard code it into the tool, or create it dynamically using a formula tool before.

Hope that helps

Ollie

[Ezra-Kirk]

Hey Ollie,

Is the download tool secure? It seems like it uses HTTP, rather than HTTPS?

Is it safe to send API tokens in the header of a HTTP request? I've heard the Python tool is an alternative in order establish a secure connection for REST APIs.

Thanks,

Ezra

[OllieClarke]

@Ezra-Kirk I believe that if the url of the API uses https (as yours looks to) then the headers will be encrypted in transit and so should be secure. I'm not an expert in this area however - although authenticating through API key headers is a very common practice so I would think that it is safe... 

[Ezra-Kirk]

Thanks Ollie - any ideas how I might get a definitive answer on this? Not willing to take too many risks on this until I'm sure! Thanks :)