Have you tried providing the culture code? https://zcusa.951200.xyz/en-us/bingmaps/rest-services/common-parameters-and-types/culture-parameter. The list of supported codes is available in the parameter description on the same page.
Get physical address' coordinates of concatenated address in Hebrew using excel formula
Tom Azaria
0
Reputation points
Hi all, I'm trying to add the coordinates (latitude and longitude) of an address in Excel using this formula: =FILTERXML(WEBSERVICE("https://dev.virtualearth.net/REST/v1/Locations?q="&SUBSTITUTE(K2," ","%20")&"&key=[YOUR_BING_MAPS_API_KEY]"),"//Point/Latitude") I'm writing the addresses in Hebrew (RTL), but this doesn't work with English either. Might someone shed some light on this issue I would be grateful. Thank you!
1 answer
Sort by: Most helpful
-
IoTGirl 3,126 Reputation points Microsoft Employee
2023-04-25T21:26:14.5933333+00:00