Foxpro / Cognite API v1 / Filter all events
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": {
* "startTime": {
* "max": 96423541,
* "min": 708508
* },
* "endTime": {
* "isNull": false
* },
* "activeAtTime": {
* "max": 42601793,
* "min": 6545191
* },
* "metadata": {},
* "assetIds": [
* 5846331094676668,
* 3408965310215146
* ],
* "assetExternalIds": [
* "deserunt aliquip Ut occaecat in",
* "non o"
* ],
* "rootAssetIds": [
* {
* "externalId": "veniam commodo minim Duis ut"
* },
* {
* "id": 2472341704760768
* }
* ],
* "assetSubtreeIds": [
* {
* "id": 6194248735806298
* },
* {
* "externalId": "adipisicing"
* }
* ],
* "dataSetIds": [
* {
* "externalId": "commodo nisi"
* },
* {
* "id": 4778982098206896
* }
* ],
* "source": "incididunt",
* "type": "in occaecat",
* "subtype": "dolore minim ipsum",
* "createdTime": {
* "max": 75538890,
* "min": 51111895
* },
* "lastUpdatedTime": {
* "max": 31243942,
* "min": 56817666
* },
* "externalIdPrefix": "cillum"
* },
* "limit": 100,
* "sort": [
* ],
* "cursor": "laborum officia ullamco e",
* "partition": "elit velit"
* }
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateInt("filter.startTime.max",96423541)
loJson.UpdateInt("filter.startTime.min",708508)
loJson.UpdateBool("filter.endTime.isNull",0)
loJson.UpdateInt("filter.activeAtTime.max",42601793)
loJson.UpdateInt("filter.activeAtTime.min",6545191)
loJson.UpdateNewObject("filter.metadata")
loJson.UpdateInt("filter.assetIds[0]",5846331094676668)
loJson.UpdateInt("filter.assetIds[1]",3408965310215146)
loJson.UpdateString("filter.assetExternalIds[0]","deserunt aliquip Ut occaecat in")
loJson.UpdateString("filter.assetExternalIds[1]","non o")
loJson.UpdateString("filter.rootAssetIds[0].externalId","veniam commodo minim Duis ut")
loJson.UpdateInt("filter.rootAssetIds[1].id",123)
loJson.UpdateInt("filter.assetSubtreeIds[0].id",123)
loJson.UpdateString("filter.assetSubtreeIds[1].externalId","adipisicing")
loJson.UpdateString("filter.dataSetIds[0].externalId","commodo nisi")
loJson.UpdateInt("filter.dataSetIds[1].id",123)
loJson.UpdateString("filter.source","incididunt")
loJson.UpdateString("filter.type","in occaecat")
loJson.UpdateString("filter.subtype","dolore minim ipsum")
loJson.UpdateInt("filter.createdTime.max",75538890)
loJson.UpdateInt("filter.createdTime.min",51111895)
loJson.UpdateInt("filter.lastUpdatedTime.max",31243942)
loJson.UpdateInt("filter.lastUpdatedTime.min",56817666)
loJson.UpdateString("filter.externalIdPrefix","cillum")
loJson.UpdateInt("limit",100)
loJson.UpdateNewArray("sort")
loJson.UpdateString("cursor","laborum officia ullamco e")
loJson.UpdateString("partition","elit velit")
loHttp.SetRequestHeader("content-type","application/json")
loHttp.SetRequestHeader("api-key","{{api-key}}")
loResp = loHttp.PostJson3("https://domain.com/api/v1/projects/{{project}}/events/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": {
"startTime": {
"max": 96423541,
"min": 708508
},
"endTime": {
"isNull": false
},
"activeAtTime": {
"max": 42601793,
"min": 6545191
},
"metadata": {},
"assetIds": [
5846331094676668,
3408965310215146
],
"assetExternalIds": [
"deserunt aliquip Ut occaecat in",
"non o"
],
"rootAssetIds": [
{
"externalId": "veniam commodo minim Duis ut"
},
{
"id": 2472341704760768
}
],
"assetSubtreeIds": [
{
"id": 6194248735806298
},
{
"externalId": "adipisicing"
}
],
"dataSetIds": [
{
"externalId": "commodo nisi"
},
{
"id": 4778982098206896
}
],
"source": "incididunt",
"type": "in occaecat",
"subtype": "dolore minim ipsum",
"createdTime": {
"max": 75538890,
"min": 51111895
},
"lastUpdatedTime": {
"max": 31243942,
"min": 56817666
},
"externalIdPrefix": "cillum"
},
"limit": 100,
"sort": [],
"cursor": "laborum officia ullamco e",
"partition": "elit velit"
}'
https://domain.com/api/v1/projects/{{project}}/events/list
Postman Collection Item JSON
{
"id": "advancedListEvents",
"name": "Filter all events",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"events",
"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": "Retrieve a list of all events in the same project. This operation supports pagination by cursor. Criteria can be applied to select a subset of events.",
"body": {
"mode": "raw",
"raw": "{\n \"filter\": {\n \"startTime\": {\n \"max\": 96423541,\n \"min\": 708508\n },\n \"endTime\": {\n \"isNull\": false\n },\n \"activeAtTime\": {\n \"max\": 42601793,\n \"min\": 6545191\n },\n \"metadata\": {},\n \"assetIds\": [\n 5846331094676668,\n 3408965310215146\n ],\n \"assetExternalIds\": [\n \"deserunt aliquip Ut occaecat in\",\n \"non o\"\n ],\n \"rootAssetIds\": [\n {\n \"externalId\": \"veniam commodo minim Duis ut\"\n },\n {\n \"id\": 2472341704760768\n }\n ],\n \"assetSubtreeIds\": [\n {\n \"id\": 6194248735806298\n },\n {\n \"externalId\": \"adipisicing\"\n }\n ],\n \"dataSetIds\": [\n {\n \"externalId\": \"commodo nisi\"\n },\n {\n \"id\": 4778982098206896\n }\n ],\n \"source\": \"incididunt\",\n \"type\": \"in occaecat\",\n \"subtype\": \"dolore minim ipsum\",\n \"createdTime\": {\n \"max\": 75538890,\n \"min\": 51111895\n },\n \"lastUpdatedTime\": {\n \"max\": 31243942,\n \"min\": 56817666\n },\n \"externalIdPrefix\": \"cillum\"\n },\n \"limit\": 100,\n \"sort\": [],\n \"cursor\": \"laborum officia ullamco e\",\n \"partition\": \"elit velit\"\n}"
}
}
}
