Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

CData Query API

Execute SQL queries and batch operations

CData Query API is one of 11 APIs that CData publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Query. The published artifact set on APIs.io includes an OpenAPI specification.

This API exposes 2 operations across 2 paths, and defines 1 schema. It is described by OpenAPI 3.1.0, at version 1.0.0.

Requests are made against a single base URL, https://cloud.cdata.com/api.

2 operations 2 paths 1 schemas 2 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.1.0
API Version
1.0.0
Server
https://cloud.cdata.com/api
Authentication
HTTP Basic, HTTP Bearer
Resource Areas
1

Authentication & Security 2

CData Query API declares 2 security schemes for authenticating requests. It accepts HTTP basic authentication (basicAuth). It accepts HTTP bearer tokens (JWT) (bearerAuth). By default, every request must be authenticated.

  • basicAuth — Basic auth using CData Connect Cloud username and PAT/password
  • bearerAuth — JWT bearer for CData Connect AI Embed

Paths & Operations 2

Across 2 paths, the API surfaces 2 operations — 2 POST. Each is listed below with its method, path, parameters, and response codes.

Query 2

Execute SQL queries and batch operations

POST
/query
Execute a SQL query
executeQuery 3 params body → 200400401
POST
/batch
Execute a batch of SQL statements
executeBatch body → 200

Schemas 1

The contract defines 1 schema that model the data the API accepts and returns. The most detailed is QueryResult (3 properties). Each schema is shown below with its type and property counts.

QueryResult
object
3 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

cdata-query-api-openapi.yml Raw ↑

Other APIs CData publishes across the network.

CData SQL API
CData Metadata API
CData Log API
CData Connection API
CData Job API
CData Account API
CData Audit API
CData OData API
CData Metadata API
CData Procedures API