curl --request PATCH \
--url https://app.teable.ai/api/table/%7BtableId%7D/selection/temporaryPaste \
--header 'Authorization: Bearer REPLACE_BEARER_TOKEN' \
--header 'content-type: application/json' \
--data '{"viewId":"viwXXXXXXX","ranges":[[0,0],[1,1]],"projection":["string"],"ignoreViewQuery":"string","content":"John\tDoe\tjohn.doe@example.com","header":[]}'const url = 'https://app.teable.ai/api/table/%7BtableId%7D/selection/temporaryPaste';
const options = {
method: 'PATCH',
headers: {
Authorization: 'Bearer REPLACE_BEARER_TOKEN',
'content-type': 'application/json'
},
body: '{"viewId":"viwXXXXXXX","ranges":[[0,0],[1,1]],"projection":["string"],"ignoreViewQuery":"string","content":"John\tDoe\tjohn.doe@example.com","header":[]}'
};
try {
const response = await fetch(url, options);
const data = await response.json();
console.log(data);
} catch (error) {
console.error(error);
}const http = require('https');
const options = {
method: 'PATCH',
hostname: 'app.teable.ai',
port: null,
path: '/api/table/%7BtableId%7D/selection/temporaryPaste',
headers: {
Authorization: 'Bearer REPLACE_BEARER_TOKEN',
'content-type': 'application/json'
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on('data', function (chunk) {
chunks.push(chunk);
});
res.on('end', function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.write(JSON.stringify({
viewId: 'viwXXXXXXX',
ranges: [[0, 0], [1, 1]],
projection: ['string'],
ignoreViewQuery: 'string',
content: 'John Doe john.doe@example.com',
header: []
}));
req.end();import http.client
conn = http.client.HTTPSConnection("app.teable.ai")
payload = "{\"viewId\":\"viwXXXXXXX\",\"ranges\":[[0,0],[1,1]],\"projection\":[\"string\"],\"ignoreViewQuery\":\"string\",\"content\":\"John\\tDoe\\tjohn.doe@example.com\",\"header\":[]}"
headers = {
'Authorization': "Bearer REPLACE_BEARER_TOKEN",
'content-type': "application/json"
}
conn.request("PATCH", "/api/table/%7BtableId%7D/selection/temporaryPaste", payload, headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://app.teable.ai/api/table/{tableId}/selection/temporaryPaste",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'ranges' => [
[
0,
0
],
[
1,
1
]
],
'content' => 'John\tDoe\tjohn.doe@example.com',
'viewId' => 'viwXXXXXXX',
'projection' => [
'<string>'
],
'ignoreViewQuery' => '<string>',
'header' => [
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://app.teable.ai/api/table/{tableId}/selection/temporaryPaste"
payload := strings.NewReader("{\n \"ranges\": [\n [\n 0,\n 0\n ],\n [\n 1,\n 1\n ]\n ],\n \"content\": \"John\\tDoe\\tjohn.doe@example.com\",\n \"viewId\": \"viwXXXXXXX\",\n \"projection\": [\n \"<string>\"\n ],\n \"ignoreViewQuery\": \"<string>\",\n \"header\": []\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://app.teable.ai/api/table/{tableId}/selection/temporaryPaste")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"ranges\": [\n [\n 0,\n 0\n ],\n [\n 1,\n 1\n ]\n ],\n \"content\": \"John\\tDoe\\tjohn.doe@example.com\",\n \"viewId\": \"viwXXXXXXX\",\n \"projection\": [\n \"<string>\"\n ],\n \"ignoreViewQuery\": \"<string>\",\n \"header\": []\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://app.teable.ai/api/table/{tableId}/selection/temporaryPaste")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"ranges\": [\n [\n 0,\n 0\n ],\n [\n 1,\n 1\n ]\n ],\n \"content\": \"John\\tDoe\\tjohn.doe@example.com\",\n \"viewId\": \"viwXXXXXXX\",\n \"projection\": [\n \"<string>\"\n ],\n \"ignoreViewQuery\": \"<string>\",\n \"header\": []\n}"
response = http.request(request)
puts response.read_body[
{
"fields": {}
}
]Preview paste operation results
Preview the results of a paste operation without applying changes to the table
Required token scopes: record|read
curl --request PATCH \
--url https://app.teable.ai/api/table/%7BtableId%7D/selection/temporaryPaste \
--header 'Authorization: Bearer REPLACE_BEARER_TOKEN' \
--header 'content-type: application/json' \
--data '{"viewId":"viwXXXXXXX","ranges":[[0,0],[1,1]],"projection":["string"],"ignoreViewQuery":"string","content":"John\tDoe\tjohn.doe@example.com","header":[]}'const url = 'https://app.teable.ai/api/table/%7BtableId%7D/selection/temporaryPaste';
const options = {
method: 'PATCH',
headers: {
Authorization: 'Bearer REPLACE_BEARER_TOKEN',
'content-type': 'application/json'
},
body: '{"viewId":"viwXXXXXXX","ranges":[[0,0],[1,1]],"projection":["string"],"ignoreViewQuery":"string","content":"John\tDoe\tjohn.doe@example.com","header":[]}'
};
try {
const response = await fetch(url, options);
const data = await response.json();
console.log(data);
} catch (error) {
console.error(error);
}const http = require('https');
const options = {
method: 'PATCH',
hostname: 'app.teable.ai',
port: null,
path: '/api/table/%7BtableId%7D/selection/temporaryPaste',
headers: {
Authorization: 'Bearer REPLACE_BEARER_TOKEN',
'content-type': 'application/json'
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on('data', function (chunk) {
chunks.push(chunk);
});
res.on('end', function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.write(JSON.stringify({
viewId: 'viwXXXXXXX',
ranges: [[0, 0], [1, 1]],
projection: ['string'],
ignoreViewQuery: 'string',
content: 'John Doe john.doe@example.com',
header: []
}));
req.end();import http.client
conn = http.client.HTTPSConnection("app.teable.ai")
payload = "{\"viewId\":\"viwXXXXXXX\",\"ranges\":[[0,0],[1,1]],\"projection\":[\"string\"],\"ignoreViewQuery\":\"string\",\"content\":\"John\\tDoe\\tjohn.doe@example.com\",\"header\":[]}"
headers = {
'Authorization': "Bearer REPLACE_BEARER_TOKEN",
'content-type': "application/json"
}
conn.request("PATCH", "/api/table/%7BtableId%7D/selection/temporaryPaste", payload, headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://app.teable.ai/api/table/{tableId}/selection/temporaryPaste",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'ranges' => [
[
0,
0
],
[
1,
1
]
],
'content' => 'John\tDoe\tjohn.doe@example.com',
'viewId' => 'viwXXXXXXX',
'projection' => [
'<string>'
],
'ignoreViewQuery' => '<string>',
'header' => [
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://app.teable.ai/api/table/{tableId}/selection/temporaryPaste"
payload := strings.NewReader("{\n \"ranges\": [\n [\n 0,\n 0\n ],\n [\n 1,\n 1\n ]\n ],\n \"content\": \"John\\tDoe\\tjohn.doe@example.com\",\n \"viewId\": \"viwXXXXXXX\",\n \"projection\": [\n \"<string>\"\n ],\n \"ignoreViewQuery\": \"<string>\",\n \"header\": []\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://app.teable.ai/api/table/{tableId}/selection/temporaryPaste")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"ranges\": [\n [\n 0,\n 0\n ],\n [\n 1,\n 1\n ]\n ],\n \"content\": \"John\\tDoe\\tjohn.doe@example.com\",\n \"viewId\": \"viwXXXXXXX\",\n \"projection\": [\n \"<string>\"\n ],\n \"ignoreViewQuery\": \"<string>\",\n \"header\": []\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://app.teable.ai/api/table/{tableId}/selection/temporaryPaste")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"ranges\": [\n [\n 0,\n 0\n ],\n [\n 1,\n 1\n ]\n ],\n \"content\": \"John\\tDoe\\tjohn.doe@example.com\",\n \"viewId\": \"viwXXXXXXX\",\n \"projection\": [\n \"<string>\"\n ],\n \"ignoreViewQuery\": \"<string>\",\n \"header\": []\n}"
response = http.request(request)
puts response.read_body[
{
"fields": {}
}
]Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Path Parameters
Body
The parameter "ranges" is used to represent the coordinates of a selected range in a table.
12 elements[[0, 0], [1, 1]]
Content to paste
"John\tDoe\tjohn.doe@example.com"
Set the view you want to fetch. When provided, records will follow that view's filter and sort settings. When omitted, the API queries the table without applying a view.
"viwXXXXXXX"
If you want to get only some fields, pass in this parameter, otherwise all visible fields will be obtained
When a viewId is specified, configure this to true will ignore the view's filter, sort, etc
Table header for paste operation
Show child attributes
Show child attributes
[]
Response
Paste successfully
Objects with a fields key mapping fieldId or field name to value for that field.
Show child attributes
Show child attributes
Was this page helpful?

