I have a MSSQL table called Address
that contains the following fields populated with address data.
addressid, address1, address2, address3, city, state, zip, country.
I have created a new table called AddressGeoCode
thats contains the following
geocodeid, geoaddressid, lng, lat, isgeocoded
I then have a view zAddressToGeoode
SELECT *
FROM dbo.Address
WHERE (addressid NOT IN (SELECT geoaddressid FROM dbo.AddressGeoCode WHERE (isgeocoded IS NULL)))
This lists all addresses that have not been defined as geocoded
I have a Server Action that connects to the database and then queries the zAddressToGeoode
view.
I have created a ServerConnect that returns a limited set of records.
Could someone help with the Wappler workflow so that I can capture the returned lng/lat, insert the values in the AddressGeoCode
table along with the addressid and a success flag from a service such as
http://photon.komoot.de/api/?q={{myaddressdata}}
Many thanks in advance.
Mim