CData

CData OData API

CData Connect Cloud exposes an OData v4 compatible API that allows any OData client to browse metadata and query data from any configured source, including Excel, Power BI, and other BI tools.

Documentation GitHub OpenAPI

Operations 6

GET /{workspaceName} Get Service Root

GET /{workspaceName}/$metadata List Metadata

GET /{workspaceName}/{resourcePath} Get Resource

DELETE /{workspaceName}/{resourcePath} Delete Resource

POST /{workspaceName}/{resourcePath} Create Resource

PATCH /{workspaceName}/{resourcePath} Update Resource

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/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

openapi: 3.0.1
info:
  title: CData Connect AI OData API
  version: v1

servers:
  - url: https://cloud.cdata.com/api/odata
    description: Production base OData URL

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
  /{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
  /{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
    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
    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
    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
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**.
    #OAuth2:
    #  type: oauth2
    #  flows:
    #    authorizationCode:
    #      authorizationUrl: https://cloud-login.clouddataos.com/authorize
    #      tokenUrl: https://cloud-login.clouddataos.com/oauth/token
    #      refreshUrl: https://cloud-login.clouddataos.com/oauth/refresh
    #      scopes: []
          # Optional tool-specific hint for PKCE
          #x-usePkce: true
security:
  - Basic: []
  #- OAuth2: []