PowerBuilder / Cognite API v1 / Update relationships
Back to Collection Items
integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_Resp
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.Http")
if li_rc < 0 then
destroy loo_Http
MessageBox("Error","Connecting to COM object failed")
return
end if
// 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"
// }
// ]
// }
// }
// }
// ]
// }
loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_Json.UpdateString("items[0].externalId","dolor amet sit")
loo_Json.UpdateString("items[0].update.sourceType.set","timeSeries")
loo_Json.UpdateString("items[0].update.sourceExternalId.set","qui labor")
loo_Json.UpdateString("items[0].update.targetType.set","file")
loo_Json.UpdateString("items[0].update.targetExternalId.set","laborum")
loo_Json.UpdateBool("items[0].update.confidence.setNull",1)
loo_Json.UpdateInt("items[0].update.startTime.set",97867670)
loo_Json.UpdateBool("items[0].update.endTime.setNull",1)
loo_Json.UpdateInt("items[0].update.dataSetId.set",123)
loo_Json.UpdateString("items[0].update.labels.set[0].externalId","ullamco anim")
loo_Json.UpdateString("items[0].update.labels.set[1].externalId","aliquip ut")
loo_Json.UpdateString("items[1].externalId","reprehenderit ut")
loo_Json.UpdateString("items[1].update.sourceType.set","timeSeries")
loo_Json.UpdateString("items[1].update.sourceExternalId.set","adipisicing ullamco consequat")
loo_Json.UpdateString("items[1].update.targetType.set","sequence")
loo_Json.UpdateString("items[1].update.targetExternalId.set","aliqua")
loo_Json.UpdateBool("items[1].update.confidence.setNull",1)
loo_Json.UpdateBool("items[1].update.startTime.setNull",0)
loo_Json.UpdateInt("items[1].update.endTime.set",51106464)
loo_Json.UpdateBool("items[1].update.dataSetId.setNull",0)
loo_Json.UpdateString("items[1].update.labels.set[0].externalId","Lorem ipsum")
loo_Json.UpdateString("items[1].update.labels.set[1].externalId","officia consectetur pariatur")
loo_Http.SetRequestHeader("content-type","application/json")
loo_Http.SetRequestHeader("api-key","{{api-key}}")
loo_Resp = loo_Http.PostJson3("https://domain.com/api/v1/projects/{{project}}/relationships/update","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
Write-Debug loo_Http.LastErrorText
destroy loo_Http
destroy loo_Json
return
end if
Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp
destroy loo_Http
destroy loo_Json
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}"
}
}
}
