Foxpro / Cognite API v1 / Update relationships
Back to Collection Items
LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
LOCAL loResp
* 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')
loHttp = 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')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("items[0].externalId","dolor amet sit")
loJson.UpdateString("items[0].update.sourceType.set","timeSeries")
loJson.UpdateString("items[0].update.sourceExternalId.set","qui labor")
loJson.UpdateString("items[0].update.targetType.set","file")
loJson.UpdateString("items[0].update.targetExternalId.set","laborum")
loJson.UpdateBool("items[0].update.confidence.setNull",1)
loJson.UpdateInt("items[0].update.startTime.set",97867670)
loJson.UpdateBool("items[0].update.endTime.setNull",1)
loJson.UpdateInt("items[0].update.dataSetId.set",123)
loJson.UpdateString("items[0].update.labels.set[0].externalId","ullamco anim")
loJson.UpdateString("items[0].update.labels.set[1].externalId","aliquip ut")
loJson.UpdateString("items[1].externalId","reprehenderit ut")
loJson.UpdateString("items[1].update.sourceType.set","timeSeries")
loJson.UpdateString("items[1].update.sourceExternalId.set","adipisicing ullamco consequat")
loJson.UpdateString("items[1].update.targetType.set","sequence")
loJson.UpdateString("items[1].update.targetExternalId.set","aliqua")
loJson.UpdateBool("items[1].update.confidence.setNull",1)
loJson.UpdateBool("items[1].update.startTime.setNull",0)
loJson.UpdateInt("items[1].update.endTime.set",51106464)
loJson.UpdateBool("items[1].update.dataSetId.setNull",0)
loJson.UpdateString("items[1].update.labels.set[0].externalId","Lorem ipsum")
loJson.UpdateString("items[1].update.labels.set[1].externalId","officia consectetur pariatur")
loHttp.SetRequestHeader("content-type","application/json")
loHttp.SetRequestHeader("api-key","{{api-key}}")
loResp = loHttp.PostJson3("https://domain.com/api/v1/projects/{{project}}/relationships/update","application/json",loJson)
IF (loHttp.LastMethodSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loJson
CANCEL
ENDIF
? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loResp
RELEASE loHttp
RELEASE loJson
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}"
}
}
}
