Fetch table detail for a saved connector

GET

connectors

{uuid}

detail

curl --request GET \
  --url https://api.artie.com/connectors/{uuid}/detail \
  --header 'Authorization: Bearer <token>'

{
  "columns": [
    {
      "metadata": {
        "comment": "<string>",
        "dataType": "<string>",
        "defaultValue": "<string>",
        "isPrimaryKey": true,
        "notNull": true
      },
      "name": "<string>"
    }
  ],
  "createdAt": "2023-11-07T05:31:56Z",
  "isView": true,
  "metadata": [
    {
      "isDate": true,
      "key": "<string>",
      "value": "<unknown>"
    }
  ],
  "modifiedAt": "2023-11-07T05:31:56Z",
  "name": "<string>",
  "schema": "<string>",
  "unreadable": true
}

Authorizations

Authorization

string

header

required

API key passed as a Bearer token in the Authorization header.

Path Parameters

uuid

string

required

Response

columns

object[]

Show child attributes

createdAt

null | string<date-time>

isView

boolean

metadata

object[]

Show child attributes

modifiedAt

null | string<date-time>

name

string

schema

string

unreadable

boolean

Generate Oracle shadow table scriptGenerates the SQL script to create shadow tables required for Oracle change data capture (CDC). Run this script on your Oracle source before starting replication.

⌘I

Fetch table detail for a saved connector

curl --request GET \
  --url https://api.artie.com/connectors/{uuid}/detail \
  --header 'Authorization: Bearer <token>'

{
  "columns": [
    {
      "metadata": {
        "comment": "<string>",
        "dataType": "<string>",
        "defaultValue": "<string>",
        "isPrimaryKey": true,
        "notNull": true
      },
      "name": "<string>"
    }
  ],
  "createdAt": "2023-11-07T05:31:56Z",
  "isView": true,
  "metadata": [
    {
      "isDate": true,
      "key": "<string>",
      "value": "<unknown>"
    }
  ],
  "modifiedAt": "2023-11-07T05:31:56Z",
  "name": "<string>",
  "schema": "<string>",
  "unreadable": true
}