SELECT 'form' AS component; SELECT 'Location' AS name;
SET l=COALESCE(:Location, '');
SET x=sqlpage.fetch('https://tinyurl.com/3crabx94?format=json&q='||sqlpage.url_encode($l));
SELECT 'map' AS component; SELECT $x->>0->>'lat' AS latitude, $x->>0->>'lon' AS longitude;