topic REST API Access with POST method in Developer

REST API Access with POST method

BoleslawX — Thu, 14 Dec 2023 13:15:49 GMT

Hello Everyone,

I am looking for help to setup in PBB the REST API connection with Google Cloud Air Quality service.

Simple GET requests from PBI work just fine with other services such as Distance Matrix but in this case something went wrong.

The code was designed to execute an API request in accordance with the documentation for the "currentConditions" function, but the system returned the following error "Expression.Error Access to the resource is forbidden"

In the Google documentation for this method there is no hint on how to design URL, only cURL. I have a suspicion that when Power BI is connected to the Web.Contents function with a POST query instead of GET, it is not able to process this... Is there any way to bypass this, or any recommended solution.

Please help!

Thank you,

Re: REST API Access with POST method

lbendlin — Mon, 18 Dec 2023 00:23:39 GMT

Where's that documentation? Can you show a curl example?

Re: REST API Access with POST method

BoleslawX — Mon, 18 Dec 2023 08:01:48 GMT

Thank you for taking interest in my case.

The documentation of the service can be found here with two sample requests down below.

https://developers.google.com/maps/documentation/air-quality/current-conditions

I do not know how to approach this as Power BI returns error "Expression.Error Access to the resource is forbidden". despite the fact that I have a valid token.

Thank you in advance.

Basic CURL example

curl -X POST -d '{
  "location": {
    "latitude": 37.419734,
    "longitude": -122.0827784
  }
}' \
-H 'Content-Type: application/json' \
'https://airquality.googleapis.com/v1/currentConditions:lookup?key=YOUR_API_KEY'

and more advanced

curl -X POST -d '{
  "universalAqi": true,
  "location": {
    "latitude": 37.419734,
    "longitude": -122.0827784
  },
  "extraComputations": [
    "HEALTH_RECOMMENDATIONS",
    "DOMINANT_POLLUTANT_CONCENTRATION",
    "POLLUTANT_CONCENTRATION",
    "LOCAL_AQI",
    "POLLUTANT_ADDITIONAL_INFO"
  ],
  "languageCode": "en"
}' \
-H 'Content-Type: application/json' \
'https://airquality.googleapis.com/v1/currentConditions:lookup?key=YOUR_API_KEY'