Pulling 3rd party web data during a web-based script

[fishtech]

Hi,

Is there any way to pull in 3rd party data from the web during a FileMaker script triggered from a browser (via FX.php or even IWP)?

I need to pull in some data on-the-fly from Google Maps, depending on a user's address.

Unfortunately it seems:

• 
  
  A. I can't use Web Viewers (possibly because they are only rendered client-side and a browser client cannot process the results)
  
  B. I can't use cURL since the AppleScript script step is not web-compatible.
  

Am I wrong on either of these points? Is there any other/better way to pull in data from a 3rd party website during a script triggered from a browser?

Thanks for any advice.

ft.

DESCRIPTION OF PROCESS

I have a database of 3500 stores.

Store locations were geocoded using Google maps. The long/lat coordinates of each store are kept in indexed fields.

I have a scripted proximity search which works great in FileMaker as follows:

1. A user enters their own address details and a search radius (distance in miles) and hits 'search' button.

2. A webviewer queries Google Maps and returns the lat/long for the user's address.

3. Distances from user-to-stores are calculated for the stores.

4. A search is done on the distance field for stores within the distance entered in step 1.

5. The resulting stores are returned to the user.

I need to get this to work via the web.