Thank you all for your posts they have been extremely helpful. I am very new to Alteryx and so some of the terminology can be a little confusing.
Here is what I am trying to do:
I am trying to setup a connector to Brightcove.
Brightcove It uses OAuth2 and utilizes a basic authorization process. However, I am a little confused as to what they are asking.
Are they saying that I should first use the "text input" tool connect and get authorization? Then set up a second "Text Input" tool one in the workflow to request the data?
Thanks for your help.
Solved! Go to Solution.
The idea is to first create a Client ID and Client Secret using the steps found here: https://apis.support.brightcove.com/general/managing-api-authentication-credentials.html
This is like a "login" for your process.
Then when it refers to "Basic" authentication, this has to do with how it sends the information to the API. This outlines the actual process for using the Client ID and Secret to get the access token: https://apis.support.brightcove.com/oauth/guides/getting-access-tokens.html
Once you have your credentials, you obtain an access token by making a POST request to:
https://oauth.brightcove.com/v4/access_token
You must pass the following headers with this call:
What this means is that you need to put your Client ID and Client Secret into a string separated by a colon.
Like ClientID:ClientSecret
Then you need to pass this field through a Base64 tool to base64 encode the string. Finally, you want to use another formula tool to create a column called Authorization that has the word Basic then this base64 encoded string so it should be like
Authorization
Basic asdlfh12414hlasd
or something similar. Then you pass this information into the download tool with the URL specified above and it will return your access token.
First of all... Thanks for your help! I now have an access token and a request URL. Unfortunately I am still getting and unauthorized message in the headers.
I suspect it is because I do not have the token and the request URL in the proper syntax for Alteryx and I need just a little more help. According to Brightcove, this is the final step see image. However, I am not sure what tool to use or how to duplicate the syntax.
Awesome, it looks like you are close! So to pass the access token into the next step you have two options.
1.) Hard code it into the Headers tab
* This only works if your Access Token doesn't expire
2.) Dynamically read it in from upstream
* If your workflow is successfully pulling an access token, it is likely coming in your Download Data column. If this is coming in as JSON you might want to use a JSON parse tool to extract it. Then you want to use a formula tool to make a new column called Authorization that has the word Bearer then a space then the access token directly afterwards. You would then pass this into the download tool as headers by checking the box. You will also want to use this formula tool to create the next URL where you will be querying data from.
Let me know if this helps! Most likely it just has to do with how you are currently trying to create your Authorization column format
Hey Good News! We were able to work with Mike Buhrfiend of Alteryx to figure out what the issue was. It turned out to just be an issue with quotes (" ") around the access key. Mike helped us write a formula that removed the quotes and all was well.
Thanks to everyone who provided assistance and advice. Best regards!