OData Filtering in SAP Build Apps – Could This Work For You?

People always want full OData filtering (and other OData manipulations) in SAP Build Apps, and want to have complete control to send any $filter parameter they want. But the filtering is limited for some people (see this recent question).

To “solve” this, I used the REST data resource with destinations, instead of the OData integration. I admit you lose a lot of the advantages of the OData data resource – interpretation of the metadata, selecting all the entities, filtering/paging/ordering, and even converting the response. All that has to be done manually.

Still, I was able to filter without too much work – like send the parameter below – and I thought perhaps it might help someone to know how I did it.

/Customers?$filter=contains(CustomerID, 'AL')

The full explanation of what I did is published in the SAP Builders group – please also subscribe to the group!