Dynamics Community Forum Thread Details

$Filter in odata

Hi,

can i use filter with expand?

So calling odata with GET for this URL works:
{{resource}}/data/XX?cross-company=true&$filter=CustAccount eq 'ABC' and dataAreaId eq 'USMF' and Id eq '123'&$select=Id,Status&$expand=YY($select=LineId, ZDate)

Now if i want to filter on LineId, i get this error:

No HTTP resource was found that matches the request

 

{{resource}}/data/XX?cross-company=true&$filter=CustAccount eq 'ABC' and dataAreaId eq 'USMF' and Id eq '123'&$select=Id,Status&$expand=YY($select=LineId, ZDate&$filter=LineId eq 'www')

I also tried this but got this error
{{resource}}/data/XX?cross-company=true&$filter=CustAccount eq 'ABC' and dataAreaId eq 'USMF' and Id eq '123'&$select=Id,Status&$expand=YY($select=LineId, ZDate;$filter=LineId eq 'www')

{
    "error": {
        "code": "",
        "message": "An error has occurred.",
        "innererror": {
            "message": "Nested query options in $expand are not supported.",
            "type": "System.Net.WebException",
            "stacktrace": "   at Microsoft.Dynamics.Platform.Integration.Services.OData.Query.QueryableExtensions.ValidateNestedQueryOptionsforExpand(SelectExpandClause selectExpandClause)\r\n   at Microsoft.Dynamics.Platform.Integration.Services.OData.Query.QueryableExtensions.ApplyQueryOptions(IQueryable queryable, HttpRequestMessage request, ODataQueryOptions queryOptions, Boolean isCollection)\r\n   at Microsoft.Dynamics.Platform.Integration.Services.OData.AxODataController.Get()"
        }
    }
}

Categories:

Dynamics 365 Finance

Hi @..

The error message is coming from a standard DLL that exists in the application (Microsoft.Dynamics.Platform.Integration.Services.OData)

You can read the error message saying: "Nested query options in $expand are not supported."

You can make two separate calls. One call to get the record from the XX entity.A second call to get the related records by directly querying the YY entity. This approach allows you to apply as many filters as needed on the YY entity.

Another option is to create a custom entity for YY (with pre-set filters defined in the entity's query), say YY_Custom, and then call it along with XX using $expand.

Another option is to build a single custom entity that merges data from XX, YY, and any other necessary sources or tables.

Quick Links