curl --request PATCH \
--url https://api.getoneprofile.ai/tables/bulk/ \
--header 'Content-Type: application/json' \
--header 'X-API-Key: <api-key>' \
--data '
{
"ids": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"archived": true,
"folder_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"owner_user_id": "<string>"
}
'import requests
url = "https://api.getoneprofile.ai/tables/bulk/"
payload = {
"ids": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"],
"archived": True,
"folder_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"owner_user_id": "<string>"
}
headers = {
"X-API-Key": "<api-key>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {'X-API-Key': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
ids: ['3c90c3cc-0d44-4b50-8888-8dd25736052a'],
archived: true,
folder_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
owner_user_id: '<string>'
})
};
fetch('https://api.getoneprofile.ai/tables/bulk/', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.getoneprofile.ai/tables/bulk/",
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([
'ids' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
],
'archived' => true,
'folder_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
'owner_user_id' => '<string>'
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"X-API-Key: <api-key>"
],
]);
$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://api.getoneprofile.ai/tables/bulk/"
payload := strings.NewReader("{\n \"ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"archived\": true,\n \"folder_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"owner_user_id\": \"<string>\"\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("X-API-Key", "<api-key>")
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://api.getoneprofile.ai/tables/bulk/")
.header("X-API-Key", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"archived\": true,\n \"folder_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"owner_user_id\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.getoneprofile.ai/tables/bulk/")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["X-API-Key"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"archived\": true,\n \"folder_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"owner_user_id\": \"<string>\"\n}"
response = http.request(request)
puts response.read_body{
"table_ids": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"updated": 123
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>",
"issues": [
{
"input": "<string>",
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>"
}
]
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}Change several tables at once
Change the same fields of many tables in one request: put them in a folder (folder_id, null for the top level of the Tables list), name who owns them (owner_user_id, null for nobody), or archive them or bring them back (archived). Owner means who to ask about a table: it grants and takes away no access, so anyone in the workspace may change it. Answers how many tables changed and which; one already as asked, missing or in Trash is left out.
curl --request PATCH \
--url https://api.getoneprofile.ai/tables/bulk/ \
--header 'Content-Type: application/json' \
--header 'X-API-Key: <api-key>' \
--data '
{
"ids": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"archived": true,
"folder_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"owner_user_id": "<string>"
}
'import requests
url = "https://api.getoneprofile.ai/tables/bulk/"
payload = {
"ids": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"],
"archived": True,
"folder_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"owner_user_id": "<string>"
}
headers = {
"X-API-Key": "<api-key>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {'X-API-Key': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
ids: ['3c90c3cc-0d44-4b50-8888-8dd25736052a'],
archived: true,
folder_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
owner_user_id: '<string>'
})
};
fetch('https://api.getoneprofile.ai/tables/bulk/', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.getoneprofile.ai/tables/bulk/",
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([
'ids' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
],
'archived' => true,
'folder_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
'owner_user_id' => '<string>'
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"X-API-Key: <api-key>"
],
]);
$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://api.getoneprofile.ai/tables/bulk/"
payload := strings.NewReader("{\n \"ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"archived\": true,\n \"folder_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"owner_user_id\": \"<string>\"\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("X-API-Key", "<api-key>")
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://api.getoneprofile.ai/tables/bulk/")
.header("X-API-Key", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"archived\": true,\n \"folder_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"owner_user_id\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.getoneprofile.ai/tables/bulk/")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["X-API-Key"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"archived\": true,\n \"folder_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"owner_user_id\": \"<string>\"\n}"
response = http.request(request)
puts response.read_body{
"table_ids": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"updated": 123
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>",
"issues": [
{
"input": "<string>",
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>"
}
]
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}Authorizations
Query Parameters
Report which tables would change, and change none.
Body
Request body for changing the same fields of several tables at once.
The tables to change. One missing or in Trash is left out.
1 - 500 elementsTrue takes them off the list: out of All, their folder, Favorites and Recent, while search still finds them, they open as before and keep every row. False brings them back, into their folder. Nothing archives a table by itself; only this does.
Put them in this folder; null for the top level of the Tables list. Archived tables move too, and go back to that folder when restored. A table still waiting to be filed after folders replaced tags counts as filed.
The workspace member who owns them from now on; null for no owner. Owner means who to ask about a table: it grants and takes away no access, so anyone in the workspace may change it.
1 - 64Was this page helpful?