List column classification rows

Settings module

GET/column-classificationscolumnClassifications.list

The classification of one column in the column registry. Returns a cursor page of column classification rows the caller may see. The default order is `table_name` ascending. Supports sparse fieldsets and the filter grammar.

Requires the capability org.settings.read.
OAuth scopes: org.
Cursor-paginated: limit, cursor, fields, sort and filter apply.
Error statuses: 400, 401, 429. Errors are RFC 9457 problem details.

Path and query parameters

columnClassifications.list: Path and query parameters
Field	Type	Required	Description
limit	Limit	No	Page size. Default 50, maximum 200.Constraints: range 1 to 200
cursor	Cursor	No	Opaque cursor from `next_cursor` of the previous page.Constraints: length 1 to any
fields	Fields	No	Sparse fieldset: a comma-separated list of top-level fields to return. `id` is always returned.Constraints: pattern ^[a-z_][a-z0-9_](,[a-z_][a-z0-9_])*$
sort	Sort	No	Sort keys, comma-separated; a leading `-` sorts descending. Without `sort`, the documented default order applies (coded lists sort in numeric code order).Constraints: pattern ^-?[a-z_][a-z0-9_](,-?[a-z_][a-z0-9_])*$
filter	Filter	No	Filter grammar `filter[field][op]=value`. Operators: eq, ne, lt, lte, gt, gte, in (comma-separated values), is_null (true or false) and contains. Conditions combine with AND.

Response 200: a page of ColumnClassification

columnClassifications.list: ColumnClassification
Field	Type	Required	Description
table_name	string	Yes	Schema-qualified table.Constraints: pattern ^[A-Za-z0-9][A-Za-z0-9._-]{0,63}$
column_name	string	Yes	Column.Constraints: pattern ^[A-Za-z0-9][A-Za-z0-9._-]{0,63}$
classification	Classification	Yes	Column classification (Section 8.3).Constraints: one of "Public", "Internal", "Confidential", "Restricted"
read_capability	string \| null	Yes	Capability that unmasks it.Constraints: pattern ^[A-Za-z0-9][A-Za-z0-9._-]{0,63}$

{
  "data": [
    {
      "table_name": "app.pay_rates",
      "column_name": "rate_minor",
      "classification": "Restricted",
      "read_capability": "data.restricted.read.payroll"
    }
  ],
  "next_cursor": null
}

Code samples

curl -X GET "$XOS_BASE_URL/column-classifications" \
  -H "Authorization: Bearer $XOS_API_KEY"

for await (const row of xos.columnClassifications.listAll()) {
  console.log(row);
}

for row in xos.column_classifications.list_all():
    print(row)

xos column-classifications list --all