PowerBuilder / Cognite API v1 / Filter all events
Back to Collection Items
integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_Resp
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
destroy loo_Http
MessageBox("Error","Connecting to COM object failed")
return
end if
// 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"
// }
loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")
loo_Json.UpdateInt("filter.startTime.max",96423541)
loo_Json.UpdateInt("filter.startTime.min",708508)
loo_Json.UpdateBool("filter.endTime.isNull",0)
loo_Json.UpdateInt("filter.activeAtTime.max",42601793)
loo_Json.UpdateInt("filter.activeAtTime.min",6545191)
loo_Json.UpdateNewObject("filter.metadata")
loo_Json.UpdateInt("filter.assetIds[0]",5846331094676668)
loo_Json.UpdateInt("filter.assetIds[1]",3408965310215146)
loo_Json.UpdateString("filter.assetExternalIds[0]","deserunt aliquip Ut occaecat in")
loo_Json.UpdateString("filter.assetExternalIds[1]","non o")
loo_Json.UpdateString("filter.rootAssetIds[0].externalId","veniam commodo minim Duis ut")
loo_Json.UpdateInt("filter.rootAssetIds[1].id",123)
loo_Json.UpdateInt("filter.assetSubtreeIds[0].id",123)
loo_Json.UpdateString("filter.assetSubtreeIds[1].externalId","adipisicing")
loo_Json.UpdateString("filter.dataSetIds[0].externalId","commodo nisi")
loo_Json.UpdateInt("filter.dataSetIds[1].id",123)
loo_Json.UpdateString("filter.source","incididunt")
loo_Json.UpdateString("filter.type","in occaecat")
loo_Json.UpdateString("filter.subtype","dolore minim ipsum")
loo_Json.UpdateInt("filter.createdTime.max",75538890)
loo_Json.UpdateInt("filter.createdTime.min",51111895)
loo_Json.UpdateInt("filter.lastUpdatedTime.max",31243942)
loo_Json.UpdateInt("filter.lastUpdatedTime.min",56817666)
loo_Json.UpdateString("filter.externalIdPrefix","cillum")
loo_Json.UpdateInt("limit",100)
loo_Json.UpdateNewArray("sort")
loo_Json.UpdateString("cursor","laborum officia ullamco e")
loo_Json.UpdateString("partition","elit velit")
loo_Http.SetRequestHeader("content-type","application/json")
loo_Http.SetRequestHeader("api-key","{{api-key}}")
loo_Resp = loo_Http.PostJson3("https://domain.com/api/v1/projects/{{project}}/events/list","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
Write-Debug loo_Http.LastErrorText
destroy loo_Http
destroy loo_Json
return
end if
Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp
destroy loo_Http
destroy loo_Json
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}"
}
}
}
