Chilkat Online Tools

Classic ASP / Cognite API v1 / Update relationships

Back to Collection Items

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' 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 = Server.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 = Server.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
    Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>"
    Response.End
End If

Response.Write "<pre>" & Server.HTMLEncode( resp.StatusCode) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( resp.BodyStr) & "</pre>"


%>
</body>
</html>

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