• Resources
    • Documentation
    • Courses
    • Knowledge Base
    • FAQ
    • Forum
    • Changelog
    • Webinars and Videos
    • Blog
    • Swag Shop
  • Marketplace
  • Login
  • Resources
    • Documentation
    • Courses
    • Knowledge Base
    • FAQ
    • Forum
    • Changelog
    • Webinars and Videos
    • Blog
    • Swag Shop
  • Marketplace
  • Login
home/Knowledge Base/How to's/How to use Query Options in ODataV2 Connector

How to use Query Options in ODataV2 Connector

132 views 0

Written by Christian Kleinschroth
June 4, 2021

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

Was this article helpful?

Yes  No
Related Articles
  • Authentication trough another window
  • Converting Text to Speech with the Google TTS Connector
  • PDF Templates: make the Header/Footer content dynamic
  • REST: Use a CSRF Token and a Cookie to authorize Requests
  • Use the Adobe PDF Embed API in your Simplifier Application
  • Simplifer setup with recommended environment using docker-compose
Leave A Comment Cancel reply

You must be logged in to post a comment.

Latest Articles
  • Authentication trough another window
  • Converting Text to Speech with the Google TTS Connector
  • PDF Templates: make the Header/Footer content dynamic
  • Contact | Imprint | Privacy | © 2022 Simplifier AG. All Rights Reserved.

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.