Schau mal ob das bei dir läuft
Code:SELECT mapinfo.Latitude, mapinfo.Longitude FROM XMLTABLE('GeocodeResponse/result/geometry/location' PASSING XMLPARSE(DOCUMENT SYSTOOLS.HTTPGETCLOB( 'https://maps.googleapis.com/maps/api/geocode/xml?address=' concat systools.urlencode('Schmalholzstraße 27, 86916 Kaufering','UTF-8') concat '&components=country:DE','' )) COLUMNS Latitude VARCHAR(20) PATH 'lat', Longitude VARCHAR(20) PATH 'lng') Mapinfo;
Bookmarks