Skip to Content

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

Oct 25, 2017 at 07:01 PM


avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Thiago Mendes
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".


10 |10000 characters needed characters left characters exceeded