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": {
"type": "assets"
},
"conflictMode": "abort",
"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": {
"type": "assets"
},
"conflictMode": "abort",
"query": "<string>",
"createdTime": 123,
"ignoreNullFields": true,
"status": "Completed",
"startedTime": 123,
"finishedTime": 123,
"lastSeenTime": 123,
"error": "<string>"
},
"runningJob": {
"id": 123,
"uuid": "<string>",
"transformationId": 123,
"transformationExternalId": "<string>",
"sourceProject": "<string>",
"destinationProject": "<string>",
"destination": {
"type": "assets"
},
"conflictMode": "abort",
"query": "<string>",
"createdTime": 123,
"ignoreNullFields": true,
"status": "Completed",
"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": {
"type": "assets"
},
"conflictMode": "abort",
"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": {
"type": "assets"
},
"conflictMode": "abort",
"query": "<string>",
"createdTime": 123,
"ignoreNullFields": true,
"status": "Completed",
"startedTime": 123,
"finishedTime": 123,
"lastSeenTime": 123,
"error": "<string>"
},
"runningJob": {
"id": 123,
"uuid": "<string>",
"transformationId": 123,
"transformationExternalId": "<string>",
"sourceProject": "<string>",
"destinationProject": "<string>",
"destination": {
"type": "assets"
},
"conflictMode": "abort",
"query": "<string>",
"createdTime": 123,
"ignoreNullFields": true,
"status": "Completed",
"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 August 21, 2026
⌘I