Filtrado de SubObjetos en Services Layer

SAP Business One
1

Hola Comunidad!

tenemos una consulta a ver si es posible usando services layer con sap 9.3

tenemos esta respuesta que trae nuestro endpoint :

https://100.1.1.1:50000/b1s/v1/BusinessPartners?$filter=CardType eq ‘cCustomer’

{
    "odata.metadata": "https://100.1.1.1:50000/b1s/v1/$metadata#BusinessPartners",
    "value": [
        {
            "CardCode": "VM8789E300",
            "CardName": "Loren Ipsum",
            "CardType": "cCustomer",
            "GroupCode": 108,
            "Address": "New York",
            "ZipCode": "5689",
            "CompanyRegistrationNumber": null,
            "VerificationNumber": null,
             "BPAddresses": [
                {
                    "AddressName": "Fiscal 1",
                    "Street": "Japon",
                    "Block": "Zona Urbana Tokio",
                    "ZipCode": "322710",
                    "City": "Tokio",
                    "County": "Japan",
                    "Country": "JP",
                    "State": "BC",
                    "FederalTaxID": null,
                    "TaxCode": null,
                    "BuildingFloorRoom": null,
                    "AddressType": "bo_BillTo",
                    "AddressName2": null,
                    "AddressName3": null,
                    "TypeOfAddress": null,
                    "StreetNo": null,
                },
            ],
            "ContactEmployees": [
                {
                    "CardCode": "VM8789E300",
                    "Name": "Tsunoda",
                    "Position": "Comprador",
                    "Address": "Tokio2562",
                    "Phone1": "+1-5661088076",

hicimos este enfoque:
https://100.1.1.1:50000/b1s/v1/BusinessPartners?$filter=CardType eq 'cCustomer' and U_GB_OK_Facturacion eq 'N' & $expand=ContactEmployees($filter=Name ne null)

ya que queremos entrar a ContactEmployees a hacer el filtrado de los Name que no sean NULL ,
pero nos da el siguente error:

{
    "error": {
        "code": -1000,
        "message": {
            "lang": "en-us",
            "value": "Property 'Query' of 'BusinessPartner' is invalid"
        }
    }
}

alguien ha trabajado con los filtros anidados o con los expand via services layer?

saludos comunidad ! , esperamos su ayuda y agradecidos de antemano !

                "Phone2": null,
                "MobilePhone": null,
                "Fax": null,
2

Creo que nos respondemos nosotros mismos:

usamos esto y funciono ! :

https://100.1.1.1:50000//b1s/v1/QueryService_PostQuery

{

"QueryPath": "$crossjoin(BusinessPartners,BusinessPartners/ContactEmployees)",

"QueryOption": "$expand=BusinessPartners($select=CardCode,CardName,CardType),BusinessPartners/ContactEmployees($select=CardCode,Name,Position,Phone1)&$filter=BusinessPartners/CardCode eq BusinessPartners/ContactEmployees/CardCode and BusinessPartners/ContactEmployees/Name ne '' and BusinessPartners/ Custom_Facturacion eq 'N'"

}