cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

thiago
Product and Topic Expert
Product and Topic Expert

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.