Power BI Connector to MEWS Connector API

[Anonymous]

Hi,

I want to connect to MEWS PMS via their open API. Documentation as per the following link # https://mews-systems.gitbook.io/connector-api/

I'm having a little trouble understanding how to connect to the API using Power BI, Unfortunately this is not my forte!

There is a 'Demo environment' as follows:

• PlatformAddress - https://demo.mews.li

• ClientToken - E0D439EE522F44368DC78E1BFB03710C-D24FB11DBE31D4621C4817E028D9E1D

• AccessToken - C66EF7B239D24632943D115EDE9CB810-EA00F8FD8294692C940F6B5A8F9453D

Credentials

• URL - https://demo.mews.li

• Email - connector-api@mews.li

• Password - connector-api

  Would mean a lot if someone would be able to give me some pointers 🙂 thanks!

[v-piga-msft]

Hi @Anonymous,

It seems that you have problems when getting data with Web API in Power BI. It is a little complex, you need use Web.Contents in Advanced Editor.

You could refer to this blog which incluing the detail steps for getting data with Twitter api.

Additional references:

https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/

https://www.powerpivotblog.com/getting-data-into-power-query-with-the-twitter-search-api-how-to-hack-pq-to-use-oauth/

Best  Regards,

Cherry

[Anonymous]

Hi Cherry,

Thanks for getting back to me.

I will review the links you have sent & come back if I have any further questions!

All the best,

Adam

[Anonymous]

Hi Cherry,

Thanks for your initial guide. I have read the articles and come up with the below.

let

url = "https://demo.mews.li/api/connector/v1/countries/getAll",

body = {"ClientToken","E0D439EE522F44368DC78E1BFB03710C-D24FB11DBE31D4621C4817E028D9E1D","AccessToken","C66EF7B239D24632943D115EDE9CB810-EA00F8FD8294692C940F6B5A8F9453D","LanguageCode","null","CultureCode","null"},

Source = Web.Page(Web.Contents(url,[Headers=[#"Content-Type"="application/json"]]))

in

Source

As mentioned before, this is for the MEWS demo account. The request can be found in the following link # https://mews-systems.gitbook.io/connector-api/operations/configuration

It is syntactically correct, however I'm still having some trouble accessing data - can anyone help me understand why?

Big thank you in advance,

Adam

[Anonymous]

Any thoughts on this at all?

Would really appreciate some guidance 🙂