I'm trying to access the Reputation.com API in Power BI Desktop using Get Data>Web>Web API using the API endpoint and API key that they have provided me with, but I keep getting the error message "invalid credentials."
I was able to call the API successfully from Command Prompt using the following cURL command:
curl -X GET -H "X-API-KEY: {this is my API key} " https://api.reputation.com/2.0/business/location/61/summary
The issue seems to either be that Power BI's Web API connector doesn't have the proper functionality for me to accomplish this, or that the API call is being made from a Power BI IP address that has not been whitelisted by Reputation.com (I had to send Reputation.com my IP address to be able to access the API).
If anyone knows how I could go about calling this API from within Power BI Desktop or if there is another IP address that I need to whitelist, it would be much appreciated. Thanks!
