DataFlex / Cognite API v1 / Create 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": [
// {
// "name": "ipsum ut sed d",
// "ignoreNullFields": false,
// "externalId": "proident eu mollit",
// "query": "qui non sint ut",
// "destination": {
// "type": "assets"
// },
// "conflictMode": "aliquip dolore nulla c",
// "isPublic": false,
// "sourceApiKey": "esse dolore aliqua in",
// "destinationApiKey": "nulla in tempor",
// "sourceOidcCredentials": {
// "clientId": "p",
// "clientSecret": "amet",
// "tokenUri": "sit voluptate dolore ",
// "cdfProjectName": "aliquip velit incididunt",
// "scopes": "consectetur cillum",
// "audience": "non magna"
// },
// "destinationOidcCredentials": {
// "clientId": "est culpa",
// "clientSecret": "cillum exercitation",
// "tokenUri": "do ea sint culpa",
// "cdfProjectName": "officia proident",
// "scopes": "cupidatat Lorem elit adipisicing",
// "audience": "nisi veniam"
// }
// },
// {
// "name": "in occaecat ut",
// "ignoreNullFields": false,
// "externalId": "magna Lorem",
// "query": "cillum dolor ea",
// "destination": {
// "type": "relationships"
// },
// "conflictMode": "pariatur laborum eiusmod Ut consectetur",
// "isPublic": true,
// "sourceApiKey": "ullamco eu velit elit",
// "destinationApiKey": "dolore in",
// "sourceOidcCredentials": {
// "clientId": "Ut",
// "clientSecret": "minim commodo Lorem in",
// "tokenUri": "culpa ipsum aliquip pariatur",
// "cdfProjectName": "minim",
// "scopes": "deserunt cillum in non mollit",
// "audience": "elit ea"
// },
// "destinationOidcCredentials": {
// "clientId": "elit eu exercitation",
// "clientSecret": "fugiat",
// "tokenUri": "velit mollit",
// "cdfProjectName": "tempor enim exercitation voluptate dolore",
// "scopes": "ipsum Lorem ullamco consequat",
// "audience": "ullamco"
// }
// }
// ]
// }
Get Create (RefClass(cComChilkatJsonObject)) To hoJson
If (Not(IsComObjectCreated(hoJson))) Begin
Send CreateComObject of hoJson
End
Get ComUpdateString Of hoJson "items[0].name" "ipsum ut sed d" To iSuccess
Get ComUpdateBool Of hoJson "items[0].ignoreNullFields" False To iSuccess
Get ComUpdateString Of hoJson "items[0].externalId" "proident eu mollit" To iSuccess
Get ComUpdateString Of hoJson "items[0].query" "qui non sint ut" To iSuccess
Get ComUpdateString Of hoJson "items[0].destination.type" "assets" To iSuccess
Get ComUpdateString Of hoJson "items[0].conflictMode" "aliquip dolore nulla c" To iSuccess
Get ComUpdateBool Of hoJson "items[0].isPublic" False To iSuccess
Get ComUpdateString Of hoJson "items[0].sourceApiKey" "esse dolore aliqua in" To iSuccess
Get ComUpdateString Of hoJson "items[0].destinationApiKey" "nulla in tempor" To iSuccess
Get ComUpdateString Of hoJson "items[0].sourceOidcCredentials.clientId" "p" To iSuccess
Get ComUpdateString Of hoJson "items[0].sourceOidcCredentials.clientSecret" "amet" To iSuccess
Get ComUpdateString Of hoJson "items[0].sourceOidcCredentials.tokenUri" "sit voluptate dolore " To iSuccess
Get ComUpdateString Of hoJson "items[0].sourceOidcCredentials.cdfProjectName" "aliquip velit incididunt" To iSuccess
Get ComUpdateString Of hoJson "items[0].sourceOidcCredentials.scopes" "consectetur cillum" To iSuccess
Get ComUpdateString Of hoJson "items[0].sourceOidcCredentials.audience" "non magna" To iSuccess
Get ComUpdateString Of hoJson "items[0].destinationOidcCredentials.clientId" "est culpa" To iSuccess
Get ComUpdateString Of hoJson "items[0].destinationOidcCredentials.clientSecret" "cillum exercitation" To iSuccess
Get ComUpdateString Of hoJson "items[0].destinationOidcCredentials.tokenUri" "do ea sint culpa" To iSuccess
Get ComUpdateString Of hoJson "items[0].destinationOidcCredentials.cdfProjectName" "officia proident" To iSuccess
Get ComUpdateString Of hoJson "items[0].destinationOidcCredentials.scopes" "cupidatat Lorem elit adipisicing" To iSuccess
Get ComUpdateString Of hoJson "items[0].destinationOidcCredentials.audience" "nisi veniam" To iSuccess
Get ComUpdateString Of hoJson "items[1].name" "in occaecat ut" To iSuccess
Get ComUpdateBool Of hoJson "items[1].ignoreNullFields" False To iSuccess
Get ComUpdateString Of hoJson "items[1].externalId" "magna Lorem" To iSuccess
Get ComUpdateString Of hoJson "items[1].query" "cillum dolor ea" To iSuccess
Get ComUpdateString Of hoJson "items[1].destination.type" "relationships" To iSuccess
Get ComUpdateString Of hoJson "items[1].conflictMode" "pariatur laborum eiusmod Ut consectetur" To iSuccess
Get ComUpdateBool Of hoJson "items[1].isPublic" True To iSuccess
Get ComUpdateString Of hoJson "items[1].sourceApiKey" "ullamco eu velit elit" To iSuccess
Get ComUpdateString Of hoJson "items[1].destinationApiKey" "dolore in" To iSuccess
Get ComUpdateString Of hoJson "items[1].sourceOidcCredentials.clientId" "Ut" To iSuccess
Get ComUpdateString Of hoJson "items[1].sourceOidcCredentials.clientSecret" "minim commodo Lorem in" To iSuccess
Get ComUpdateString Of hoJson "items[1].sourceOidcCredentials.tokenUri" "culpa ipsum aliquip pariatur" To iSuccess
Get ComUpdateString Of hoJson "items[1].sourceOidcCredentials.cdfProjectName" "minim" To iSuccess
Get ComUpdateString Of hoJson "items[1].sourceOidcCredentials.scopes" "deserunt cillum in non mollit" To iSuccess
Get ComUpdateString Of hoJson "items[1].sourceOidcCredentials.audience" "elit ea" To iSuccess
Get ComUpdateString Of hoJson "items[1].destinationOidcCredentials.clientId" "elit eu exercitation" To iSuccess
Get ComUpdateString Of hoJson "items[1].destinationOidcCredentials.clientSecret" "fugiat" To iSuccess
Get ComUpdateString Of hoJson "items[1].destinationOidcCredentials.tokenUri" "velit mollit" To iSuccess
Get ComUpdateString Of hoJson "items[1].destinationOidcCredentials.cdfProjectName" "tempor enim exercitation voluptate dolore" To iSuccess
Get ComUpdateString Of hoJson "items[1].destinationOidcCredentials.scopes" "ipsum Lorem ullamco consequat" To iSuccess
Get ComUpdateString Of hoJson "items[1].destinationOidcCredentials.audience" "ullamco" 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" 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": [
{
"name": "ipsum ut sed d",
"ignoreNullFields": false,
"externalId": "proident eu mollit",
"query": "qui non sint ut",
"destination": {
"type": "assets"
},
"conflictMode": "aliquip dolore nulla c",
"isPublic": false,
"sourceApiKey": "esse dolore aliqua in",
"destinationApiKey": "nulla in tempor",
"sourceOidcCredentials": {
"clientId": "p",
"clientSecret": "amet",
"tokenUri": "sit voluptate dolore ",
"cdfProjectName": "aliquip velit incididunt",
"scopes": "consectetur cillum",
"audience": "non magna"
},
"destinationOidcCredentials": {
"clientId": "est culpa",
"clientSecret": "cillum exercitation",
"tokenUri": "do ea sint culpa",
"cdfProjectName": "officia proident",
"scopes": "cupidatat Lorem elit adipisicing",
"audience": "nisi veniam"
}
},
{
"name": "in occaecat ut",
"ignoreNullFields": false,
"externalId": "magna Lorem",
"query": "cillum dolor ea",
"destination": {
"type": "relationships"
},
"conflictMode": "pariatur laborum eiusmod Ut consectetur",
"isPublic": true,
"sourceApiKey": "ullamco eu velit elit",
"destinationApiKey": "dolore in",
"sourceOidcCredentials": {
"clientId": "Ut",
"clientSecret": "minim commodo Lorem in",
"tokenUri": "culpa ipsum aliquip pariatur",
"cdfProjectName": "minim",
"scopes": "deserunt cillum in non mollit",
"audience": "elit ea"
},
"destinationOidcCredentials": {
"clientId": "elit eu exercitation",
"clientSecret": "fugiat",
"tokenUri": "velit mollit",
"cdfProjectName": "tempor enim exercitation voluptate dolore",
"scopes": "ipsum Lorem ullamco consequat",
"audience": "ullamco"
}
}
]
}'
https://domain.com/api/v1/projects/{{project}}/transformations
Postman Collection Item JSON
{
"id": "createTransformations",
"name": "Create transformations",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"transformations"
],
"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": "Create a maximum of 1000 transformations per request.",
"body": {
"mode": "raw",
"raw": "{\n \"items\": [\n {\n \"name\": \"ipsum ut sed d\",\n \"ignoreNullFields\": false,\n \"externalId\": \"proident eu mollit\",\n \"query\": \"qui non sint ut\",\n \"destination\": {\n \"type\": \"assets\"\n },\n \"conflictMode\": \"aliquip dolore nulla c\",\n \"isPublic\": false,\n \"sourceApiKey\": \"esse dolore aliqua in\",\n \"destinationApiKey\": \"nulla in tempor\",\n \"sourceOidcCredentials\": {\n \"clientId\": \"p\",\n \"clientSecret\": \"amet\",\n \"tokenUri\": \"sit voluptate dolore \",\n \"cdfProjectName\": \"aliquip velit incididunt\",\n \"scopes\": \"consectetur cillum\",\n \"audience\": \"non magna\"\n },\n \"destinationOidcCredentials\": {\n \"clientId\": \"est culpa\",\n \"clientSecret\": \"cillum exercitation\",\n \"tokenUri\": \"do ea sint culpa\",\n \"cdfProjectName\": \"officia proident\",\n \"scopes\": \"cupidatat Lorem elit adipisicing\",\n \"audience\": \"nisi veniam\"\n }\n },\n {\n \"name\": \"in occaecat ut\",\n \"ignoreNullFields\": false,\n \"externalId\": \"magna Lorem\",\n \"query\": \"cillum dolor ea\",\n \"destination\": {\n \"type\": \"relationships\"\n },\n \"conflictMode\": \"pariatur laborum eiusmod Ut consectetur\",\n \"isPublic\": true,\n \"sourceApiKey\": \"ullamco eu velit elit\",\n \"destinationApiKey\": \"dolore in\",\n \"sourceOidcCredentials\": {\n \"clientId\": \"Ut\",\n \"clientSecret\": \"minim commodo Lorem in\",\n \"tokenUri\": \"culpa ipsum aliquip pariatur\",\n \"cdfProjectName\": \"minim\",\n \"scopes\": \"deserunt cillum in non mollit\",\n \"audience\": \"elit ea\"\n },\n \"destinationOidcCredentials\": {\n \"clientId\": \"elit eu exercitation\",\n \"clientSecret\": \"fugiat\",\n \"tokenUri\": \"velit mollit\",\n \"cdfProjectName\": \"tempor enim exercitation voluptate dolore\",\n \"scopes\": \"ipsum Lorem ullamco consequat\",\n \"audience\": \"ullamco\"\n }\n }\n ]\n}"
}
}
}