Forum Discussion

donnellyk's avatar
donnellyk
Frequent Visitor
8 months ago
Solved

Using Google Matrix API to calculate distance between locations in my dataset

I have a dataset returning 77,000 records, each with both Buyer & Seller locations. The Seller location is always in the UK I'm trying to use the Google Matrix API to calculate distance between buy...
Need Help
  • donnellyk's avatar
    donnellyk
    8 months ago

    Thanks for your feedback, it helped point me in the right direction.
    Basically, I ammended my SQL query so that if it was a non UK address, I returned the address of the UK port of entry & then the google matrix api was able to calculate all the distances for me

kushanNa's avatar
kushanNa
Super User
8 months ago

Hi donnellyk 

 

From what I understand, your function works fine with UK buyers but has an issue with non-UK buyers. If that is the case, check it in an API testing tool like Postman and see what output you get when you input a UK buyer’s location and a non-UK buyer’s location. If the API returns null in that case for No UK buyer's, then this is likely a Google Maps-side issue.