Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music

Building my own connector

Highlighted
7 - Meteor

Hello, 

 

I was wondering if anyone has a video tutorial on building an API connector in alteryx. I read in one of the comments the process was discussed during inspire 2017. A link to that video would be helpful. However, if anyone has made a video on how to build your own connector, please share that with me. I have looked at "Guide to Creating Your Own Connector" series in Alteryx Help but don't understand most of it since i am a student and new to alteryx.

 

Video tutorial of building any API connector will be great as i would assume the process will be the same for all. 

 

Thanks

Highlighted
Alteryx
Alteryx

Hi @asek 

 

Is there a particular API that you are interested in connecting to? There are some general concepts that we can cover, but there can be a decent amount of variation between API's so if you have one in mind it might be best to cater the discussion to that one in particular. 

Highlighted
7 - Meteor

@BrandonB I'm looking to build a connector with BingAds or Google Analytics. I know Google Analytics macro has already been built but it would be nice to know how it was made. Hopefully these two API's follow similar steps.

 

Thanks

Highlighted
Alteryx
Alteryx

You are in luck! If you right click on the Google Analytics tool you can actually select "Open Macro" and see how the process works behind the scenes. Google Analytics uses Oauth which is a handshake process for authentication. Then it passes the bearer token into a second download tool to pull the data. This one is a bit more complex than most API calls because it was built into an easy to use connector, but most will be as simple as a text input tool and a download tool. 

 

Google Analytics.png

Macro.png

  

Highlighted
7 - Meteor

Thank you! And just to make sure, BingAds APi will follow a similar process?

 

Thanks

Highlighted
Alteryx
Alteryx

I worked with BingAds a few years ago and it was leveraging a SOAP API which is a bit different and honestly pretty complex for your first attempt at an API call. It requires you to write out xml in the body of the API call and isn't much fun to build yourself. 

 

If you are looking for more of an out of the box approach, one of the Alteryx partners, Grazitti, has already created a connector for BingAds: https://alteryxconnectors.grazitti.com/product/bing-ads/

 

List of Partner created connectors: 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Partner-Tools/ta-p/123297

Highlighted
Alteryx
Alteryx

If you really want to tackle the challenge yourself:

 

BingAds Endpoints: https://docs.microsoft.com/en-us/advertising/guides/web-service-addresses?view=bingads-13

 

BingAds available fields: https://docs.microsoft.com/en-us/advertising/reporting-service/keywordperformancereportcolumn?view=b...

 

The way that BingAds reporting works is delivering a temporary zip file that you need to read out of as part of your process. 

Highlighted
Alteryx
Alteryx

Here is an easier example that you might like to start to get the concepts of a simple API call without any authentication. This calls a list of cat facts from a website that someone built for fun: https://cat-fact.herokuapp.com/#/

 

Workflow is attached

 

cat facts.png

Highlighted
7 - Meteor

Thank you for all your help! ill give these a try.

Highlighted
7 - Meteor

Hey BrandonB, 

 

I'm giving the BingAds connector a try. I think I completed the Authentication Portion. I was wondering if you can give me some sort of guide for the data pull portion since you have worked with it before.

 

Thank you

Labels