OData Connector

Read and write OData API data effortlessly. Query, integrate, and manage entities and feeds — almost no coding required.

Establish a two-way connection to query and load OData data using SSIS, SQL Server, ETL platforms, reporting tools, any ODBC/JDBC-compatible application, or your preferred programming language.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate OData with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by OData Connector

OData Connector supports following actions for REST API integration:

Generic Read Data (JSON API)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • TableName
  • Format
  • PageSize (Keep blank for default)
  • Search Criteria

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Generic Read Data (XML API)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • TableName
  • Format
  • PageSize (Keep blank for default)
  • Search Criteria

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

List Columns

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • TableName

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • EntityName
  • Name
  • Type
  • MaxLength
  • FixedLength
  • Unicode
  • Precision
  • Scale
  • KeyName
  • Nullable
  • StoreGeneratedPattern
  • EdmxVersion
  • SchemaNamespace
  • SchemaXmlns
  • DataServiceVersion
  • MaxDataServiceVersion

Visit documentation for more information.

List Tables

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • EntityName
  • KeyPropertyName
  • Property
  • NavigationPropertyName
  • NavigationRelationship
  • NavigationToRole
  • NavigationFromRole
  • Navigation
  • KeyProperty
  • DataServiceVersion
  • MaxDataServiceVersion
  • Version

Visit documentation for more information.

List Tables (JSON API)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Format
  • PageSize (Keep blank for default)
  • Search Criteria

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

List Tables (XML API)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Format
  • PageSize (Keep blank for default)
  • Search Criteria

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Read [Dynamic Action]

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Format
  • PageSize (Keep blank for default)
  • Search Criteria

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic REST API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • HTTP - Url or File Path
  • HTTP - Request Body
  • HTTP - Is MultiPart Body (Pass File data/Mixed Key/value)
  • HTTP - Headers (e.g. hdr1:aaa || hdr2:bbb)
  • Parser - Filter (e.g. $.rows[*] )
  • Download - Enable reading binary data
  • Download - File overwrite mode
  • Download - Save file path
  • Download - Enable raw output mode as single row
  • Download - Raw output data RowTemplate
  • Download - Request Timeout (Milliseconds)
  • Format
  • PageSize (Keep blank for default)
  • Search Criteria

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic REST API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers
  • Format
  • PageSize (Keep blank for default)
  • Search Criteria

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.