VBScript / Cognite API v1 / Filter 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.
' {
' "filter": {
' "sourceExternalIds": [
' "culpa esse veniam nisi",
' "commodo repr"
' ],
' "sourceTypes": [
' "timeSeries",
' "sequence"
' ],
' "targetExternalIds": [
' "exercitation",
' "enim culpa"
' ],
' "targetTypes": [
' "sequence",
' "timeSeries"
' ],
' "dataSetIds": [
' {
' "id": 6853944784929184
' },
' {
' "externalId": "aliquip non"
' }
' ],
' "startTime": {
' "max": 15446345,
' "min": 52529591
' },
' "endTime": {
' "max": 94684273,
' "min": 31959617
' },
' "confidence": {
' "min": 62943472.11126715,
' "max": 33071678.92549883
' },
' "lastUpdatedTime": {
' "max": 64148230,
' "min": 15602664
' },
' "createdTime": {
' "max": 99622074,
' "min": 32696551
' },
' "activeAtTime": {
' "max": 99890540,
' "min": 14084932
' },
' "labels": {
' "containsAny": [
' {
' "externalId": "et Lorem cupidatat amet"
' },
' {
' "externalId": "aliqua"
' }
' ]
' },
' "sourcesOrTargets": [
' {
' "type": "sequence",
' "externalId": "consequat id"
' }
' ]
' },
' "limit": 100,
' "cursor": "non do Excepteur dolor",
' "fetchResources": false,
' "partition": "laborum id ad cupidatat et"
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("filter.sourceExternalIds[0]","culpa esse veniam nisi")
success = json.UpdateString("filter.sourceExternalIds[1]","commodo repr")
success = json.UpdateString("filter.sourceTypes[0]","timeSeries")
success = json.UpdateString("filter.sourceTypes[1]","sequence")
success = json.UpdateString("filter.targetExternalIds[0]","exercitation")
success = json.UpdateString("filter.targetExternalIds[1]","enim culpa")
success = json.UpdateString("filter.targetTypes[0]","sequence")
success = json.UpdateString("filter.targetTypes[1]","timeSeries")
success = json.UpdateInt("filter.dataSetIds[0].id",123)
success = json.UpdateString("filter.dataSetIds[1].externalId","aliquip non")
success = json.UpdateInt("filter.startTime.max",15446345)
success = json.UpdateInt("filter.startTime.min",52529591)
success = json.UpdateInt("filter.endTime.max",94684273)
success = json.UpdateInt("filter.endTime.min",31959617)
success = json.UpdateNumber("filter.confidence.min","62943472.11126715")
success = json.UpdateNumber("filter.confidence.max","33071678.92549883")
success = json.UpdateInt("filter.lastUpdatedTime.max",64148230)
success = json.UpdateInt("filter.lastUpdatedTime.min",15602664)
success = json.UpdateInt("filter.createdTime.max",99622074)
success = json.UpdateInt("filter.createdTime.min",32696551)
success = json.UpdateInt("filter.activeAtTime.max",99890540)
success = json.UpdateInt("filter.activeAtTime.min",14084932)
success = json.UpdateString("filter.labels.containsAny[0].externalId","et Lorem cupidatat amet")
success = json.UpdateString("filter.labels.containsAny[1].externalId","aliqua")
success = json.UpdateString("filter.sourcesOrTargets[0].type","sequence")
success = json.UpdateString("filter.sourcesOrTargets[0].externalId","consequat id")
success = json.UpdateInt("limit",100)
success = json.UpdateString("cursor","non do Excepteur dolor")
success = json.UpdateBool("fetchResources",0)
success = json.UpdateString("partition","laborum id ad cupidatat et")
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/list","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 '{
"filter": {
"sourceExternalIds": [
"culpa esse veniam nisi",
"commodo repr"
],
"sourceTypes": [
"timeSeries",
"sequence"
],
"targetExternalIds": [
"exercitation",
"enim culpa"
],
"targetTypes": [
"sequence",
"timeSeries"
],
"dataSetIds": [
{
"id": 6853944784929184
},
{
"externalId": "aliquip non"
}
],
"startTime": {
"max": 15446345,
"min": 52529591
},
"endTime": {
"max": 94684273,
"min": 31959617
},
"confidence": {
"min": 62943472.11126715,
"max": 33071678.92549883
},
"lastUpdatedTime": {
"max": 64148230,
"min": 15602664
},
"createdTime": {
"max": 99622074,
"min": 32696551
},
"activeAtTime": {
"max": 99890540,
"min": 14084932
},
"labels": {
"containsAny": [
{
"externalId": "et Lorem cupidatat amet"
},
{
"externalId": "aliqua"
}
]
},
"sourcesOrTargets": [
{
"type": "sequence",
"externalId": "consequat id"
}
]
},
"limit": 100,
"cursor": "non do Excepteur dolor",
"fetchResources": false,
"partition": "laborum id ad cupidatat et"
}'
https://domain.com/api/v1/projects/{{project}}/relationships/list
Postman Collection Item JSON
{
"id": "listRelationships",
"name": "Filter relationships",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"relationships",
"list"
],
"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": "Lists relationships matching the query filter in the request. You can retrieve a maximum of 1000 relationships per request.",
"body": {
"mode": "raw",
"raw": "{\n \"filter\": {\n \"sourceExternalIds\": [\n \"culpa esse veniam nisi\",\n \"commodo repr\"\n ],\n \"sourceTypes\": [\n \"timeSeries\",\n \"sequence\"\n ],\n \"targetExternalIds\": [\n \"exercitation\",\n \"enim culpa\"\n ],\n \"targetTypes\": [\n \"sequence\",\n \"timeSeries\"\n ],\n \"dataSetIds\": [\n {\n \"id\": 6853944784929184\n },\n {\n \"externalId\": \"aliquip non\"\n }\n ],\n \"startTime\": {\n \"max\": 15446345,\n \"min\": 52529591\n },\n \"endTime\": {\n \"max\": 94684273,\n \"min\": 31959617\n },\n \"confidence\": {\n \"min\": 62943472.11126715,\n \"max\": 33071678.92549883\n },\n \"lastUpdatedTime\": {\n \"max\": 64148230,\n \"min\": 15602664\n },\n \"createdTime\": {\n \"max\": 99622074,\n \"min\": 32696551\n },\n \"activeAtTime\": {\n \"max\": 99890540,\n \"min\": 14084932\n },\n \"labels\": {\n \"containsAny\": [\n {\n \"externalId\": \"et Lorem cupidatat amet\"\n },\n {\n \"externalId\": \"aliqua\"\n }\n ]\n },\n \"sourcesOrTargets\": [\n {\n \"type\": \"sequence\",\n \"externalId\": \"consequat id\"\n }\n ]\n },\n \"limit\": 100,\n \"cursor\": \"non do Excepteur dolor\",\n \"fetchResources\": false,\n \"partition\": \"laborum id ad cupidatat et\"\n}"
}
}
}
