DataFlex / Cognite API v1 / Update transformations
Back to Collection Items
Use ChilkatAx-win32.pkg
Procedure Test
Handle hoHttp
Boolean iSuccess
Variant vJson
Handle hoJson
Variant vResp
Handle hoResp
String sTemp1
Integer iTemp1
Boolean bTemp1
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "items": [
// {
// "update": {
// "name": {
// "set": "eu voluptate"
// },
// "destination": {
// "set": {
// "type": "datapoints"
// }
// },
// "conflictMode": {
// "set": "consectetur id sed sint"
// },
// "query": {
// "set": "nisi "
// },
// "sourceOidcCredentials": {
// "set": {
// "clientId": "in fugiat",
// "clientSecret": "Excepteur minim",
// "scopes": "ullamco Ut et nostrud Duis",
// "tokenUri": "nostrud irure enim anim",
// "cdfProjectName": "consequat adipisicing",
// "audience": "dolor nulla ad"
// }
// },
// "destinationOidcCredentials": {
// "setNull": true
// },
// "sourceApiKey": {
// "setNull": false
// },
// "destinationApiKey": {
// "setNull": true
// },
// "isPublic": {
// "set": false
// },
// "ignoreNullFields": {
// "set": true
// }
// },
// "id": -68015575
// },
// {
// "update": {
// "name": {
// "set": "ea fugia"
// },
// "destination": {
// "set": {
// "type": "dolor",
// "database": "ex fugiat veniam",
// "table": "incididunt dolor voluptate"
// }
// },
// "conflictMode": {
// "set": "in in sunt"
// },
// "query": {
// "set": "a"
// },
// "sourceOidcCredentials": {
// "set": {
// "clientId": "aliqua in",
// "clientSecret": "sit amet",
// "scopes": "deserunt id culpa labore",
// "tokenUri": "elit",
// "cdfProjectName": "nostrud aliqua",
// "audience": "in sunt mollit labore laboris"
// }
// },
// "destinationOidcCredentials": {
// "setNull": false
// },
// "sourceApiKey": {
// "setNull": false
// },
// "destinationApiKey": {
// "setNull": true
// },
// "isPublic": {
// "set": true
// },
// "ignoreNullFields": {
// "set": true
// }
// },
// "externalId": "et ut amet quis deserunt"
// }
// ]
// }
Get Create (RefClass(cComChilkatJsonObject)) To hoJson
If (Not(IsComObjectCreated(hoJson))) Begin
Send CreateComObject of hoJson
End
Get ComUpdateString Of hoJson "items[0].update.name.set" "eu voluptate" To iSuccess
Get ComUpdateString Of hoJson "items[0].update.destination.set.type" "datapoints" To iSuccess
Get ComUpdateString Of hoJson "items[0].update.conflictMode.set" "consectetur id sed sint" To iSuccess
Get ComUpdateString Of hoJson "items[0].update.query.set" "nisi " To iSuccess
Get ComUpdateString Of hoJson "items[0].update.sourceOidcCredentials.set.clientId" "in fugiat" To iSuccess
Get ComUpdateString Of hoJson "items[0].update.sourceOidcCredentials.set.clientSecret" "Excepteur minim" To iSuccess
Get ComUpdateString Of hoJson "items[0].update.sourceOidcCredentials.set.scopes" "ullamco Ut et nostrud Duis" To iSuccess
Get ComUpdateString Of hoJson "items[0].update.sourceOidcCredentials.set.tokenUri" "nostrud irure enim anim" To iSuccess
Get ComUpdateString Of hoJson "items[0].update.sourceOidcCredentials.set.cdfProjectName" "consequat adipisicing" To iSuccess
Get ComUpdateString Of hoJson "items[0].update.sourceOidcCredentials.set.audience" "dolor nulla ad" To iSuccess
Get ComUpdateBool Of hoJson "items[0].update.destinationOidcCredentials.setNull" True To iSuccess
Get ComUpdateBool Of hoJson "items[0].update.sourceApiKey.setNull" False To iSuccess
Get ComUpdateBool Of hoJson "items[0].update.destinationApiKey.setNull" True To iSuccess
Get ComUpdateBool Of hoJson "items[0].update.isPublic.set" False To iSuccess
Get ComUpdateBool Of hoJson "items[0].update.ignoreNullFields.set" True To iSuccess
Get ComUpdateInt Of hoJson "items[0].id" -68015575 To iSuccess
Get ComUpdateString Of hoJson "items[1].update.name.set" "ea fugia" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.destination.set.type" "dolor" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.destination.set.database" "ex fugiat veniam" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.destination.set.table" "incididunt dolor voluptate" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.conflictMode.set" "in in sunt" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.query.set" "a" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.sourceOidcCredentials.set.clientId" "aliqua in" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.sourceOidcCredentials.set.clientSecret" "sit amet" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.sourceOidcCredentials.set.scopes" "deserunt id culpa labore" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.sourceOidcCredentials.set.tokenUri" "elit" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.sourceOidcCredentials.set.cdfProjectName" "nostrud aliqua" To iSuccess
Get ComUpdateString Of hoJson "items[1].update.sourceOidcCredentials.set.audience" "in sunt mollit labore laboris" To iSuccess
Get ComUpdateBool Of hoJson "items[1].update.destinationOidcCredentials.setNull" False To iSuccess
Get ComUpdateBool Of hoJson "items[1].update.sourceApiKey.setNull" False To iSuccess
Get ComUpdateBool Of hoJson "items[1].update.destinationApiKey.setNull" True To iSuccess
Get ComUpdateBool Of hoJson "items[1].update.isPublic.set" True To iSuccess
Get ComUpdateBool Of hoJson "items[1].update.ignoreNullFields.set" True To iSuccess
Get ComUpdateString Of hoJson "items[1].externalId" "et ut amet quis deserunt" To iSuccess
Send ComSetRequestHeader To hoHttp "content-type" "application/json"
Send ComSetRequestHeader To hoHttp "api-key" "{{api-key}}"
Get pvComObject of hoJson to vJson
Get ComPostJson3 Of hoHttp "https://domain.com/api/v1/projects/{{project}}/transformations/update" "application/json" vJson To vResp
If (IsComObject(vResp)) Begin
Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
Set pvComObject Of hoResp To vResp
End
Get ComLastMethodSuccess Of hoHttp To bTemp1
If (bTemp1 = False) Begin
Get ComLastErrorText Of hoHttp To sTemp1
Showln sTemp1
Procedure_Return
End
Get ComStatusCode Of hoResp To iTemp1
Showln iTemp1
Get ComBodyStr Of hoResp To sTemp1
Showln sTemp1
Send Destroy of hoResp
End_Procedure
Curl Command
curl -X POST
-H "api-key: {{api-key}}"
-H "content-type: application/json"
-d '{
"items": [
{
"update": {
"name": {
"set": "eu voluptate"
},
"destination": {
"set": {
"type": "datapoints"
}
},
"conflictMode": {
"set": "consectetur id sed sint"
},
"query": {
"set": "nisi "
},
"sourceOidcCredentials": {
"set": {
"clientId": "in fugiat",
"clientSecret": "Excepteur minim",
"scopes": "ullamco Ut et nostrud Duis",
"tokenUri": "nostrud irure enim anim",
"cdfProjectName": "consequat adipisicing",
"audience": "dolor nulla ad"
}
},
"destinationOidcCredentials": {
"setNull": true
},
"sourceApiKey": {
"setNull": false
},
"destinationApiKey": {
"setNull": true
},
"isPublic": {
"set": false
},
"ignoreNullFields": {
"set": true
}
},
"id": -68015575
},
{
"update": {
"name": {
"set": "ea fugia"
},
"destination": {
"set": {
"type": "dolor",
"database": "ex fugiat veniam",
"table": "incididunt dolor voluptate"
}
},
"conflictMode": {
"set": "in in sunt"
},
"query": {
"set": "a"
},
"sourceOidcCredentials": {
"set": {
"clientId": "aliqua in",
"clientSecret": "sit amet",
"scopes": "deserunt id culpa labore",
"tokenUri": "elit",
"cdfProjectName": "nostrud aliqua",
"audience": "in sunt mollit labore laboris"
}
},
"destinationOidcCredentials": {
"setNull": false
},
"sourceApiKey": {
"setNull": false
},
"destinationApiKey": {
"setNull": true
},
"isPublic": {
"set": true
},
"ignoreNullFields": {
"set": true
}
},
"externalId": "et ut amet quis deserunt"
}
]
}'
https://domain.com/api/v1/projects/{{project}}/transformations/update
Postman Collection Item JSON
{
"id": "updateTransformations",
"name": "Update transformations",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"transformations",
"update"
],
"query": [
],
"variable": [
]
},
"method": "POST",
"header": [
{
"key": "api-key",
"value": "{{api-key}}",
"description": "An admin can create API keys in the Cognite console."
},
{
"key": "content-type",
"value": "application/json"
}
],
"description": "Update the attributes of transformations, maximum 1000 per request.",
"body": {
"mode": "raw",
"raw": "{\n \"items\": [\n {\n \"update\": {\n \"name\": {\n \"set\": \"eu voluptate\"\n },\n \"destination\": {\n \"set\": {\n \"type\": \"datapoints\"\n }\n },\n \"conflictMode\": {\n \"set\": \"consectetur id sed sint\"\n },\n \"query\": {\n \"set\": \"nisi \"\n },\n \"sourceOidcCredentials\": {\n \"set\": {\n \"clientId\": \"in fugiat\",\n \"clientSecret\": \"Excepteur minim\",\n \"scopes\": \"ullamco Ut et nostrud Duis\",\n \"tokenUri\": \"nostrud irure enim anim\",\n \"cdfProjectName\": \"consequat adipisicing\",\n \"audience\": \"dolor nulla ad\"\n }\n },\n \"destinationOidcCredentials\": {\n \"setNull\": true\n },\n \"sourceApiKey\": {\n \"setNull\": false\n },\n \"destinationApiKey\": {\n \"setNull\": true\n },\n \"isPublic\": {\n \"set\": false\n },\n \"ignoreNullFields\": {\n \"set\": true\n }\n },\n \"id\": -68015575\n },\n {\n \"update\": {\n \"name\": {\n \"set\": \"ea fugia\"\n },\n \"destination\": {\n \"set\": {\n \"type\": \"dolor\",\n \"database\": \"ex fugiat veniam\",\n \"table\": \"incididunt dolor voluptate\"\n }\n },\n \"conflictMode\": {\n \"set\": \"in in sunt\"\n },\n \"query\": {\n \"set\": \"a\"\n },\n \"sourceOidcCredentials\": {\n \"set\": {\n \"clientId\": \"aliqua in\",\n \"clientSecret\": \"sit amet\",\n \"scopes\": \"deserunt id culpa labore\",\n \"tokenUri\": \"elit\",\n \"cdfProjectName\": \"nostrud aliqua\",\n \"audience\": \"in sunt mollit labore laboris\"\n }\n },\n \"destinationOidcCredentials\": {\n \"setNull\": false\n },\n \"sourceApiKey\": {\n \"setNull\": false\n },\n \"destinationApiKey\": {\n \"setNull\": true\n },\n \"isPublic\": {\n \"set\": true\n },\n \"ignoreNullFields\": {\n \"set\": true\n }\n },\n \"externalId\": \"et ut amet quis deserunt\"\n }\n ]\n}"
}
}
}
