API - Authorization with PFX certificate

[rohan_tibarewala]

Is it possible to make API calls using Alteryx (Download tool or some other way), where the authorization method requires PFX certificate to be passed through Header?

[rkapoor]

@rohan_tibarewala not sure if this will work or help, but check out this article:

https://community.alteryx.com/t5/Dev-Space/Download-Tool-API-requiring-Client-Certificate-for-SSL/td...

[Jean-Balteryx]

Hi @rohan_tibarewala ,

Using the Download tool you can specify the headers values you want to pass through the call.

Here is the documentation of the tool : https://help.alteryx.com/20212/designer/download-tool

[rohan_tibarewala]

@Jean-Balteryx Thank you so much for prompt response. Can you please tell me what should be the 'Name' and 'Value' to pass the certificate?

We are trying to use 'Authorization' as the 'Name', and Base64 encoded string as the 'Value', but not able to make it work.

[rohan_tibarewala]

@rkapoor Thank you for the prompt response. The article seems to be discussing similar issue, but i could not find the right solution in it. Will try few more things mentioned there.

[Jean-Balteryx]

Based on Wikipedia HTTP Headers page I found this for Authorization header : Authorization: Basic QWxhZGRpbjpvcGVuIHNlc2FtZQ==

Adding "Basic" keyword may help.

[rkapoor]

@rohan_tibarewala let us know how you get on.

[rohan_tibarewala]

@Jean-Balteryx @rkapoor  Unfortunately I could not make the Download Tool to call API with PFX certificate. But we were able to run Python code for it and used Python tool within Alteryx to call that API.

[SergioMartinez]

Hello, by any chance, do you have the Python Script that you could share? I have the same requirement to use an API using PFX files, but it seems it is not possible through the Download Tool, so I would like to see what challenges or issues you faced when using the Python Script and how you buit it if possible, thanks in advance.