Paste content into selected range

PATCH

table

{tableId}

selection

paste

curl --request PATCH \
  --url https://app.teable.io/api/table/%7BtableId%7D/selection/paste \
  --header 'Authorization: Bearer REPLACE_BEARER_TOKEN' \
  --header 'content-type: application/json' \
  --data '{"viewId":"viwXXXXXXX","ignoreViewQuery":"string","filterByTql":"{field} = '\''Completed'\'' AND {field} > 5","filter":{},"search":["searchValue","fieldIdOrName",false],"filterLinkCellCandidate":["fldXXXXXXX","recXXXXXXX"],"filterLinkCellSelected":["fldXXXXXXX","recXXXXXXX"],"selectedRecordIds":["string"],"orderBy":[],"groupBy":[{"fieldId":"string","order":"asc"}],"collapsedGroupIds":["string"],"projection":["string"],"ranges":[[0,0],[1,1]],"type":"columns","content":"John\tDoe\tjohn.doe@example.com","header":[]}'

{
  "ranges": [
    [
      123
    ]
  ]
}

Authorizations

Authorization

string

header

required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

tableId

string

required

Body

application/json

ranges

array

required

The parameter "ranges" is used to represent the coordinates of a selected range in a table.

content

string

required

Content to paste

viewId

string

Set the view you want to fetch, default is first view. result will filter and sort by view options.

ignoreViewQuery

When a viewId is specified, configure this to true will ignore the view's filter, sort, etc

filterByTql

string

deprecated

filter

object

A filter object used to filter results. It allows complex query conditions based on fields, operators, and values.

Search for records that match the specified field and value

filterLinkCellCandidate

Filter out the records that can be selected by a given link cell from the relational table. For example, if the specified field is one to many or one to one relationship, recordId for which the field has already been selected will not appear.

filterLinkCellSelected

Filter out selected records based on this link cell from the relational table. Note that viewId, filter, and orderBy will not take effect in this case because selected records has it own order. Ignoring recordId gets all the selected records for the field

selectedRecordIds

string[]

Filter selected records by record ids

orderBy

any[]

An array of sort objects that specifies how the records should be ordered.

groupBy

object[] | null

collapsedGroupIds

string[]

An array of group ids that specifies which groups are collapsed

projection

string[]

If you want to get only some fields, pass in this parameter, otherwise all visible fields will be obtained

type

enum<string>

Types of non-contiguous selections

Available options:

rows,

columns

header

object[]

Table header for paste operation

header.id

string

required

The id of the field.

header.name

string

required

The name of the field. can not be duplicated in the table.

header.type

enum<string>

required

The field types supported by teable.

Available options:

singleLineText,

longText,

user,

attachment,

checkbox,

multipleSelect,

singleSelect,

date,

number,

duration,

rating,

formula,

rollup,

count,

link,

createdTime,

lastModifiedTime,

createdBy,

lastModifiedBy,

autoNumber,

button

header.options

object

required

The configuration options of the field. The structure of the field's options depend on the field's type.

header.cellValueType

enum<string>

required

The cell value type of the field.

Available options:

string,

number,

boolean,

dateTime

header.dbFieldType

enum<string>

required

The field type of database that cellValue really store.

Available options:

TEXT,

INTEGER,

DATETIME,

REAL,

BLOB,

JSON,

BOOLEAN

header.dbFieldName

string

required

Field(column) name in backend database. Limitation: 1-63 characters, can only contain letters, numbers and underscore, case sensitive, cannot be duplicated with existing db field name in the table.

Minimum length: 1

header.description

string

The description of the field.

header.isLookup

boolean

Whether this field is lookup field. witch means cellValue and [fieldType] is looked up from the linked table.

header.lookupOptions

object

field lookup options.

header.notNull

boolean

Whether this field is not null.

header.unique

boolean

Whether this field is not unique.

header.isPrimary

boolean

Whether this field is primary field.

header.isComputed

boolean

Whether this field is computed field, you can not modify cellValue in computed field.

header.isPending

boolean

Whether this field's calculation is pending.

header.hasError

boolean

Whether This field has a configuration error. Check the fields referenced by this field's formula or configuration.

header.isMultipleCellValue

boolean

Whether this field has multiple cell value.

Response

200 - application/json

Paste successfully

ranges

array

required

Delete selected range dataDelete records or fields within the selected table range

curl --request PATCH \
  --url https://app.teable.io/api/table/%7BtableId%7D/selection/paste \
  --header 'Authorization: Bearer REPLACE_BEARER_TOKEN' \
  --header 'content-type: application/json' \
  --data '{"viewId":"viwXXXXXXX","ignoreViewQuery":"string","filterByTql":"{field} = '\''Completed'\'' AND {field} > 5","filter":{},"search":["searchValue","fieldIdOrName",false],"filterLinkCellCandidate":["fldXXXXXXX","recXXXXXXX"],"filterLinkCellSelected":["fldXXXXXXX","recXXXXXXX"],"selectedRecordIds":["string"],"orderBy":[],"groupBy":[{"fieldId":"string","order":"asc"}],"collapsedGroupIds":["string"],"projection":["string"],"ranges":[[0,0],[1,1]],"type":"columns","content":"John\tDoe\tjohn.doe@example.com","header":[]}'

{
  "ranges": [
    [
      123
    ]
  ]
}

Quick Start

API List

Paste content into selected range

Authorizations

Path Parameters

Body

Response