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
// 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 Create (RefClass(cComChilkatHttpResponse)) To hoResp
If (Not(IsComObjectCreated(hoResp))) Begin
Send CreateComObject of hoResp
End
Get pvComObject of hoJson to vJson
Get pvComObject of hoResp to vResp
Get ComHttpJson Of hoHttp "POST" "https://domain.com/api/v1/projects/{{project}}/transformations/update" vJson "application/json" vResp To iSuccess
If (iSuccess = 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
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}"
}
}
}
