Using CustomerID instead of their address to look up location

Stefano_Sena
22 hrs ago
3replies

Hello,

Part of a dashboard we're making will use google maps imbedded API and dynamic URL to show the customer's location. I'm wondering how we can use a CustomerID to filter the map, instead of their address. I thought there was something with hidden slicers in the lessons, but I can't seem to find it.

I'm using randomly generated addresses for this proof of concept.

Present
API

- VP Product Management
- Ian_Macdonald
- 17 hrs ago
- Reported - view
Hi

You can use anything you like to filter the data before you send it onto Google Maps. I'm not quite sure what it is you are asking.

Can you please clarify?

Thanks,

Ian
- Stefano_Sena
  
  17 hrs ago
  
  Reported - view
  Hi ,
  
  Instead of using the address to filter through the locations, I'd like to use the address' corresponding customer ID. The below example shows the map when I try to filter using the customer ID instead of the address (example from original post). EDIT: this is showing the incorrect address.
  
  Below is the test data I'm using if this helps:
  
  Dynamic URL below as well:
- VP Product Management
- Ian_Macdonald
- 14 hrs ago
- Reported - view
Hi

OK, but Google maps knows nothing about your Customer ID. All it knows is how to plot a lat/long on the map, geocoded from the address you are passing to it.

So you can filter on Customer ID in Pyramid, because your model knows about it, then you have to pass to Google that ID's address so it can geocode it and put a pin on the map.

Ian