CData

CData O Data API

The OData API from CData — 3 operation(s) for odata.

GitHub OpenAPI

Operations 6

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /{workspaceName} Get a workspace's OData service root · Get Service Root #
Ask an LLM
“What OData resources does a CData Connect AI workspace expose?”
“Where is the OData service document listing a workspace's entity sets?”
Tell an agent
Get the OData service root for workspace {workspaceName}.
List the OData resources available in workspace {workspaceName}.
GET /{workspaceName}/$metadata Get the OData $metadata document for a workspace · List Metadata #
Ask an LLM
“How do I download the OData $metadata describing a workspace's entity types?”
“Can I get the full EDM schema document for an OData workspace?”
Tell an agent
Fetch the $metadata document for workspace {workspaceName}.
Show the OData entity model metadata of workspace {workspaceName}.
GET /{workspaceName}/{resourcePath} Query records from an OData resource · Get Resource #
Ask an LLM
“How do I read rows from a table through the OData endpoint?”
“Can I apply OData filters when querying a workspace resource?”
Tell an agent
Query OData resource {resourcePath} in workspace {workspaceName}.
Read the records at {resourcePath} from workspace {workspaceName} over OData.
DELETE /{workspaceName}/{resourcePath} Delete a record through OData · Delete Resource #
Ask an LLM
“How do I remove a record from a connected source using OData?”
“Is deleting an OData entity permanent in the underlying data source?”
Tell an agent destructive · confirm first
Delete the OData entity at {resourcePath} in workspace {workspaceName}.
Remove record {resourcePath} from workspace {workspaceName} over OData.
POST /{workspaceName}/{resourcePath} Create a record through OData · Create Resource #
Ask an LLM
“How do I insert a new record into a table using OData?”
“Can I add rows to a connected data source through the OData API?”
Tell an agent
Create a new record in OData resource {resourcePath} of workspace {workspaceName}.
Insert a row into {resourcePath} in workspace {workspaceName} via OData.
PATCH /{workspaceName}/{resourcePath} Update a record through OData · Update Resource #
Ask an LLM
“How do I change fields on an existing record via OData?”
“Can I partially update an entity in my workspace instead of replacing it?”
Tell an agent
Update the existing OData entity at {resourcePath} in workspace {workspaceName}.
Patch fields on record {resourcePath} in workspace {workspaceName}.

Documentation

📖
Documentation
https://cloud.cdata.com/docs/OData.html
📖
APIReference
https://docs.cloud.cdata.com/en/API/OData-Dashboard
📖
Documentation
https://docs.cloud.cdata.com/en/API/OpenAPI

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/cdata/refs/heads/main/openapi/cdata-odata-api-openapi.yml

Other Resources

🔗
Specification
https://www.odata.org/documentation/

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/cdata:cdata-odata-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

cdata-odata-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: CData Connect AI O Data API
  version: v1
servers:
- url: https://cloud.cdata.com/api/odata
  description: Production base OData URL
security:
- Basic: []
tags:
- name: OData
paths:
  /{workspaceName}:
    get:
      tags:
      - OData
      summary: Get Service Root
      description: 'Each workspace has its own OData service URL. This endpoint returns the list of OData resources for a given workspace.

        Connect AI supports OData version 4.0 and both JSON and Atom formats.'
      parameters:
      - name: workspaceName
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
      operationId: getByWorkspaceName
      x-operation-id-source: derived
  /{workspaceName}/$metadata:
    get:
      tags:
      - OData
      summary: List Metadata
      description: This operation returns the OData metadata for a given workspace. The metadata describes the resources available in the workspace.
      parameters:
      - name: workspaceName
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
      operationId: getByWorkspaceName$metadata
      x-operation-id-source: derived
  /{workspaceName}/{resourcePath}:
    get:
      tags:
      - OData
      summary: Get Resource
      description: This URL can query the OData resource with any applicable filters.
      parameters:
      - name: workspaceName
        in: path
        required: true
        schema:
          type: string
      - name: resourcePath
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
      operationId: getByWorkspaceNameByResourcePath
      x-operation-id-source: derived
    delete:
      tags:
      - OData
      summary: Delete Resource
      parameters:
      - name: workspaceName
        in: path
        required: true
        schema:
          type: string
      - name: resourcePath
        in: path
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
      operationId: deleteByWorkspaceNameByResourcePath
      x-operation-id-source: derived
    post:
      tags:
      - OData
      summary: Create Resource
      parameters:
      - name: workspaceName
        in: path
        required: true
        schema:
          type: string
      - name: resourcePath
        in: path
        required: true
        schema:
          type: string
      requestBody:
        content:
          application/json:
            schema: {}
      responses:
        '200':
          description: OK
      operationId: postByWorkspaceNameByResourcePath
      x-operation-id-source: derived
    patch:
      tags:
      - OData
      summary: Update Resource
      parameters:
      - name: workspaceName
        in: path
        required: true
        schema:
          type: string
      - name: resourcePath
        in: path
        required: true
        schema:
          type: string
      requestBody:
        content:
          application/json:
            schema: {}
      responses:
        '200':
          description: OK
      operationId: patchByWorkspaceNameByResourcePath
      x-operation-id-source: derived
components:
  securitySchemes:
    Basic:
      type: http
      scheme: basic
      description: Basic Authentication with username and password. Use your PAT as the password. You can get your PAT from Connect AI by selecting **Settings** > **Access Tokens**.