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
Solved! Go to Solution.
Isn't the API for Twitter oAuth? You might want to check.
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
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.
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
Given below is a link to the facebook connector of Alteryx which uses the OAuth process and documentation of how to use it.
Connector : https://gallery.alteryx.com/#!app/Facebook-Connector/56388700aa690a17f07733c1
Documentation: http://www.grazitti.com/blog/alteryx-facebook-connector/
This should get you going.
Thanks - I will take a look at the api and compare to your solution. It looks just like the way i would expect it to work - pass key/secret and get back a token to use for future calls.
But some of the ones I have come accross, they what all the header info which makes it a lot more confusing/complicated - or it is just me.
Got it, for the facebook connector, I am not passing anything in the header (in Download macro), I am passing all values in the query string itself.
You might want to try that way and see if it works.
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.
Alteryx coupled with Shopify can be incredibly useful. I have attached a basic example workflow just in case my directions were hard to follow.
John thanks. I was able to get into shopify a few years back with private app but was looking for a way to use alteryx and oath. I have not had a need for that solution recently so have not bothered to figure it out.
Your basic auth is easier than some header and curl user/pw solution i was able to figure out.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |