Prerequisites

You need an ODataV2 data service (e.g. Northwind)

Step 1 – Create ODataV2 Connector

Create an ODataV2 Connector (Simplifier Documentation):

Step 2 – Use Connector Wizard to create a ReadAll call

Start the Connector Wizard to create a ReadAll call:

Step 3 – Add Query Options as Input Parameters

To use ODataV2 Query Options create corresponding Input Parameters using the notation param/$<queryOption>:

Step 3.1 – Expand

Using param/$expand you can specify which of the related resources (e.g., Supplier) should be included in the result:

Step 3.2 – Filter

Using param/$filter you can specify a filter condition for requesting the data (e.g. ProductionName eq ‘Chai’):

Step 3.3 – OrderBy

Using param/$orderby you can specify an order criteria for the requested data (e.g. UnitsInStock desc):

Step 3.4 – Select

Using param/$select you can specify which properties of the resource should be requested (e.g. ProductName):

When specifying a subset of properties, the data type of the output parameter has to be changed accordingly.

Step 3.5 – Skip

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):

Step 3.6 – Top

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):

Step 3.7 – Combining Query Options

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):