How to retrieve accounts list by radial distance with API?

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

How to retrieve accounts list by radial distance with API?

Hi everyone, I’m looking for a way to retrive the account list sorted and filtered by gps coordinates. For example I want to query the GetModule API with my current latitude and longitude coordinates and get the Accounts with coordinates in my neighborhood (where the neighborhood could be 1 or 100 miles).

The standard API seems doesn’t support a query like that, what can I do to join my goal?

Thanks in advance.

2

Hi,
you can extend the api with own methods. Since the longitude/latidude is stored in the tables, you can do the calculations yourself.

https://www.movable-type.co.uk/scripts/latlong-db.html
https://coderwall.com/p/otkscg/geographic-searches-within-a-certain-distance
https://www.geodatasource.com/developers/php

1 Like