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
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
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
Many thanks in advance.