DataFlex / Cognite API v1 / Filter all events
Back to Collection Items
Use ChilkatAx-win32.pkg
Procedure Test
Handle hoHttp
Boolean iSuccess
Variant vJson
Handle hoJson
Variant vResp
Handle hoResp
String sTemp1
Integer iTemp1
Boolean bTemp1
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
// 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"
// }
Get Create (RefClass(cComChilkatJsonObject)) To hoJson
If (Not(IsComObjectCreated(hoJson))) Begin
Send CreateComObject of hoJson
End
Get ComUpdateInt Of hoJson "filter.startTime.max" 96423541 To iSuccess
Get ComUpdateInt Of hoJson "filter.startTime.min" 708508 To iSuccess
Get ComUpdateBool Of hoJson "filter.endTime.isNull" False To iSuccess
Get ComUpdateInt Of hoJson "filter.activeAtTime.max" 42601793 To iSuccess
Get ComUpdateInt Of hoJson "filter.activeAtTime.min" 6545191 To iSuccess
Get ComUpdateNewObject Of hoJson "filter.metadata" To iSuccess
Get ComUpdateInt Of hoJson "filter.assetIds[0]" 5846331094676668 To iSuccess
Get ComUpdateInt Of hoJson "filter.assetIds[1]" 3408965310215146 To iSuccess
Get ComUpdateString Of hoJson "filter.assetExternalIds[0]" "deserunt aliquip Ut occaecat in" To iSuccess
Get ComUpdateString Of hoJson "filter.assetExternalIds[1]" "non o" To iSuccess
Get ComUpdateString Of hoJson "filter.rootAssetIds[0].externalId" "veniam commodo minim Duis ut" To iSuccess
Get ComUpdateInt Of hoJson "filter.rootAssetIds[1].id" 123 To iSuccess
Get ComUpdateInt Of hoJson "filter.assetSubtreeIds[0].id" 123 To iSuccess
Get ComUpdateString Of hoJson "filter.assetSubtreeIds[1].externalId" "adipisicing" To iSuccess
Get ComUpdateString Of hoJson "filter.dataSetIds[0].externalId" "commodo nisi" To iSuccess
Get ComUpdateInt Of hoJson "filter.dataSetIds[1].id" 123 To iSuccess
Get ComUpdateString Of hoJson "filter.source" "incididunt" To iSuccess
Get ComUpdateString Of hoJson "filter.type" "in occaecat" To iSuccess
Get ComUpdateString Of hoJson "filter.subtype" "dolore minim ipsum" To iSuccess
Get ComUpdateInt Of hoJson "filter.createdTime.max" 75538890 To iSuccess
Get ComUpdateInt Of hoJson "filter.createdTime.min" 51111895 To iSuccess
Get ComUpdateInt Of hoJson "filter.lastUpdatedTime.max" 31243942 To iSuccess
Get ComUpdateInt Of hoJson "filter.lastUpdatedTime.min" 56817666 To iSuccess
Get ComUpdateString Of hoJson "filter.externalIdPrefix" "cillum" To iSuccess
Get ComUpdateInt Of hoJson "limit" 100 To iSuccess
Get ComUpdateNewArray Of hoJson "sort" To iSuccess
Get ComUpdateString Of hoJson "cursor" "laborum officia ullamco e" To iSuccess
Get ComUpdateString Of hoJson "partition" "elit velit" To iSuccess
Send ComSetRequestHeader To hoHttp "content-type" "application/json"
Send ComSetRequestHeader To hoHttp "api-key" "{{api-key}}"
Get pvComObject of hoJson to vJson
Get ComPostJson3 Of hoHttp "https://domain.com/api/v1/projects/{{project}}/events/list" "application/json" vJson To vResp
If (IsComObject(vResp)) Begin
Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
Set pvComObject Of hoResp To vResp
End
Get ComLastMethodSuccess Of hoHttp To bTemp1
If (bTemp1 = False) Begin
Get ComLastErrorText Of hoHttp To sTemp1
Showln sTemp1
Procedure_Return
End
Get ComStatusCode Of hoResp To iTemp1
Showln iTemp1
Get ComBodyStr Of hoResp To sTemp1
Showln sTemp1
Send Destroy of hoResp
End_Procedure
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}"
}
}
}
