Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
markhay
Frequent Visitor

Reviews.co.uk web api

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

1 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

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.