Script OData Source

Overview

Data flow source for consuming data from Open Data Protocol (OData) source.

Setup

The script has the following parameters:

• Connection - selects HTTP connection.
• BatchSize - specifies number of rows to be retrieved as batch.
• Collection - selects OData collection.
• IsQueryVariable - indicates whether the query statement is stored in a variable.
  • Query - specifies query statement.
  • QueryVariable - selects variable containing query statement.

Example

To get sample data:

• Collection - http://services.odata.org/V3/Northwind/Northwind.svc/Orders
• Query - $filter=CustomerID eq 'VINET'