The OData endpoint offers exposure to the datasources only via the Azure/MS SQL connectors.

OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. OData also provides guidance for tracking changes, defining functions/actions for reusable procedures, and sending asynchronous/batch requests.

Access to data via the OData connector is done securely via the https protocol and requires the below setup to be provided. The location of the data source must be specified(blurred part)



The tutorial below covers accessing the data by connecting to Conduit via OData Feed in Excel.

  1. In Conduit open Data Endpoints page and copy OData endpoint URL

  2. Open Excel document and navigate to Data > Get Data > From Other Sources > From OData Feed

3. In OData feed window paste copied URL and replace placeholder portion with the actual connector name

4. Click OK

5. Select Basic authentication method and enter your credentials for accessing data in Conduit


6. Click Connect