Geolocate a city automatically

[profxeni]

Greetings to all. I have a curiosity that could be interesting for many of us: have any of you had the opportunity to geolocate a city automatically, knowing latitude and longitude, as, for example, the weather services do? Let me explain better: we have the possibility to activate this service from Glide and it returns in column lat and long. Knowing these values, we need a procedure that can find the corresponding city. Has anyone already experimented with some solutions?

[Robert_Petitto]

Yep! Been able to do this using fetch column:

Fetch Column

As promised: [Glide: Fetch Column]

[profxeni]

Thanks, @Robert_Petitto, as always very helpful. I will try this method that you brilliantly illustrated in your video.

[profxeni]

Hi @Robert_Petitto , I just tried the procedure, first as you performed it, then with Reverse, because I was interested in the procedure that retrieves the city for me, but it returns the INVALID JSON error. Do you know why?
Thanks

Okay, I answered my own question. I used the test found in glide and from this example link - https://nominatim.geocoding.ai/reverse.php?lat=41.884122&lon=13.095391&zoom=10&format=jsonv2 -
I found the city with: .address.village!
Thanks for everything