Accessing matrix service with Power Query

openrouteservice
1

Hello,

I am looking for help with my POST request in Power Query. I am trying to use matrix service but with no luck so far. I am receiving the following error:

DataSource.Error: Web.Contents failed to get contents from 'https://api.openrouteservice.org/v2/matrix/driving-car/' (400): Bad Request

Here is my code:

let
    url = "https://api.openrouteservice.org/v2/matrix/driving-car/",
    headers = [#"Content-Type" = "application/json",#"Accept"= "application/json, application/geo+json, application/gpx+xml, img/png; charset=utf-8", #"Authorization"= "xxxxxxxxxxxxxxxx"],
    postData = Json.FromValue([locations="[[9.70093,48.477473],[9.207916,49.153868],[37.573242,55.801281],[115.663757,38.106467]]"]),
    response = Web.Contents(
        url,
        [
            Headers = headers,
            Content = postData
        ]
    ),
    jsonResponse = Json.Document(response)
in
    jsonResponse

I would be greatful for any hint on how to solve this problem.

Thank you!

2

Hi @bkolodziejczyk,

Probably try the approach used here:

Instead of using Json.FromValue.

Best regards