OData Connector

OData Connector

Your journey to data connectivity — from start to finish.

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

All inside your favorite applications.

SSIS integration
Download SSIS PowerPack
SQL Server & ODBC/JDBC connectivity
Download ODBC PowerPack
Find out more
Documentation

Pick an application to access your OData data in

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.

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.

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.

Need another action for OData?

Ping us via chat: