How can I use geo.distance filter in my query?

(0) Share

Report

Posted on by _Lars_

225

Hello!

I want to poll every object of the entity pss_assets from Dynamics, the entity holds the fields pss_latitude and longitude.

I've tried the following query, but I get "400 Bad Request" with very little else information;

req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/pss_assetses?$filter=geo.distance(geography'POINT(56.158445 10.218658)', geography'POINT(pss_latitude pss_longitude)') le 10", true);

Does anyone else had success with this filter? What I want is to get all objects within 10 kilometers (there is still that 5000 object limit).

*This post is locked for comments

All responses (2)

Answers (0)

_Lars_ 225 on at

Like (0)

Report

RE: How can I use geo.distance filter in my query?

Hello Guillaume,

I cant see how I can do it with that tool. It has simple property comparison.

I should be able to do this with the $filter=geo.intersects from docs.microsoft.com/.../odata-expression-syntax-for-azure-search but as I was saying I'm getting 400.
Suggested answer

Community Member on at

Like (0)

Report

RE: How can I use geo.distance filter in my query?

Hello,

did you try to check your query with the helpfull CRMRest Builder?(https://github.com/jlattimer/CRMRESTBuilder)

simply import the managed solution, open it and create your query.

Best