How To Setup Alteryx Connector for Brightcove Video Data Download

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.

Connectors

API

Accepted answers

JohnRog

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 alteryx-brightcove-screen-print-02.15.20.png !

All comments

BrandonB

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:

Content-Type: application/x-www-form-urlencoded
Authorization: Basic {client_id}:{client_secret}

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.

JohnRog

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.

https://apis.support.brightcove.com/analytics/getting-started/analytics-api-overview-dimensions-fields-and-parameters.html

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703