Forum Discussion
Power BI Connector to MEWS Connector API
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!
PlatformAddress - https://demo.mews.li
ClientToken - E0D439EE522F44368DC78E1BFB03710C-D24FB11DBE31D4621C4817E028D9E1D
AccessToken - C66EF7B239D24632943D115EDE9CB810-EA00F8FD8294692C940F6B5A8F9453D
Credentials
URL - https://demo.mews.li
Email - [email protected]
Password - connector-api
Would mean a lot if someone would be able to give me some pointers :) thanks!
4 Replies
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/
Best Regards,
Cherry
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
SourceAs 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
