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
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": [
// {
// "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 pvComObject of hoJson to vJson
Get ComPostJson3 Of hoHttp "https://domain.com/api/v1/projects/{{project}}/transformations" "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": [
{
"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}"
}
}
}
