This integration will allow you to connect with Mews and start collecting your data.

Setting up the Mews Integration

How to connect

Setting up the Mews pipeline is really simple. You will be asked to fill in your account information on Mews, specifically your API Key. In order to create the API Key needed, you should log into your Mews account.

The API Key that you should use can be created at the “Marketplace” section on the left of your Mews account.


In the Marketplace, you should click on the category “Business Intelligence” and in this section you will find Blendo. Then click on “See More”


In the window that opens you have the chance to read more about Blendo and you should click on “Connect”.


Now Blendo is activated in your Marketplace. At “My subscriptions” list you can find Blendo and click on “Settings”.

Afterwards you should click on the Key icon on the top right, that will create the relevant Access Token.

Your Access Token is ready! As indicated in the message shown next to it, you should keep your Access Token safe. At this point you should copy the Access Token in order to use it when setting up the Mews integration on your Blendo account.

Now you should log in to your Blendo account. In order to create a new pipeline, click on the Mews icon.

On the first step of the setup, Blendo will ask you to insert the Access Token that you have created on your Mews account. You should paste the Access Token that you have just copied to authenticate your pipeline and click on “Next”.

In the second step you will be asked to fill in the number of days in the future that each sync will look for service availability and rate pricings. The default number is 180.

In the next step you will be asked if you want to use a prefix to your tables names that will be created in your database. In case you leave it blank, the tables will use the default names.

Finally, select which Mews resources you want to be synced. By default, all resources are selected. Click on each one you don’t need, to deselect it. When you are read click on the “Create” button. That’s it! Your pipeline is ready to receive data.

Your pipeline is just created. If you want to initiate the sync, you should click on the “Sync now” button on the right.

Configuration of the pipeline

When selecting the pipeline, you can see some information about it. On the top right you can see the pipeline ID, the data warehouse that the data is synced to and the schema that it is using.

Below you can find three tabs:

The first tab that you can see while selecting your pipeline is the Status tab. There you can see if the pipeline is syncing at the moment and for how long or if it has stopped. Additionally, you can manually stop the pipeline. Moreover, you can see the details of the current or previous sync, specifically the status of each of the tables that are syncing, and how many records have synced.


The second tab is the Resources tab. There you can edit the resource selection for your pipeline by selecting or deselecting any of the resources.

The third tab is the Settings tab. There you can see the the account information of your Mews pipeline and you can either pick another account or re-authenticate the pipeline. Below you can change the number of days in the future that each sync will look for service availability and rate pricings. Under that, you can edit your destination settings.

Blendo collects the data as soon as they arrive and will sync them to your data warehouse according to your pipeline’s schedule. The default behaviour is to do this once per hour, but you can configure it to run as often as once per 15 minutes or once per day, by clicking on “Reschedule” button. Additionally, next to the “Reschedule” button you can find the “Pause” button that pauses the pipeline and keeps it paused until you manually resume it.

On the bottom of the page you can see the button “Remove”. By clicking it you delete your pipeline. This action is irreversible.

Keep in mind that any changes that may be done to the pipeline will be valid starting from the following sync and on.

Expected Mews Data

Getting your Mews data is one thing. What about these data though? Let’s see:

      1. How Blendo syncs Mews data
      2. The tables with Mews data that we create in your destination data warehouse

What Mews data do I have available?

Bellow are the tables with Mews data that we create in your target data warehouse.

Expected Mews Data Model & Schema Information

For a complete view of the data model of your expected data click here.


Questions? Contact us!

in Connecting SaaS Data Sources