Python SDK
transformation = client.transformations.retrieve(id=1)
transformation.query = "SELECT * FROM _cdf.assets"
res = client.transformations.update(transformation)
from cognite.client.data_classes import TransformationUpdate
my_update = TransformationUpdate(id=1).query.set("SELECT * FROM _cdf.assets").is_public.set(False)
res = client.transformations.update(my_update)
from cognite.client.data_classes import NonceCredentials
to_update = client.transformations.list(data_set_external_ids=["foo"])
new_session = client.iam.sessions.create()
new_nonce = NonceCredentials(
session_id=new_session.id,
nonce=new_session.nonce,
cdf_project_name=client.config.project
)
for tr in to_update:
tr.source_nonce = new_nonce
tr.destination_nonce = new_nonce
res = client.transformations.update(to_update)List<Transformation> editedInput = // List of Transformations
List<Transformation> updatedList = client.transformations().upsert(editedInput);curl --request POST \
--url https://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"items": [
{
"update": {
"sourceOidcCredentials": {
"setNull": true
},
"destinationOidcCredentials": {
"setNull": true
},
"sourceNonce": {
"setNull": true
},
"destinationNonce": {
"setNull": true
},
"dataSetId": {
"setNull": true
},
"tags": {
"set": [
"<string>"
]
}
},
"externalId": "my.known.id"
}
]
}
'const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
items: [
{
update: {
sourceOidcCredentials: {setNull: true},
destinationOidcCredentials: {setNull: true},
sourceNonce: {setNull: true},
destinationNonce: {setNull: true},
dataSetId: {setNull: true},
tags: {set: ['<string>']}
},
externalId: 'my.known.id'
}
]
})
};
fetch('https://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update', 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://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update",
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([
'items' => [
[
'update' => [
'sourceOidcCredentials' => [
'setNull' => true
],
'destinationOidcCredentials' => [
'setNull' => true
],
'sourceNonce' => [
'setNull' => true
],
'destinationNonce' => [
'setNull' => true
],
'dataSetId' => [
'setNull' => true
],
'tags' => [
'set' => [
'<string>'
]
]
],
'externalId' => 'my.known.id'
]
]
]),
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://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update"
payload := strings.NewReader("{\n \"items\": [\n {\n \"update\": {\n \"sourceOidcCredentials\": {\n \"setNull\": true\n },\n \"destinationOidcCredentials\": {\n \"setNull\": true\n },\n \"sourceNonce\": {\n \"setNull\": true\n },\n \"destinationNonce\": {\n \"setNull\": true\n },\n \"dataSetId\": {\n \"setNull\": true\n },\n \"tags\": {\n \"set\": [\n \"<string>\"\n ]\n }\n },\n \"externalId\": \"my.known.id\"\n }\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))
}require 'uri'
require 'net/http'
url = URI("https://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update")
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 \"items\": [\n {\n \"update\": {\n \"sourceOidcCredentials\": {\n \"setNull\": true\n },\n \"destinationOidcCredentials\": {\n \"setNull\": true\n },\n \"sourceNonce\": {\n \"setNull\": true\n },\n \"destinationNonce\": {\n \"setNull\": true\n },\n \"dataSetId\": {\n \"setNull\": true\n },\n \"tags\": {\n \"set\": [\n \"<string>\"\n ]\n }\n },\n \"externalId\": \"my.known.id\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"items": [
{
"id": 123,
"name": "<string>",
"query": "<string>",
"destination": {},
"isPublic": true,
"createdTime": 123,
"lastUpdatedTime": 123,
"owner": "<string>",
"ownerIsCurrentUser": true,
"hasSourceOidcCredentials": true,
"hasDestinationOidcCredentials": true,
"externalId": "my.known.id",
"ignoreNullFields": true,
"blocked": {
"reason": "<string>",
"createdTime": 123
},
"sourceSession": {
"clientId": "<string>",
"sessionId": 123,
"projectName": "<string>"
},
"destinationSession": {
"clientId": "<string>",
"sessionId": 123,
"projectName": "<string>"
},
"lastFinishedJob": {
"id": 123,
"uuid": "<string>",
"transformationId": 123,
"transformationExternalId": "<string>",
"sourceProject": "<string>",
"destinationProject": "<string>",
"destination": {},
"query": "<string>",
"createdTime": 123,
"ignoreNullFields": true,
"startedTime": 123,
"finishedTime": 123,
"lastSeenTime": 123,
"error": "<string>"
},
"runningJob": {
"id": 123,
"uuid": "<string>",
"transformationId": 123,
"transformationExternalId": "<string>",
"sourceProject": "<string>",
"destinationProject": "<string>",
"destination": {},
"query": "<string>",
"createdTime": 123,
"ignoreNullFields": true,
"startedTime": 123,
"finishedTime": 123,
"lastSeenTime": 123,
"error": "<string>"
},
"schedule": {
"id": 123,
"externalId": "<string>",
"createdTime": 123,
"lastUpdatedTime": 123,
"interval": "0 0 * * *",
"isPaused": true
},
"dataSetId": 123,
"tags": [
"<string>"
]
}
]
}{
"error": {
"code": 123,
"message": "<string>",
"missing": [
{
"externalId": "my.known.id"
}
],
"duplicated": [
{
"externalId": "my.known.id"
}
]
}
}{
"error": {
"code": 123,
"message": "<string>",
"missing": [
{
"externalId": "my.known.id"
}
],
"duplicated": [
{
"externalId": "my.known.id"
}
]
}
}{
"error": {
"code": 123,
"message": "<string>",
"missing": [
{
"externalId": "my.known.id"
}
],
"duplicated": [
{
"externalId": "my.known.id"
}
]
}
}Update transformations
Required capabilities:
transformationsAcl:WRITE
Update the attributes of transformations, maximum 1000 per request.
POST
/
transformations
/
update
Python SDK
transformation = client.transformations.retrieve(id=1)
transformation.query = "SELECT * FROM _cdf.assets"
res = client.transformations.update(transformation)
from cognite.client.data_classes import TransformationUpdate
my_update = TransformationUpdate(id=1).query.set("SELECT * FROM _cdf.assets").is_public.set(False)
res = client.transformations.update(my_update)
from cognite.client.data_classes import NonceCredentials
to_update = client.transformations.list(data_set_external_ids=["foo"])
new_session = client.iam.sessions.create()
new_nonce = NonceCredentials(
session_id=new_session.id,
nonce=new_session.nonce,
cdf_project_name=client.config.project
)
for tr in to_update:
tr.source_nonce = new_nonce
tr.destination_nonce = new_nonce
res = client.transformations.update(to_update)List<Transformation> editedInput = // List of Transformations
List<Transformation> updatedList = client.transformations().upsert(editedInput);curl --request POST \
--url https://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"items": [
{
"update": {
"sourceOidcCredentials": {
"setNull": true
},
"destinationOidcCredentials": {
"setNull": true
},
"sourceNonce": {
"setNull": true
},
"destinationNonce": {
"setNull": true
},
"dataSetId": {
"setNull": true
},
"tags": {
"set": [
"<string>"
]
}
},
"externalId": "my.known.id"
}
]
}
'const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
items: [
{
update: {
sourceOidcCredentials: {setNull: true},
destinationOidcCredentials: {setNull: true},
sourceNonce: {setNull: true},
destinationNonce: {setNull: true},
dataSetId: {setNull: true},
tags: {set: ['<string>']}
},
externalId: 'my.known.id'
}
]
})
};
fetch('https://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update', 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://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update",
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([
'items' => [
[
'update' => [
'sourceOidcCredentials' => [
'setNull' => true
],
'destinationOidcCredentials' => [
'setNull' => true
],
'sourceNonce' => [
'setNull' => true
],
'destinationNonce' => [
'setNull' => true
],
'dataSetId' => [
'setNull' => true
],
'tags' => [
'set' => [
'<string>'
]
]
],
'externalId' => 'my.known.id'
]
]
]),
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://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update"
payload := strings.NewReader("{\n \"items\": [\n {\n \"update\": {\n \"sourceOidcCredentials\": {\n \"setNull\": true\n },\n \"destinationOidcCredentials\": {\n \"setNull\": true\n },\n \"sourceNonce\": {\n \"setNull\": true\n },\n \"destinationNonce\": {\n \"setNull\": true\n },\n \"dataSetId\": {\n \"setNull\": true\n },\n \"tags\": {\n \"set\": [\n \"<string>\"\n ]\n }\n },\n \"externalId\": \"my.known.id\"\n }\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))
}require 'uri'
require 'net/http'
url = URI("https://{cluster}.cognitedata.com/api/v1/projects/{project}/transformations/update")
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 \"items\": [\n {\n \"update\": {\n \"sourceOidcCredentials\": {\n \"setNull\": true\n },\n \"destinationOidcCredentials\": {\n \"setNull\": true\n },\n \"sourceNonce\": {\n \"setNull\": true\n },\n \"destinationNonce\": {\n \"setNull\": true\n },\n \"dataSetId\": {\n \"setNull\": true\n },\n \"tags\": {\n \"set\": [\n \"<string>\"\n ]\n }\n },\n \"externalId\": \"my.known.id\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"items": [
{
"id": 123,
"name": "<string>",
"query": "<string>",
"destination": {},
"isPublic": true,
"createdTime": 123,
"lastUpdatedTime": 123,
"owner": "<string>",
"ownerIsCurrentUser": true,
"hasSourceOidcCredentials": true,
"hasDestinationOidcCredentials": true,
"externalId": "my.known.id",
"ignoreNullFields": true,
"blocked": {
"reason": "<string>",
"createdTime": 123
},
"sourceSession": {
"clientId": "<string>",
"sessionId": 123,
"projectName": "<string>"
},
"destinationSession": {
"clientId": "<string>",
"sessionId": 123,
"projectName": "<string>"
},
"lastFinishedJob": {
"id": 123,
"uuid": "<string>",
"transformationId": 123,
"transformationExternalId": "<string>",
"sourceProject": "<string>",
"destinationProject": "<string>",
"destination": {},
"query": "<string>",
"createdTime": 123,
"ignoreNullFields": true,
"startedTime": 123,
"finishedTime": 123,
"lastSeenTime": 123,
"error": "<string>"
},
"runningJob": {
"id": 123,
"uuid": "<string>",
"transformationId": 123,
"transformationExternalId": "<string>",
"sourceProject": "<string>",
"destinationProject": "<string>",
"destination": {},
"query": "<string>",
"createdTime": 123,
"ignoreNullFields": true,
"startedTime": 123,
"finishedTime": 123,
"lastSeenTime": 123,
"error": "<string>"
},
"schedule": {
"id": 123,
"externalId": "<string>",
"createdTime": 123,
"lastUpdatedTime": 123,
"interval": "0 0 * * *",
"isPaused": true
},
"dataSetId": 123,
"tags": [
"<string>"
]
}
]
}{
"error": {
"code": 123,
"message": "<string>",
"missing": [
{
"externalId": "my.known.id"
}
],
"duplicated": [
{
"externalId": "my.known.id"
}
]
}
}{
"error": {
"code": 123,
"message": "<string>",
"missing": [
{
"externalId": "my.known.id"
}
],
"duplicated": [
{
"externalId": "my.known.id"
}
]
}
}{
"error": {
"code": 123,
"message": "<string>",
"missing": [
{
"externalId": "my.known.id"
}
],
"duplicated": [
{
"externalId": "my.known.id"
}
]
}
}Authorizations
oidc-tokenoauth2-client-credentialsoauth2-open-industrial-dataoauth2-auth-code
Access token issued by the CDF project's configured identity provider. Access token must be an OpenID Connect token, and the project must be configured to accept OpenID Connect tokens. Use a header key of 'Authorization' with a value of 'Bearer $accesstoken'. The token can be obtained through any flow supported by the identity provider.
Body
application/json
Maximum array length:
1000- Option 1
- Option 2
Show child attributes
Show child attributes
Response
Response with list of transformations.
Array of objects (Transformation).
Show child attributes
Show child attributes
Last modified on July 10, 2026
Was this page helpful?
⌘I