Connecting to Yelp

As an end user you would like to use our REST Source to connect to Yelp and pull data pertaining to local businesses.

The Solution:

If you follow the below steps you will be able to use our REST Source to pull data from Yelp’s website.

The first step is to navigate to Yelp’s Developer site and create an application. Click here to go to the Yelp Developer home page.

Next, we need to create an account by clicking the Sign-Up button.

Once you are logged in scroll to the bottom of the page and click Developer under the Discover category to navigate back to Yelp’s Developer page.

Once you are back at the Developers site select “Yelp Fusion”. Then scroll down and select Get Started. You should now be presented with a Create New App page.

Fill in the boxes with your information. Use the above screenshot as a reference. Please note, you must provide a description, I used “REST Source Test”.

Once your information is correctly input and you click Create App, you should see a page with your API Key, Client Secret, and Client ID. Save that info, we will need it later. **Please note that while Yelp is going away from using the Client Secret, at the time of writing it is still needed to Authenticate.

Now that we have created our app and gotten our credentials we can open Visual Studio and set up our REST Connection.

Once you have opened Visual Studio, navigate to the Data Flow and bring in a REST Source. Open the REST Source and select new OAuth2 Connection Manager.

For this connection we are going to use a Configuration File, which can be downloaded here.

Once you have the downloaded the vonfiguration file, click the ellipses at the end of the Configuration File block within the OAuth2 Connection Manager and you should see a File Explorer window pop up.

Navigate to the configuration file you previously downloaded and select it. You should have another pop up prompting you to enter you Client ID, API Key, and Client Secret. Enter the information and click “Get Access Token”.

You should now have your Access Token and are ready to make your first Yelp call!

There is one endpoint pre-configured within this Configuration File, if you navigate to Endpoints within the REST Source component, you can select it and click “Choose Configuration” then enter the requested information.

Go to the Test API tab and select Preview Data, you should see the data you requested returned in JSON.