VBScript / Cognite API v1 / Create transformations
Back to Collection Items
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")
' 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"
' }
' }
' ]
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("items[0].name","ipsum ut sed d")
success = json.UpdateBool("items[0].ignoreNullFields",0)
success = json.UpdateString("items[0].externalId","proident eu mollit")
success = json.UpdateString("items[0].query","qui non sint ut")
success = json.UpdateString("items[0].destination.type","assets")
success = json.UpdateString("items[0].conflictMode","aliquip dolore nulla c")
success = json.UpdateBool("items[0].isPublic",0)
success = json.UpdateString("items[0].sourceApiKey","esse dolore aliqua in")
success = json.UpdateString("items[0].destinationApiKey","nulla in tempor")
success = json.UpdateString("items[0].sourceOidcCredentials.clientId","p")
success = json.UpdateString("items[0].sourceOidcCredentials.clientSecret","amet")
success = json.UpdateString("items[0].sourceOidcCredentials.tokenUri","sit voluptate dolore ")
success = json.UpdateString("items[0].sourceOidcCredentials.cdfProjectName","aliquip velit incididunt")
success = json.UpdateString("items[0].sourceOidcCredentials.scopes","consectetur cillum")
success = json.UpdateString("items[0].sourceOidcCredentials.audience","non magna")
success = json.UpdateString("items[0].destinationOidcCredentials.clientId","est culpa")
success = json.UpdateString("items[0].destinationOidcCredentials.clientSecret","cillum exercitation")
success = json.UpdateString("items[0].destinationOidcCredentials.tokenUri","do ea sint culpa")
success = json.UpdateString("items[0].destinationOidcCredentials.cdfProjectName","officia proident")
success = json.UpdateString("items[0].destinationOidcCredentials.scopes","cupidatat Lorem elit adipisicing")
success = json.UpdateString("items[0].destinationOidcCredentials.audience","nisi veniam")
success = json.UpdateString("items[1].name","in occaecat ut")
success = json.UpdateBool("items[1].ignoreNullFields",0)
success = json.UpdateString("items[1].externalId","magna Lorem")
success = json.UpdateString("items[1].query","cillum dolor ea")
success = json.UpdateString("items[1].destination.type","relationships")
success = json.UpdateString("items[1].conflictMode","pariatur laborum eiusmod Ut consectetur")
success = json.UpdateBool("items[1].isPublic",1)
success = json.UpdateString("items[1].sourceApiKey","ullamco eu velit elit")
success = json.UpdateString("items[1].destinationApiKey","dolore in")
success = json.UpdateString("items[1].sourceOidcCredentials.clientId","Ut")
success = json.UpdateString("items[1].sourceOidcCredentials.clientSecret","minim commodo Lorem in")
success = json.UpdateString("items[1].sourceOidcCredentials.tokenUri","culpa ipsum aliquip pariatur")
success = json.UpdateString("items[1].sourceOidcCredentials.cdfProjectName","minim")
success = json.UpdateString("items[1].sourceOidcCredentials.scopes","deserunt cillum in non mollit")
success = json.UpdateString("items[1].sourceOidcCredentials.audience","elit ea")
success = json.UpdateString("items[1].destinationOidcCredentials.clientId","elit eu exercitation")
success = json.UpdateString("items[1].destinationOidcCredentials.clientSecret","fugiat")
success = json.UpdateString("items[1].destinationOidcCredentials.tokenUri","velit mollit")
success = json.UpdateString("items[1].destinationOidcCredentials.cdfProjectName","tempor enim exercitation voluptate dolore")
success = json.UpdateString("items[1].destinationOidcCredentials.scopes","ipsum Lorem ullamco consequat")
success = json.UpdateString("items[1].destinationOidcCredentials.audience","ullamco")
http.SetRequestHeader "content-type","application/json"
http.SetRequestHeader "api-key","{{api-key}}"
' resp is a Chilkat.HttpResponse
Set resp = http.PostJson3("https://domain.com/api/v1/projects/{{project}}/transformations","application/json",json)
If (http.LastMethodSuccess = 0) Then
outFile.WriteLine(http.LastErrorText)
WScript.Quit
End If
outFile.WriteLine(resp.StatusCode)
outFile.WriteLine(resp.BodyStr)
outFile.Close
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}"
}
}
}
