This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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.