Google maps API and JSON format

[asafweis]

Hi all,

I'm building a flow that sends an API request via HTTP GET to google's maps API in order to get a trip duration from one destination to another. 

Everything works so far, however when i get the response back  from google i get the JSON in a schema that doesn't seem to let me select the particular property that I'm after.

What I'm trying to isolate is the duration_in_traffic element from the JSON. Can anyone help me out with this? I've tried PARSE JSON without success.

Here is the output from the HTTP request:

{

  "destination_addresses": [

    "10 Walker St, Braeside VIC 3195, Australia"

  ],

  "origin_addresses": [

    "64 Cochranes Rd, Moorabbin VIC 3189, Australia"

  ],

  "rows": [

    {

      "elements": [

        {

          "distance": {

            "text": "10.4 km",

            "value": 10394

          },

          "duration": {

            "text": "14 mins",

            "value": 850

          },

          "duration_in_traffic": {

            "text": "14 mins",

            "value": 865

          },

          "status": "OK"

        }

      ]

    }

  ],

  "status": "OK"

}

How can i get the value of 14 mins?

Thanks.

[efialttes · Accepted solution]

Hi!

I would try withthe following WDL expression

first(first(body('HTTP')?['rows'])?['elements'])?['duration']?['text']

Hope this helps

[asafweis]

Thank you!

Worked perfectly