OData V2.0

OData enables the creation of HTTP-based data services, which allow resources identified using Uniform Resource Identifiers (URIs) and defined in an abstract data model, to be published and edited by Web clients using simple HTTP messages.

The OData V2.0 connector works with OData V1 and V2. It connects to on-premise environments eg.SharePoint, but does not support OAuth authentication.

A sample OData Service that you can use can be found by using the following URL: https://services.odata.org/V2/OData/OData.svc

This has multiple collections that you can connect to such as Products and Suppliers.

Download a ODataV2 Demo Project

Connection

To connect enter a OData service URL and then choose a collection to connect to.

Connection Properties

Service URL

The OData service URL, this could be the sample OData service https://services.odata.org/V2/OData/OData.svc or specific to the connection you are using.

Entity

The entity in the service to run, this can also be known as OData collections. Choose the entity you wish to connect to from the drop down menu.

HttpHeaders

Http headers to add to the request.

ServerVersion

Version of OData that the server supports. Either version 1 or version 2.

ServiceCommand

Additional query command sent to the OData service.

Timeout

OData service HTTP request timeout.

Authentication

Authentication Mode

The authentication mode to connect to the OData Feed.

Credentials

The network credentials to use to connect to the OData Service.