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
Former Member

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