How to calculate the distance between two adress directly in server action

[kryo91]

Hello, I have a list of technicians and a list of customers, I would like to display the nearest technician. for this I wanted to know if in Server Connect I can use the Google API to calculate this distance and store it in my database?

thanks in advance

[Hyperbytes]

Do you want the distance by road or the actual distance in a straight line

The former needs the google API, the latter can be calculated by a formula not incurring any google charges

[kryo91]

by the way, I have to call the google api but not directly from the google map module of appconnect because I don’t have it in serverconnect

[Hyperbytes]

If you know the coordinates of the start and end points you can calculate the distance between with an equation in a custom query but it returns the geographical distance, not the road travel distance

[kryo91]

I found the code for the API, the result is in the response, but how can I retrieve the response in order to store it in my database

https://maps.googleapis.com/maps/api/distancematrix/json?destinations=9%20rue%20la%20parra%2012450%20luc%20la%20primaube&origins=738%20route%20des%20devezes%2012850%20onet%20le%20chateau%20%20&units=imperial%20%20&key=**********************

when inserting a new technician I could thus record the distance with each customer

[franse]

Hey Morgan

@kryo91

how can I retrieve the response in order to store it in my database

You can use the Api action, check this topic from Max

Guide to Getting the Distance and the Duration from Google Distance Matrix

Hi, today I want to share with this awesome community how I did to get the distance between two coordinates that can be from a map, from a database or written by hand. First of all remember that if you are going to use it for a web app with a lot of traffic, Google is going to charge you a fee that can be little or a lot depending on the traffic, you can check the prices here: https://developers.google.com/ maps / billing / gmp-billing # dynamic-maps Ok in just 3 steps you will have this work…

Please note that too many request can means a lot of charges due to the cost of the maps api usage, check the google docs and be sure to use it wisely.

Hi Brian!

@Hyperbytes

you can calculate the distance between with an equation in a custom query

I remember trying something that you’ve mention in a post from years ago, but no luck, still working? Never got it running

Delivery zones/radius

Yes, i have a site online which uses that method serhat, works well: sqrt(power(69.1*(lat - “.$baselat.”),2)+power(69.1*(lng - “.$baselng.”)*cos(lat/57.3),2)) where $baselat and $baselng are centre and lat,lng are table fields (returns miles, not Km as I am in UK) Implemented before custom queries I may add so it is part of a custom piece of code, not tried it with the new Wappler custom query

I gues this is the best approach as you can avoid the cost of the api

[Hyperbytes]

No twason why it shouldn’t work, it’s not reliant on other factors,it’s just an equation

[kryo91]

Hi, My soluce in serverconnect :

I first encode the addresses in order to retrieve the latitude and longitude of my two addresses which I will store in my database. Afterwards I call my Google Matrix API to determine the duration of the journey and the number of kilometers. The hardest part was filtering the response, so I’ll let you see how I did it, it will be useful to others.