Foxpro / Cognite API v1 / Filter 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.
* {
* "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')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("filter.sourceExternalIds[0]","culpa esse veniam nisi")
loJson.UpdateString("filter.sourceExternalIds[1]","commodo repr")
loJson.UpdateString("filter.sourceTypes[0]","timeSeries")
loJson.UpdateString("filter.sourceTypes[1]","sequence")
loJson.UpdateString("filter.targetExternalIds[0]","exercitation")
loJson.UpdateString("filter.targetExternalIds[1]","enim culpa")
loJson.UpdateString("filter.targetTypes[0]","sequence")
loJson.UpdateString("filter.targetTypes[1]","timeSeries")
loJson.UpdateInt("filter.dataSetIds[0].id",123)
loJson.UpdateString("filter.dataSetIds[1].externalId","aliquip non")
loJson.UpdateInt("filter.startTime.max",15446345)
loJson.UpdateInt("filter.startTime.min",52529591)
loJson.UpdateInt("filter.endTime.max",94684273)
loJson.UpdateInt("filter.endTime.min",31959617)
loJson.UpdateNumber("filter.confidence.min","62943472.11126715")
loJson.UpdateNumber("filter.confidence.max","33071678.92549883")
loJson.UpdateInt("filter.lastUpdatedTime.max",64148230)
loJson.UpdateInt("filter.lastUpdatedTime.min",15602664)
loJson.UpdateInt("filter.createdTime.max",99622074)
loJson.UpdateInt("filter.createdTime.min",32696551)
loJson.UpdateInt("filter.activeAtTime.max",99890540)
loJson.UpdateInt("filter.activeAtTime.min",14084932)
loJson.UpdateString("filter.labels.containsAny[0].externalId","et Lorem cupidatat amet")
loJson.UpdateString("filter.labels.containsAny[1].externalId","aliqua")
loJson.UpdateString("filter.sourcesOrTargets[0].type","sequence")
loJson.UpdateString("filter.sourcesOrTargets[0].externalId","consequat id")
loJson.UpdateInt("limit",100)
loJson.UpdateString("cursor","non do Excepteur dolor")
loJson.UpdateBool("fetchResources",0)
loJson.UpdateString("partition","laborum id ad cupidatat et")
loHttp.SetRequestHeader("content-type","application/json")
loHttp.SetRequestHeader("api-key","{{api-key}}")
loResp = loHttp.PostJson3("https://domain.com/api/v1/projects/{{project}}/relationships/list","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 '{
"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}"
}
}
}
