List a connection's tables

curl --request GET \
  --url https://api.usenexio.com/connections/{id}/tables \
  --header 'Authorization: Bearer <token>'

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://api.usenexio.com/connections/{id}/tables', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

{
  "data": [
    {
      "columns": [
        {
          "class": "<string>",
          "column": "<string>",
          "feeds": [
            "<string>"
          ],
          "state": "served"
        }
      ],
      "object": "<string>",
      "owner": "none",
      "requirement": "<string>",
      "system": "ams360",
      "table": "<string>",
      "filter": "<string>",
      "filter_required": true
    }
  ],
  "page": {
    "cursor": "<string>",
    "limit": 123,
    "next": "<string>",
    "prev": "<string>",
    "offset": 123
  },
  "request_id": "<string>",
  "source": {
    "actor": {
      "impersonation_kind": "act_as",
      "impersonator": "<string>",
      "member": "<string>"
    },
    "connection": "<string>",
    "family": "<string>",
    "freshness": "<string>",
    "id": "<string>",
    "kind": "warehouse",
    "origin": "default",
    "snapshot_at": "2023-11-07T05:31:56Z",
    "subject": {
      "scope": "<string>",
      "selection": [
        "<string>"
      ],
      "selection_kind": "<string>",
      "selection_source": "<string>",
      "member": {
        "display_name": "<string>",
        "id": "<string>",
        "scope": "<string>"
      }
    },
    "system": "warehouse",
    "elapsed_ms": 123,
    "reason": {
      "kind": "<string>",
      "note": "<string>",
      "ref": "<string>"
    },
    "snapshot_id": "<string>",
    "stale_since": "2023-11-07T05:31:56Z"
  },
  "unreachable": [
    {
      "part": "<string>",
      "reason": "<string>",
      "detail": "<string>",
      "ref": "<string>"
    }
  ],
  "warnings": [
    {
      "code": "<string>",
      "detail": "<string>"
    }
  ],
  "facets": {},
  "total": {
    "exact": true,
    "value": 123
  }
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

GET

connections

{id}

tables

List a connection's tables

curl --request GET \
  --url https://api.usenexio.com/connections/{id}/tables \
  --header 'Authorization: Bearer <token>'

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://api.usenexio.com/connections/{id}/tables', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

{
  "data": [
    {
      "columns": [
        {
          "class": "<string>",
          "column": "<string>",
          "feeds": [
            "<string>"
          ],
          "state": "served"
        }
      ],
      "object": "<string>",
      "owner": "none",
      "requirement": "<string>",
      "system": "ams360",
      "table": "<string>",
      "filter": "<string>",
      "filter_required": true
    }
  ],
  "page": {
    "cursor": "<string>",
    "limit": 123,
    "next": "<string>",
    "prev": "<string>",
    "offset": 123
  },
  "request_id": "<string>",
  "source": {
    "actor": {
      "impersonation_kind": "act_as",
      "impersonator": "<string>",
      "member": "<string>"
    },
    "connection": "<string>",
    "family": "<string>",
    "freshness": "<string>",
    "id": "<string>",
    "kind": "warehouse",
    "origin": "default",
    "snapshot_at": "2023-11-07T05:31:56Z",
    "subject": {
      "scope": "<string>",
      "selection": [
        "<string>"
      ],
      "selection_kind": "<string>",
      "selection_source": "<string>",
      "member": {
        "display_name": "<string>",
        "id": "<string>",
        "scope": "<string>"
      }
    },
    "system": "warehouse",
    "elapsed_ms": 123,
    "reason": {
      "kind": "<string>",
      "note": "<string>",
      "ref": "<string>"
    },
    "snapshot_id": "<string>",
    "stale_since": "2023-11-07T05:31:56Z"
  },
  "unreachable": [
    {
      "part": "<string>",
      "reason": "<string>",
      "detail": "<string>",
      "ref": "<string>"
    }
  ],
  "warnings": [
    {
      "code": "<string>",
      "detail": "<string>"
    }
  ],
  "facets": {},
  "total": {
    "exact": true,
    "value": 123
  }
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

{
  "code": "INVALID_ARGUMENT",
  "request_id": "<string>",
  "status": 123,
  "title": "<string>",
  "type": "<string>",
  "detail": "<string>",
  "details": "<unknown>",
  "errors": [
    {
      "message": "<string>",
      "location": "<string>",
      "value": "<unknown>"
    }
  ],
  "instance": "<string>",
  "reason": "<string>",
  "retry_after_ms": 123
}

Behavior

The response is the one list envelope, with every registered table of the connection the person may read in a single page, sorted by name. A table whose requirement the person’s access policy does not grant is not listed: without the accounting dataset, no accounting table appears, exactly as reading one answers 403 CAPABILITY_DENIED. Each entry in data names the table (the name to read it by), the fully qualified source object, the system it belongs to (ams360 for the system of record’s replica, warehouse for a curated warehouse table), its owner (policy, account, claim or none), the requirement it is read under, its match filter and whether that filter is required, and its columns. Each column carries its field class, its state (served or proven when a collection field serves it, estate_only when only this surface reads it) and feeds, the collection fields it serves. The listing reads no rows. {id} is one of your organization’s connection ids, or sandbox for the sandbox seat’s view of it. Any other id answers 404 NOT_VISIBLE_OR_ABSENT. This route is for lineage, operators and proofs. Product code reads collections under /records. See Source tables.

Authorizations

Authorization

string

header

required

Send the key as Authorization: Bearer <key>. Two kinds of key exist.

Organization keys are issued in the portal (Settings, then API keys), each bound to one environment, shaped nx_<environment slug>_<64 hex>. They carry no capabilities and pass every capability check, with one exception: routes under /records, /actions, /operations, /api/v1/engines/{id}/opportunities, /api/v1/graph and /api/v1/catalog/documents accept an organization key only when its environment is live, and refuse any other with 403 scoped_key_required. Revocation takes effect within 60 seconds.

Scoped keys are issued by Nexio on request, shaped nxsk_v1_<24 hex key id>_<43 character secret>. Each is bound to one org, one environment, a set of engines and a set of capabilities. A malformed, unknown or revoked nxsk_ key fails with 401 and is never retried as an organization key. Revocation takes effect on the next request. A scoped key without a route's capability gets 403 insufficient_capability; a scoped key not bound to the engine gets 403 engine_binding_forbidden.

Key-grantable capabilities: engines:read, runs:write, runs:read, runs:defensibility:read, runs:test, catalog:read, catalog:documents:read, webhooks:manage, conversations:use, conversations:export, records:read, records:opportunities:run, actions:write, actions:read, graph:read, records:analyze.

Routes that accept organization keys only (every scoped key gets 403 insufficient_capability): environment management, engine create, update, configuration and publish, and conversation instance authoring. Each operation description names the capability a scoped key needs.

Headers

Nexio-Act-As

string

The person the request is for, as your identity provider's stable user id. Unset keeps the org-wide posture the key alone grants. The retired X-Nexio-* identity headers are refused on this route with 400 INVALID_ARGUMENT, reason LEGACY_HEADER.

Nexio-Act-As-Email

string

The acting person's verified sign-in email, lowercased. Ignored without Nexio-Act-As.

Nexio-Assertion

string

The signed assertion over the identity headers (v1..).

Nexio-Request-Id

string

A caller-chosen request id, echoed in the Nexio-Request-Id response header.

Nexio-Timeout

string

The caller's remaining budget for this request, in whole milliseconds (1 to 10 digits, greater than zero), relative to receipt. The engine stops work at the shorter of this and the route's own budget, and answers 504 request_timeout when it expires. A value above the route budget is capped to it; a malformed value is ignored.

Path Parameters

string

required

The connection: one of the organization's connection ids, or sandbox for the sandbox seat's view of it. Any other id answers 404 NOT_VISIBLE_OR_ABSENT.

Response

data

object[] | null

required

Every registered table, sorted by name.

Hide child attributes

data.columns

object[] | null

required

Every column a read serves, with its field class.

Hide child attributes

data.columns.class

string

required

The column's field class: business, identity, direct_identifier, and so on.

data.columns.column

string

required

The source column, as the system of record spells it.

data.columns.feeds

string[] | null

required

The collection fields that serve the column, as <family>.<field>; empty when no collection serves it yet.

data.columns.state

enum<string>

served or proven when a collection field serves the column, estate_only when only this surface reads it. Absent for a curated warehouse table.

Available options:

served,

proven,

estate_only

data.object

string

required

The source object the rows are read from, fully qualified.

data.owner

enum<string>

required

The record a read is narrowed to; its id is the required filter (policy_id, account_id, claim_id). none: the table is read whole.

Available options:

none,

policy,

account,

claim

data.requirement

string

required

The access row the table is read under: reference (the vocabulary dataset), accounting, policy, account, claim or org.

data.system

enum<string>

required

The system the object belongs to: the system of record's replica, or a curated warehouse table.

Available options:

ams360,

warehouse

data.table

string

required

The table's name on GET /connections/{id}/tables/{table}.

data.filter

string

The match filter the table takes, named after its column (cocode, brokercode); absent when it takes none.

data.filter_required

boolean

True when the table is read one filter value at a time.

page

object

required

Hide child attributes

page.cursor

string | null

required

The cursor that produced this page; null for the first page.

page.limit

integer<int64>

required

The page size the platform applied, after any coercion (see warnings).

page.next

string | null

required

The cursor of the following page; null at the end of the collection.

page.prev

string | null

required

The cursor of the preceding page; null on the first page.

page.offset

integer<int64>

The rows skipped before this page, echoed only when the request sent offset (a register's page jump).

request_id

string

required

The request id, as echoed in the Nexio-Request-Id response header.

source

object

required

Hide child attributes

source.actor

object

required

Hide child attributes

source.actor.impersonation_kind

enum<string>

Available options:

act_as,

workos

source.actor.impersonator

string

The operator behind an impersonated session.

source.actor.member

string

The acting member (Nexio-Act-As); empty for a key acting as itself.

source.connection

string

required

The id of the connection that answered; empty when the read had no connection.

source.family

string

required

The registry family that answered.

source.freshness

string

required

fresh, cached, stale, live or stale_after_write.

source.id

string

required

The registry source id (warehouse, ams360_ems, ...), empty when absent.

source.kind

enum<string>

required

The kind of source that answered: the warehouse, the customer's system of record (whichever vendor; the vendor is in id), the platform's own store, or absent when no source serves the family.

Available options:

warehouse,

system,

store,

absent

source.origin

enum<string>

required

Which input decided the source.

Available options:

default,

connection,

seat

source.snapshot_at

string<date-time> | null

required

The instant the rows were read at: the warehouse pin, or the live call's time.

source.subject

object

required

Hide child attributes

source.subject.scope

string

required

The scope kind the acting seat resolved to (self, office, all, ...).

source.subject.selection

string[] | null

required

The subject selection served, as subject= tokens (own, book:, producer:<code|me>, client_manager:<code|me>, member:). Empty when none was sent.

source.subject.selection_kind

string

required

own, code, client_manager, account, boundary or whole: what the served relation is.

source.subject.selection_source

string

required

request when the caller chose the selection; none when it chose nothing.

source.subject.member

object

The member whose book was read, when the request read as another member.

Hide child attributes

source.subject.member.display_name

string

required

source.subject.member.id

string

required

source.subject.member.scope

string

required

source.system

enum<string>

required

deprecated

Deprecated: read kind instead. The system behind the source.

Available options:

warehouse,

ams360,

store,

absent

source.elapsed_ms

integer<int64>

A live source's call time for this read.

source.reason

object

Why the family is absent, when kind is absent.

Hide child attributes

source.reason.kind

string

required

source.reason.note

string

source.reason.ref

string

source.snapshot_id

string

The warehouse snapshot the rows came from, when one names them.

source.stale_since

string<date-time>

When the snapshot stopped being current, for a stale read.

unreachable

object[] | null

required

Parts of the answer no source could fill, each with its reason. Empty when every part was filled.

Hide child attributes

unreachable.part

string

required

The envelope part (a field path or a child family).

unreachable.reason

string

required

Why: no_adapter, not_documented, absent, source_unavailable, ...

unreachable.detail

string

unreachable.ref

string

The vendor reference id of the call that failed, when one did.

warnings

object[] | null

required

Adjustments the platform made to the request (a coerced limit, a dropped facet).

Hide child attributes

warnings.code

string

required

UPPER_SNAKE_CASE, one meaning forever (LIMIT_COERCED, FACET_DROPPED, ...).

warnings.detail

string

facets

object

Present only for the facets the request named in facets=.

Hide child attributes

facets.{key}

object[] | null

Hide child attributes

facets.{key}.count

integer<int64>

required

facets.{key}.value

string

required

facets.{key}.label

string

facets.{key}.parent

string

total

object

Present only when the request sent include_total=true.

Hide child attributes

total.exact

boolean

required

total.value

integer<int64>

required

Last modified on October 7, 2026

Overview

Engines

Environments

Conversations

Webhooks

Events

Records

Connections

Graph

Platform

List a connection's tables

Behavior

Authorizations

Headers

Path Parameters

Response

​Behavior

Authorizations

Headers

Path Parameters

Response

Behavior