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
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": {}
}
]授权
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
路径参数
请求体
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, default is first view. result will filter and sort by view options.
"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
[]
响应
Paste successfully
Objects with a fields key mapping fieldId or field name to value for that field.
Show child attributes
Show child attributes
此页面对您有帮助吗?

