Reviews.co.uk web api

[markhay]

Hi guys

Need some help with pulling data from reviews.co.uk. They have documentation available but doing it how I expect I get an error stating I need to stipulate an API key name. I've been using the web data source and adding the url specified in the basic form then adding the API key on the autorisation prompt.

Can someone shed anylight on what I'm missing?

Info from provider:

URL: https://api.reviews.co.uk

Store ID: company-name-com

API Key: 12345

Your merchant reviews can be retrieved by sending a HTTP GET Request to the following API Url.

URL: https://api.reviews.co.uk/merchant/reviews?store=company-name-com

[v-yulgu-msft]

Hi @markhay,

Here are two similar links for your reference:

A web API key can only be specified when a web API key name is provided.

Working with Web Services in Power Query

Best regards,

Yuliana Gu

[markhay · Accepted solution]

Thanks Yuliana

I'd spotted these posts before but they didnt make that much sense to me to be honest as I'm not really a coder and it didnt seem that straight forward - also one ends with someone saying surely it's a bug..

I've worked around the issue for now by sending all the info in the web string (https://api.reviews.co.uk/export/merchant.csv?store=COMPANY NAME&apikey=API KEY CODE&min_rating=1&max_rating=5&min_date=2016-10-18&max_date=2020-02-20&include_additional_ratings=1).

Not perfect but considerably easier and quicker to figure out 🙂

Thanks

mark