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}}
Pretty sure i have a google API based solution on my development machine . Hopefully it’s new motherboard will arrive today and i can get it back online and post it if that’s suitable.
Just realised you were referring to Photon in your post, (just skim read on phone)
I played with photon a while back but found it to returned too many wrong/ failed responses to be usable for my purposes and was forced to go back to google.
Guess you will need to test with photon to see how effective it is, principal is identical so an easy switch.