Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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
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
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
User | Count |
---|---|
134 | |
74 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |