REST Endpoint

Version 22.0.8486

REST Endpoint

CData Connect provides a full-featured API that allows any REST-compatible application or client capable of creating HTTP requests to query data, perform batch operations, and execute stored procedures in connected data sources. The top API is based on a JSON-formatted API.

All operations in the API are described relative to the CData Connect API base URL, which is the root URL of the application followed by rest.rsc/. For example, if the application is hosted at http://myconnectserver:8080/, then the root URL of the REST API is http://myconnectserver:8080/rest.rsc/


All requests to the CData Connect API must be properly authenticated using Basic Authentication. To authenticate a request, pass a username and auth token in the Authorization header of the request. See Users for more information on how to create users and authentication tokens.

You can also authenticate with the API by adding the HTTP header x-cdata-authtoken with the desired Auth Token as part of the HTTP request, as shown below:

GET https://myconnectserver/rest.rsc/schemas

Accept: application/json
x-cdata-authtoken: MY_AUTH_TOKEN

Below are some examples of how to connect to the REST API using popular HTTP clients.


One of the simplest ways to retrieve REST data is using the cURL command line tool. The example below shows a cURL command that uses x-cdata-authtoken for authentication:

curl --header "x-cdata-authtoken: my_auth_token" "https://myconnectserver/rest.rsc/My_resource" 

cURL returns the REST response directly to standard output.


Postman is an API testing utility tool that can easily connect to CData Connect’s REST API. To connect to a resource exposed in this API, set the following settings:

  1. Set the HTTP operation to GET.
  2. Set the request URL the API base URL followed by the resource. For example, https://myconnectserver/rest.rsc/my_resource.
  3. In the Authorization tab, set the Auth type to Basic Auth.
  4. Set the Username and password to the username and Auth Token from the Users tab.
  5. Click Send to submit the request.

Postman displays the results in the Response section of its interface.


JavaScript allows you to retrieve data from a REST source in a web page. The example below shows how to retrieve data from a Connect REST entity:

	{ "@authtoken": "MY_AUTH_TOKEN" }, 
	function(data) {

Response Format

Operations in the CData Connect API share a common response format which, depending on the operation, may include:

  • One or more result sets with:
    • Result column metadata
    • Row values, if any
    • Affected row count
  • Output and return parameters (for applicable stored procedure executions)
  • Any error that may have occurred prior to, during, or after request processing

The response objects returned by the API contain one or more of the top-level properties shown below:

  "results": [
      "schema": [
          "ordinal": <int>,
          "catalogName": "<string>",
          "schemaName": "<string>",
          "tableName": "<string>",
          "columnName": "<string>",
          "columnLabel": "<string>",
          "dataType": <int>,
          "dataTypeName": "<string>",
          "length": <int>,
          "precision": <int>,
          "scale": <int>,
          "nullable": <bool>
      "rows": [
        [<any>, <any>, ...],
      "affectedRows": <int>,
  "parameters": {
    "@p1": { "dataType": <int>, "direction": <int>, "value": <any> }
  "error": {
    "code": "<string>",
    "message": "<string>"


results Array of result sets for the query, one object per result set.
  schema Array of column schema for the result set.
    ordinal The position of the column in the result set. 0-based.
    catalogName Name of the column’s catalog.
    schemaName Name of the column’s schema.
    tableName Name of the column’s table.
    columnName The column’s name.
    columnLabel The column’s label.
    dataType The column’s data type.
    dataTypeName Name of the column’s data type. May be data-source-specific.
    length For binary/string columns, the maximum number of characters. For other data types, the display length.
    precision The column’s precision. Omitted if not applicable.
    scale The column’s scale. Omitted if not applicable.
    nullable Whether the column is nullable.
  rows An array of row value arrays. Each nested array represents a row in the result set, and contains the row’s values for each column.
  affectedRows The number of affected rows, or -1 if not applicable/available.
parameters Any output, in/out, or return parameters produced by a stored procedure. Omitted if there are no such parameters in the result.
  dataType The parameter’s data type.
  direction The parameter’s direction: 2 for in/out, 4 for output, or 5 for return.
  value The parameter’s value.
error Information about the error which occurred. Omitted if no error occurred.
  code The error code.
  message The error message.


When CData Connect receives an API request, it validates it, executes it, and then serializes and streams back the results as they arrive. If an error occurs prior to or during execution, the response object will only contain error information. However, it is also possible for errors to occur after a query’s results have started being returned. In such cases, the response object may contain both a partial result as well as error information stating that the result is incomplete.

Since the HTTP status code is returned before the body, incomplete responses will still have a 200 OK status. As such, it’s important that you always check for the presence of error information in the response rather than relying solely on the HTTP status code.

Data Types

The following table shows the valid values for the dataType property in the Result Set Serialization.

Value Meaning Representation
1 BINARY JSON String; base64-encoded
10 FLOAT JSON Number
12 DECIMAL JSON String; format: valid JSON number
13 NUMERIC JSON String; format: valid JSON number
14 BOOLEAN JSON Boolean (true/false)
15 DATE JSON String; format: yyyy-MM-dd
16 TIME JSON String; format: HH:mm:ss.fffffff
17 TIMESTAMP JSON String; ISO8601 format: yyyy-MM-ddTHH:mm:ss.fffffffZ
18 UUID JSON String; format: {01234567-890a-bcde-f012-34567890abcd}