topic Re: Building OAuth certificate for Alteryx Server API in Alteryx Server Discussions

Building OAuth certificate for Alteryx Server API

Matteop9 — Mon, 14 Mar 2022 12:30:43 GMT

Hello

I am trying to play around the with the API functionality to kick off a workflow on server. Specifically the subscription API.

Using the interactive documentation I can get it working, and I am aware that I need to build the oauth certification when I try to use Alteryx to make these calls.

Everything I try it says the certification is invalid.

I have tried using the macros here:

https://github.com/TheInformationLab/alteryx-api-tools

https://community.alteryx.com/t5/Alteryx-Server-Discussions/How-to-Run-a-Job-Using-Alteryx-Server-API-and-Python/td-p/312363

Any help on how anyone else might already do it would be much appreciated.

Re: Building OAuth certificate for Alteryx Server API

patrick_digan — Mon, 14 Mar 2022 12:57:04 GMT

@Matteop9 I would give my api runner a try or this macro that @rachel_dunlavy from alteryx posted to the gallery. If either of those doesn't resolve the issue, any code or screenshots would be helpful and the community can try to help you debug. The oauth is very particular (including casing, order). This post from a few years ago may be helpful (I'm biased), especially this section:

Re: Building OAuth certificate for Alteryx Server API

Thableaus — Mon, 14 Mar 2022 13:14:45 GMT

Hi @Matteop9

I also created a Python-based macro to generate the URL request and the Authorization headers with the correct signature.

https://community.alteryx.com/t5/Public-Community-Gallery/OAuth-1-0-Signature-Generator/ta-p/913479

Feel free to test it.

Cheers,

Re: Building OAuth certificate for Alteryx Server API

Matteop9 — Mon, 14 Mar 2022 14:30:31 GMT

Hi @patrick_digan, thanks for the suggestions.

Using your API runner I get to the same issue unfortunately.

I have updated the URL to my gallery URL, added my key and secret (The same ones that work in the interactive documentation) but to no avail, tried both python and R and selecting de selecting all of the options.

There isn't much else I can share on this issue as I am just adding my credentials to an existing workflow.

Re: Building OAuth certificate for Alteryx Server API

Matteop9 — Mon, 14 Mar 2022 14:31:24 GMT

Hi @Thableaus

Thanks for the tool.

I seem to be missing some tools from the macro?

Re: Building OAuth certificate for Alteryx Server API

Thableaus — Mon, 14 Mar 2022 14:38:06 GMT

@Matteop9

Could you please try to download it again? I put the whole .yxzp file with all dependencies now, sorry for that.