Databases
Mass update database data based on filters.
ROLES: RESOURCE_WRITE,RESOURCE_ADMIN USER: true SERVICE ACCOUNT: true
POST
/
api
/
v1
/
databases
/
{databaseId}
/
updateRequest
Mass update database data based on filters.
curl --request POST \
--url https://api.revoengine.com/api/v1/databases/{databaseId}/updateRequest \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"filter": {},
"data": {}
}
'const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({filter: {}, data: {}})
};
fetch('https://api.revoengine.com/api/v1/databases/{databaseId}/updateRequest', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://api.revoengine.com/api/v1/databases/{databaseId}/updateRequest"
payload = {
"filter": {},
"data": {}
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)Authorizations
Bearer JWT token or API Key (sk-*).
Path Parameters
Provide databaseId or database name.
Body
application/json
Filter object or array of filter objects.
Field map with legacy shortcuts, or ordered explicit operations. Use operations for literal assignments and chained transformations.
- object
- object[]
Join definition for filtering.
Limit of affected rows.
Required range:
x >= 1Offset of affected rows.
Return updated rows.
Return only primary keys (reduces payload).
Response
OK.
⌘I
Mass update database data based on filters.
curl --request POST \
--url https://api.revoengine.com/api/v1/databases/{databaseId}/updateRequest \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"filter": {},
"data": {}
}
'const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({filter: {}, data: {}})
};
fetch('https://api.revoengine.com/api/v1/databases/{databaseId}/updateRequest', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://api.revoengine.com/api/v1/databases/{databaseId}/updateRequest"
payload = {
"filter": {},
"data": {}
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)