Skip to content

Tables

Get view

Get one saved table view by identifier. OAuth scope: `api:read`.

GET/api/v2/tables/{tableId}/views/{viewId}

Get one saved table view by identifier.

OAuth scope: api:read.

Authentication

Send a personal or workspace API key in X-API-Key. See key types and access; operations that reject workspace keys say so in their description.

Send X-API-Key in the request header.

Alternatively

Send a Sim OAuth access token in Authorization: Bearer. See OAuth authentication and scopes.

Authorization: Bearer YOUR_ACCESS_TOKEN

Required scopes: api:read

OAuth flows
json
{
  "authorizationCode": {
    "authorizationUrl": "https://www.sim.ai/api/auth/oauth2/authorize",
    "tokenUrl": "https://www.sim.ai/api/auth/oauth2/token",
    "refreshUrl": "https://www.sim.ai/api/auth/oauth2/token",
    "scopes": {
      "api:read": "Read your workspaces, workflows, files, tables, and logs",
      "api:write": "Read, create, change, run, and delete resources in your workspaces",
      "offline_access": "Stay signed in without asking again"
    }
  }
}

OAuth scope: api:read.

Path parameters

tableIdstringRequired

Unique table identifier.

minLength
1
viewIdstringRequired

Unique saved-view identifier.

minLength
1

Query parameters

workspaceIdstringRequired

Workspace that owns the table.

minLength
1

Responses

200

The requested table view.

object

A single saved table view.

1 field
dataobjectRequired

Response data.

8 fields
idstringRequired

Unique saved-view identifier.

tableIdstringRequired

Table to which the view belongs.

namestringRequired

Saved-view display name.

configobjectRequired

Saved filter, sort, and column-layout configuration.

6 fields
columnWidthsobject

Column widths keyed by column name.

Schema details
Additional propertiesnumber
exclusiveMinimum
0
columnOrderarray

Column names in display order.

Schema details
Array itemstring
pinnedColumnsarray

Names of pinned columns.

Schema details
Array itemstring
hiddenColumnsarray

Names of hidden columns.

Schema details
Array itemstring
filtervalue

Saved row predicate, or null when the view is unfiltered.

Schema details

Any of

Option 1value

Recursive saved predicate tree. Runtime validation uses the canonical predicate schema.

Option 2null
sortvalue

Saved ordered sort specification, or null for default ordering.

Schema details

Any of

Option 1array
maxItems
16
Schema details
Array itemobject
2 fields
fieldstringRequired

Column name to sort by.

minLength
1
maxLength
128
directionstringRequired

Sort direction for this column.

enum
["asc","desc"]

Additional properties are not allowed.

Option 2null

Additional properties are not allowed.

isDefaultbooleanRequired

Whether this is the table default view.

createdByEmailvalueRequired

Current author email, or null when removed.

Schema details

Any of

Option 1string
format
email
pattern
^(?!\.)(?!.*\.\.)([A-Za-z0-9_'+\-\.]*)[A-Za-z0-9_+-]@([A-Za-z0-9][A-Za-z0-9\-]*\.)+[A-Za-z]{2,}$
Option 2null
createdAtstringRequired

ISO 8601 timestamp when the view was created.

format
date-time
pattern
^(?:(?:\d\d[2468][048]|\d\d[13579][26]|\d\d0[48]|[02468][048]00|[13579][26]00)-02-29|\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\d|30)|(?:02)-(?:0[1-9]|1\d|2[0-8])))T(?:(?:[01]\d|2[0-3]):[0-5]\d(?::[0-5]\d(?:\.\d+)?)?(?:Z))$
updatedAtstringRequired

ISO 8601 timestamp when the view was last modified.

format
date-time
pattern
^(?:(?:\d\d[2468][048]|\d\d[13579][26]|\d\d0[48]|[02468][048]00|[13579][26]00)-02-29|\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\d|30)|(?:02)-(?:0[1-9]|1\d|2[0-8])))T(?:(?:[01]\d|2[0-3]):[0-5]\d(?::[0-5]\d(?:\.\d+)?)?(?:Z))$

Additional properties are not allowed.

Additional properties are not allowed.

Response headers

X-RateLimit-Limitinteger

Maximum requests allowed in the current window.

minimum
0
maximum
9007199254740991
X-RateLimit-Remaininginteger

Requests remaining in the current window.

minimum
0
maximum
9007199254740991
X-RateLimit-Resetstring

ISO 8601 timestamp when the current rate-limit window resets.

format
date-time
pattern
^(?:(?:\d\d[2468][048]|\d\d[13579][26]|\d\d0[48]|[02468][048]00|[13579][26]00)-02-29|\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\d|30)|(?:02)-(?:0[1-9]|1\d|2[0-8])))T(?:(?:[01]\d|2[0-3]):[0-5]\d(?::[0-5]\d(?:\.\d+)?)?(?:Z))$
Was this helpful?
Suggest an edit