Hello group,
i want to filter a specific value from a JSON-filled column and write it
to a new one but I cant't figure out how to do that. I would really
encourage any help from this list as this problem already took two
evenings from me without any progress.
I'm adding a coloum based on another one fetching geodata via
Mapquest. No problem here. Results look like the attached long.json (see
[1]).
I'd like to filter that JSON's fields "lat" and "lng" into new
columns. But any filtering I tried only works at the highest level of
the JSON. For example value.parseJson()["lng"] returns null while
value.parseJson()["results"] returns the subset you'd expect (attached
as subset.json).
Filtering again on that subset (eg by value.parseJson()["latLng"])
returns null and I'm out of ideas.
How do I get those values via GREL?
Best,
Sebastian
[1]:
<
https://developer.mapquest.com/documentation/geocoding-api/address/get/>