Chilkat Online Tools

VB6 / Cognite API v1 / Update transformations

Back to Collection Items

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As New ChilkatHttp
Dim success As Long

' 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"
'     }
'   ]
' }

Dim json As New ChilkatJsonObject
success = json.UpdateString("items[0].update.name.set","eu voluptate")
success = json.UpdateString("items[0].update.destination.set.type","datapoints")
success = json.UpdateString("items[0].update.conflictMode.set","consectetur id sed sint")
success = json.UpdateString("items[0].update.query.set","nisi ")
success = json.UpdateString("items[0].update.sourceOidcCredentials.set.clientId","in fugiat")
success = json.UpdateString("items[0].update.sourceOidcCredentials.set.clientSecret","Excepteur minim")
success = json.UpdateString("items[0].update.sourceOidcCredentials.set.scopes","ullamco Ut et nostrud Duis")
success = json.UpdateString("items[0].update.sourceOidcCredentials.set.tokenUri","nostrud irure enim anim")
success = json.UpdateString("items[0].update.sourceOidcCredentials.set.cdfProjectName","consequat adipisicing")
success = json.UpdateString("items[0].update.sourceOidcCredentials.set.audience","dolor nulla ad")
success = json.UpdateBool("items[0].update.destinationOidcCredentials.setNull",1)
success = json.UpdateBool("items[0].update.sourceApiKey.setNull",0)
success = json.UpdateBool("items[0].update.destinationApiKey.setNull",1)
success = json.UpdateBool("items[0].update.isPublic.set",0)
success = json.UpdateBool("items[0].update.ignoreNullFields.set",1)
success = json.UpdateInt("items[0].id",-68015575)
success = json.UpdateString("items[1].update.name.set","ea fugia")
success = json.UpdateString("items[1].update.destination.set.type","dolor")
success = json.UpdateString("items[1].update.destination.set.database","ex fugiat veniam")
success = json.UpdateString("items[1].update.destination.set.table","incididunt dolor voluptate")
success = json.UpdateString("items[1].update.conflictMode.set","in in sunt")
success = json.UpdateString("items[1].update.query.set","a")
success = json.UpdateString("items[1].update.sourceOidcCredentials.set.clientId","aliqua in")
success = json.UpdateString("items[1].update.sourceOidcCredentials.set.clientSecret","sit amet")
success = json.UpdateString("items[1].update.sourceOidcCredentials.set.scopes","deserunt id culpa labore")
success = json.UpdateString("items[1].update.sourceOidcCredentials.set.tokenUri","elit")
success = json.UpdateString("items[1].update.sourceOidcCredentials.set.cdfProjectName","nostrud aliqua")
success = json.UpdateString("items[1].update.sourceOidcCredentials.set.audience","in sunt mollit labore laboris")
success = json.UpdateBool("items[1].update.destinationOidcCredentials.setNull",0)
success = json.UpdateBool("items[1].update.sourceApiKey.setNull",0)
success = json.UpdateBool("items[1].update.destinationApiKey.setNull",1)
success = json.UpdateBool("items[1].update.isPublic.set",1)
success = json.UpdateBool("items[1].update.ignoreNullFields.set",1)
success = json.UpdateString("items[1].externalId","et ut amet quis deserunt")

http.SetRequestHeader "content-type","application/json"
http.SetRequestHeader "api-key","{{api-key}}"

Dim resp As ChilkatHttpResponse
Set resp = http.PostJson3("https://domain.com/api/v1/projects/{{project}}/transformations/update","application/json",json)
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print resp.StatusCode
Debug.Print resp.BodyStr

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}"
    }
  }
}