oAuth 'library' or solution for use in Alteryx workflows?

anthony

Does anyone have a workflow/macro for using oAuth for User Authentication to APIs?

Even a third party app I can use with Run Command tool?

Or anything you can point me to so I can get access to API's with download tool that use oAuth?

Thanks,

Anthony

Download

Accepted answers

johnd2202

I know this is an old post, but wanted to share an easy way to gain access to a Shopify site using Alteryx. This method can only be used for a private app in your own store. The public apps require an oAuth authentication method whereas the private apps do not.

Create your private app in your store. You can Google how to do this if you don't know how.
Using a Text Input tool, Create three fields which will have your URL, API Key, and Password. The URL will be formatted like "https://YOUR SHOP NAME.myshopify.com/admin/products.json" (The products.json is just an example of one of the API options they offer. Read their API docs for more options.)
Once you have the credentials, use a formula tool and input a formula that will concat the API Key and the Password fields with a colon in between. For example, [API Key]+":"+[Password]
Now you need to encode the concatenated fields using the Base64 Encoder tool.
Next step is to use another formula tool and concat the word "Basic " and the Base64 encoded field with a space and name the field "Authorization." The result should look something like this. "Basic NjJjGEa1MjEwMDZM2FlMGVlMTA="
Now you're ready for the Download tool. Select the URL field as your URL in the Basic tab of the download tool and select the Authorization field in the Header tab.
Run the workflow and you should have a successful connection to your store.

Alteryx coupled with Shopify can be incredibly useful. I have attached a basic example workflow just in case my directions were hard to follow.

Shopify Connect.yxmd

All comments

MarqueeCrew

Isn't the API for Twitter oAuth? You might want to check.

danielbrun2

Hi Anthony,

Could you maybe give a bit more info on what you try to achieve and what API you are trying to connect to?

I have build multiple oAuth applications in Alteryx. Depending on the need I start the flow after having received the token and onwards. Does that suit your need?

All the best,

Daniel

rahuls

OAuth varies for different APIs, so you have to develop a workflow pertaining to the API you want to use. For example, I made macros to get google sheets directly in Alteryx Workflow and Google uses concept of ClientID ClientSecret and RefreshToken to generate a shortlived access token. I made my workflow for that, some other API, like Facebook's would do it differently.

anthony

Sorry for the delay in followup. I was able to get my immediate need resolved without oauth - But I keep running into new issues with different services and I guess because of the various ways oauth is implemented is why the confusion/frustration.

I have reviewed the twitter solution and it seems to make sense but fairly complex with base64 encoding - is this required on all multi leg oauth?

Today I discovered the header X-Shopify-Access-Token was needed for shopify but it worked without it - just gave me a 401 for the first few hits when using the user/pw(token) for a private app. Once I added token to header the 401 went away.

rahuls would you be willing to share your google sheet solution or at least the steps for setting up?

I think the steps would be a big help in clearing up my confusion.

Regards,

Anthony

deepthib11

Hi can some help me capture and display the access token to the results pane in the alteryx that we receive in the XML editor of the "google sheets input tool" when being pulled on to the the alteryx designer once you log in using the user login credentials?

so basically what i want it :

I open alteryx designer pull the ""google sheets input tool" on the alteryx designer and then it asks me for user login and once logged in successfully it asks to select a spreadsheet and sheets and once done ,it creates an XML which has access token for that user .

Now i want that accesstoken to be copied and displayed in the results pane of alteryx ,please help me create the workflow for it ?

Any help is greatly appreciated please .

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335