Update all records matching specified search criteria
Provide search and update objects with path and new value to patch rows matching search criteria.
POST
/
workspace
/
{workspace_id}
/
table
/
{table_id}
/
content
/
search
/
patch
Update all records matching specified search criteria
curl --request POST \
--url https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"search": [
{
"name": "test"
}
],
"updates": {
"name": "new name"
}
}
'import requests
url = "https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch"
payload = {
"search": [{ "name": "test" }],
"updates": { "name": "new name" }
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({search: [{name: 'test'}], updates: {name: 'new name'}})
};
fetch('https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch', 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://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'search' => [
[
'name' => 'test'
]
],
'updates' => [
'name' => 'new name'
]
]),
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://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch"
payload := strings.NewReader("{\n \"search\": [\n {\n \"name\": \"test\"\n }\n ],\n \"updates\": {\n \"name\": \"new name\"\n }\n}")
req, _ := http.NewRequest("POST", 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.post("https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"search\": [\n {\n \"name\": \"test\"\n }\n ],\n \"updates\": {\n \"name\": \"new name\"\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"search\": [\n {\n \"name\": \"test\"\n }\n ],\n \"updates\": {\n \"name\": \"new name\"\n }\n}"
response = http.request(request)
puts response.read_body{
"success": [
"<string>"
],
"success_total": 123
}Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Headers
Related topics
Update all records matching specified search criteriaXano Metadata API (Instances)Delete all records matching specified search criteriaWas this page helpful?
Update all records matching specified search criteria
curl --request POST \
--url https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"search": [
{
"name": "test"
}
],
"updates": {
"name": "new name"
}
}
'import requests
url = "https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch"
payload = {
"search": [{ "name": "test" }],
"updates": { "name": "new name" }
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({search: [{name: 'test'}], updates: {name: 'new name'}})
};
fetch('https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch', 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://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'search' => [
[
'name' => 'test'
]
],
'updates' => [
'name' => 'new name'
]
]),
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://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch"
payload := strings.NewReader("{\n \"search\": [\n {\n \"name\": \"test\"\n }\n ],\n \"updates\": {\n \"name\": \"new name\"\n }\n}")
req, _ := http.NewRequest("POST", 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.post("https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"search\": [\n {\n \"name\": \"test\"\n }\n ],\n \"updates\": {\n \"name\": \"new name\"\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://x8ki-letl-twmt.n7.xano.io/api:meta/workspace/{workspace_id}/table/{table_id}/content/search/patch")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"search\": [\n {\n \"name\": \"test\"\n }\n ],\n \"updates\": {\n \"name\": \"new name\"\n }\n}"
response = http.request(request)
puts response.read_body{
"success": [
"<string>"
],
"success_total": 123
}