OData Source

Overview

Data flow source, loading information from Open Data Protocol (OData:http://www.odata.org/) source. 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 crime data for Chicago specify:

• Collection – https://api.datamarket.azure.com/Data.ashx/data.gov/Crimes/CityCrime
• Query – $filter=City eq ‘Chicago’

Requirements

Depends on CozyRoc Script Component Plus component for implementing parameters user interface.