VBScript / Cognite API v1 / Filter all events
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": {
' "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")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateInt("filter.startTime.max",96423541)
success = json.UpdateInt("filter.startTime.min",708508)
success = json.UpdateBool("filter.endTime.isNull",0)
success = json.UpdateInt("filter.activeAtTime.max",42601793)
success = json.UpdateInt("filter.activeAtTime.min",6545191)
success = json.UpdateNewObject("filter.metadata")
success = json.UpdateInt("filter.assetIds[0]",5846331094676668)
success = json.UpdateInt("filter.assetIds[1]",3408965310215146)
success = json.UpdateString("filter.assetExternalIds[0]","deserunt aliquip Ut occaecat in")
success = json.UpdateString("filter.assetExternalIds[1]","non o")
success = json.UpdateString("filter.rootAssetIds[0].externalId","veniam commodo minim Duis ut")
success = json.UpdateInt("filter.rootAssetIds[1].id",123)
success = json.UpdateInt("filter.assetSubtreeIds[0].id",123)
success = json.UpdateString("filter.assetSubtreeIds[1].externalId","adipisicing")
success = json.UpdateString("filter.dataSetIds[0].externalId","commodo nisi")
success = json.UpdateInt("filter.dataSetIds[1].id",123)
success = json.UpdateString("filter.source","incididunt")
success = json.UpdateString("filter.type","in occaecat")
success = json.UpdateString("filter.subtype","dolore minim ipsum")
success = json.UpdateInt("filter.createdTime.max",75538890)
success = json.UpdateInt("filter.createdTime.min",51111895)
success = json.UpdateInt("filter.lastUpdatedTime.max",31243942)
success = json.UpdateInt("filter.lastUpdatedTime.min",56817666)
success = json.UpdateString("filter.externalIdPrefix","cillum")
success = json.UpdateInt("limit",100)
success = json.UpdateNewArray("sort")
success = json.UpdateString("cursor","laborum officia ullamco e")
success = json.UpdateString("partition","elit velit")
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}}/events/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": {
"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}"
}
}
}
