Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |