VBScript / Cognite API v1 / Update relationships
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": [
' {
' "externalId": "dolor amet sit",
' "update": {
' "sourceType": {
' "set": "timeSeries"
' },
' "sourceExternalId": {
' "set": "qui labor"
' },
' "targetType": {
' "set": "file"
' },
' "targetExternalId": {
' "set": "laborum"
' },
' "confidence": {
' "setNull": true
' },
' "startTime": {
' "set": 97867670
' },
' "endTime": {
' "setNull": true
' },
' "dataSetId": {
' "set": 8379377116294748
' },
' "labels": {
' "set": [
' {
' "externalId": "ullamco anim"
' },
' {
' "externalId": "aliquip ut"
' }
' ]
' }
' }
' },
' {
' "externalId": "reprehenderit ut",
' "update": {
' "sourceType": {
' "set": "timeSeries"
' },
' "sourceExternalId": {
' "set": "adipisicing ullamco consequat"
' },
' "targetType": {
' "set": "sequence"
' },
' "targetExternalId": {
' "set": "aliqua"
' },
' "confidence": {
' "setNull": true
' },
' "startTime": {
' "setNull": false
' },
' "endTime": {
' "set": 51106464
' },
' "dataSetId": {
' "setNull": false
' },
' "labels": {
' "set": [
' {
' "externalId": "Lorem ipsum"
' },
' {
' "externalId": "officia consectetur pariatur"
' }
' ]
' }
' }
' }
' ]
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("items[0].externalId","dolor amet sit")
success = json.UpdateString("items[0].update.sourceType.set","timeSeries")
success = json.UpdateString("items[0].update.sourceExternalId.set","qui labor")
success = json.UpdateString("items[0].update.targetType.set","file")
success = json.UpdateString("items[0].update.targetExternalId.set","laborum")
success = json.UpdateBool("items[0].update.confidence.setNull",1)
success = json.UpdateInt("items[0].update.startTime.set",97867670)
success = json.UpdateBool("items[0].update.endTime.setNull",1)
success = json.UpdateInt("items[0].update.dataSetId.set",123)
success = json.UpdateString("items[0].update.labels.set[0].externalId","ullamco anim")
success = json.UpdateString("items[0].update.labels.set[1].externalId","aliquip ut")
success = json.UpdateString("items[1].externalId","reprehenderit ut")
success = json.UpdateString("items[1].update.sourceType.set","timeSeries")
success = json.UpdateString("items[1].update.sourceExternalId.set","adipisicing ullamco consequat")
success = json.UpdateString("items[1].update.targetType.set","sequence")
success = json.UpdateString("items[1].update.targetExternalId.set","aliqua")
success = json.UpdateBool("items[1].update.confidence.setNull",1)
success = json.UpdateBool("items[1].update.startTime.setNull",0)
success = json.UpdateInt("items[1].update.endTime.set",51106464)
success = json.UpdateBool("items[1].update.dataSetId.setNull",0)
success = json.UpdateString("items[1].update.labels.set[0].externalId","Lorem ipsum")
success = json.UpdateString("items[1].update.labels.set[1].externalId","officia consectetur pariatur")
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}}/relationships/update","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": [
{
"externalId": "dolor amet sit",
"update": {
"sourceType": {
"set": "timeSeries"
},
"sourceExternalId": {
"set": "qui labor"
},
"targetType": {
"set": "file"
},
"targetExternalId": {
"set": "laborum"
},
"confidence": {
"setNull": true
},
"startTime": {
"set": 97867670
},
"endTime": {
"setNull": true
},
"dataSetId": {
"set": 8379377116294748
},
"labels": {
"set": [
{
"externalId": "ullamco anim"
},
{
"externalId": "aliquip ut"
}
]
}
}
},
{
"externalId": "reprehenderit ut",
"update": {
"sourceType": {
"set": "timeSeries"
},
"sourceExternalId": {
"set": "adipisicing ullamco consequat"
},
"targetType": {
"set": "sequence"
},
"targetExternalId": {
"set": "aliqua"
},
"confidence": {
"setNull": true
},
"startTime": {
"setNull": false
},
"endTime": {
"set": 51106464
},
"dataSetId": {
"setNull": false
},
"labels": {
"set": [
{
"externalId": "Lorem ipsum"
},
{
"externalId": "officia consectetur pariatur"
}
]
}
}
}
]
}'
https://domain.com/api/v1/projects/{{project}}/relationships/update
Postman Collection Item JSON
{
"id": "updateRelationships",
"name": "Update relationships",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"relationships",
"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 relationships between resources according to the partial definitions of the relationships given in the payload of the request. This means that fields not mentioned in the payload will remain unchanged. Up to 1000 relationships can be updated in one operation.\nTo delete a value from an optional value the `setNull` field should be set to `true`.\nThe order of the updated relationships in the response equals the order in the request.",
"body": {
"mode": "raw",
"raw": "{\n \"items\": [\n {\n \"externalId\": \"dolor amet sit\",\n \"update\": {\n \"sourceType\": {\n \"set\": \"timeSeries\"\n },\n \"sourceExternalId\": {\n \"set\": \"qui labor\"\n },\n \"targetType\": {\n \"set\": \"file\"\n },\n \"targetExternalId\": {\n \"set\": \"laborum\"\n },\n \"confidence\": {\n \"setNull\": true\n },\n \"startTime\": {\n \"set\": 97867670\n },\n \"endTime\": {\n \"setNull\": true\n },\n \"dataSetId\": {\n \"set\": 8379377116294748\n },\n \"labels\": {\n \"set\": [\n {\n \"externalId\": \"ullamco anim\"\n },\n {\n \"externalId\": \"aliquip ut\"\n }\n ]\n }\n }\n },\n {\n \"externalId\": \"reprehenderit ut\",\n \"update\": {\n \"sourceType\": {\n \"set\": \"timeSeries\"\n },\n \"sourceExternalId\": {\n \"set\": \"adipisicing ullamco consequat\"\n },\n \"targetType\": {\n \"set\": \"sequence\"\n },\n \"targetExternalId\": {\n \"set\": \"aliqua\"\n },\n \"confidence\": {\n \"setNull\": true\n },\n \"startTime\": {\n \"setNull\": false\n },\n \"endTime\": {\n \"set\": 51106464\n },\n \"dataSetId\": {\n \"setNull\": false\n },\n \"labels\": {\n \"set\": [\n {\n \"externalId\": \"Lorem ipsum\"\n },\n {\n \"externalId\": \"officia consectetur pariatur\"\n }\n ]\n }\n }\n }\n ]\n}"
}
}
}
