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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Employee
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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.