CData provides custom plugins and drivers to connect popular Integrations to your data sources in Connect AICData Connect SpreadsheetsEmbedded Cloud. For Integrations that do not have these custom plugins or drivers, you can connect to your data through the endpoints outlined below.

REST API

Connect AICData Connect SpreadsheetsEmbedded Cloud provides a full-featured REST API that allows any REST-compatible application or integration tool capable of creating HTTP requests to query data, perform batch operations, and execute stored procedures across all data sources configured in your account. This API is based on a JSON-formatted API.

OData

Connect AICData Connect SpreadsheetsEmbedded Cloud exposes an OData API which adheres to the OData v4 specification. This allows clients that can consume OData APIs to easily integrate with Connect AICData Connect SpreadsheetsEmbedded Cloud. Through the Connect AICData Connect SpreadsheetsEmbedded Cloud workspaces feature, you can customize the data you surface to Integrations and create a single endpoint for any integration that supports OData connections.

Refer to the OData overview page for more information about configuring and using the OData protocol.

OpenAPI

Connect AICData Connect SpreadsheetsEmbedded Cloud supports the OpenAPI specification version 2.0 and 3.0, allowing you to connect no-code/low-code applications that integrate with OpenAPI easily. Connect AI allows you to download an OpenAPI document from a workspace. You can then import the OpenAPI document into applications that support OpenAPI.