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.
