How to extract field from JSON

Ask the community
,
1

Hi all - I’m incredibly new to Velo and Java and although I’ve programmed in the past, I’ve never dealt with JSON.
I am currently testing a call to the Google Maps Distance Matrix API and have managed to get this to work (amazingly!), but I can’t work out how to extract the JSON field(s) that I may actually want.
At the moment, the code simply shows the returned JSON structure and I would like to pull out various parts/fields/elements (not sure what they’re called!).
The field I actually need is the distance amount from the original call using the 2 postcodes.
It’s all there, just can’t work out how to get that out of the JSON structure and into a variable or website element.
I’ve included my code snippets here…

This is the main function that goes to Google and carries out the call for the data.

1123×229 7.42 KB

This is the result of the call in JSON format I believe.

1056×524 25.5 KB

This is the function that returns the information after the call has been made.

I’d appreciate any help given - thanks!!

2

Maybe

let distanceInMeters = resp.rows[0].elements[0].distance.value;

(But I’m not sure that what you wanted).

3

Thank you so much - that’s actually pretty straightforward - I just couldn’t find the way of getting to the actual values of entries, but this is exactly what I need thank you so much!!