Skip to Content
avatar image
Former Member

How can I filter orders by shipping address on SAP Business One Service Layer?

Hi experts!
We are trying to use the SAP B1 Service Layer filter option to filter the orders based on their shipping address. Based on the ODATA documentation I can filter in complex types, like this:

https://<SERVER_IP>:50000/b1s/v1/Orders?$filter=AddressExtension/ShipToCity eq 'Curitiba'

However, the SAP Documentation does not have any information about this.

Is it possible to filter complex objects?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 09, 2017 at 08:59 PM

    Hi Maykol,

    Please check the topic 3.9 of the Service Layer Documentation where you can find that "Retrieving the properties of a complex type is not supported. For example, the following request is not possible: GET /Orders(1)/TaxExtension/TaxId0".

    Regards,
    Thiago.

    Add comment
    10|10000 characters needed characters exceeded