Prerequisites
You need an ODataV2 data service (e.g. Northwind)
You need an ODataV2 data service (e.g. Northwind)
Create an ODataV2 Connector (Simplifier Documentation):
Start the Connector Wizard to create a ReadAll call:
To use ODataV2 Query Options create corresponding Input Parameters using the notation param/$<queryOption>:
Using param/$expand you can specify which of the related resources (e.g., Supplier) should be included in the result:
Using param/$filter you can specify a filter condition for requesting the data (e.g. ProductionName eq ‘Chai’):
Using param/$orderby you can specify an order criteria for the requested data (e.g. UnitsInStock desc):
Using param/$select you can specify which properties of the resource should be requested (e.g. ProductName):
Using param/$skip you can specify the number of entries which should be skipped (e.g., with skip = 3 the first three entries are omitted, and the result set starts with the fourth element, i.e., ID=4):
Using param/$top you can specify the number of entries which should be output – starting with the first entry (e.g., with top = 2 only the first two entries are retrieved):
Of course, it is possible to combine query options (e.g., getting the two Products of category 1, most in stock, and expanded with Supplier information):
