VBScript / Cognite API v1 / Aggregate time series
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": {
' "name": "et exercitation s",
' "unit": "pariatur esse qui",
' "isString": true,
' "isStep": false,
' "metadata": {},
' "assetIds": [
' 2274246036570026,
' 8922483798410046
' ],
' "assetExternalIds": [
' "proident Ut consequat in",
' "elit incididunt aliqua"
' ],
' "rootAssetIds": [
' 7714215516056826,
' 4275780546438472
' ],
' "assetSubtreeIds": [
' {
' "id": 7555548287718054
' },
' {
' "externalId": "re"
' }
' ],
' "dataSetIds": [
' {
' "id": 5946532482497628
' },
' {
' "externalId": "exercitation nisi elit"
' }
' ],
' "externalIdPrefix": "aute Ut nostrud commodo in",
' "createdTime": {
' "max": 16041500,
' "min": 71538919
' },
' "lastUpdatedTime": {
' "max": 2438620,
' "min": 18087967
' }
' }
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("filter.name","et exercitation s")
success = json.UpdateString("filter.unit","pariatur esse qui")
success = json.UpdateBool("filter.isString",1)
success = json.UpdateBool("filter.isStep",0)
success = json.UpdateNewObject("filter.metadata")
success = json.UpdateInt("filter.assetIds[0]",2274246036570026)
success = json.UpdateInt("filter.assetIds[1]",8922483798410046)
success = json.UpdateString("filter.assetExternalIds[0]","proident Ut consequat in")
success = json.UpdateString("filter.assetExternalIds[1]","elit incididunt aliqua")
success = json.UpdateInt("filter.rootAssetIds[0]",7714215516056826)
success = json.UpdateInt("filter.rootAssetIds[1]",4275780546438472)
success = json.UpdateInt("filter.assetSubtreeIds[0].id",123)
success = json.UpdateString("filter.assetSubtreeIds[1].externalId","re")
success = json.UpdateInt("filter.dataSetIds[0].id",123)
success = json.UpdateString("filter.dataSetIds[1].externalId","exercitation nisi elit")
success = json.UpdateString("filter.externalIdPrefix","aute Ut nostrud commodo in")
success = json.UpdateInt("filter.createdTime.max",16041500)
success = json.UpdateInt("filter.createdTime.min",71538919)
success = json.UpdateInt("filter.lastUpdatedTime.max",2438620)
success = json.UpdateInt("filter.lastUpdatedTime.min",18087967)
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}}/timeseries/aggregate","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": {
"name": "et exercitation s",
"unit": "pariatur esse qui",
"isString": true,
"isStep": false,
"metadata": {},
"assetIds": [
2274246036570026,
8922483798410046
],
"assetExternalIds": [
"proident Ut consequat in",
"elit incididunt aliqua"
],
"rootAssetIds": [
7714215516056826,
4275780546438472
],
"assetSubtreeIds": [
{
"id": 7555548287718054
},
{
"externalId": "re"
}
],
"dataSetIds": [
{
"id": 5946532482497628
},
{
"externalId": "exercitation nisi elit"
}
],
"externalIdPrefix": "aute Ut nostrud commodo in",
"createdTime": {
"max": 16041500,
"min": 71538919
},
"lastUpdatedTime": {
"max": 2438620,
"min": 18087967
}
}
}'
https://domain.com/api/v1/projects/{{project}}/timeseries/aggregate
Postman Collection Item JSON
{
"id": "aggregateTimeSeries",
"name": "Aggregate time series",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"timeseries",
"aggregate"
],
"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": "Count the number of time series that match the given filter",
"body": {
"mode": "raw",
"raw": "{\n \"filter\": {\n \"name\": \"et exercitation s\",\n \"unit\": \"pariatur esse qui\",\n \"isString\": true,\n \"isStep\": false,\n \"metadata\": {},\n \"assetIds\": [\n 2274246036570026,\n 8922483798410046\n ],\n \"assetExternalIds\": [\n \"proident Ut consequat in\",\n \"elit incididunt aliqua\"\n ],\n \"rootAssetIds\": [\n 7714215516056826,\n 4275780546438472\n ],\n \"assetSubtreeIds\": [\n {\n \"id\": 7555548287718054\n },\n {\n \"externalId\": \"re\"\n }\n ],\n \"dataSetIds\": [\n {\n \"id\": 5946532482497628\n },\n {\n \"externalId\": \"exercitation nisi elit\"\n }\n ],\n \"externalIdPrefix\": \"aute Ut nostrud commodo in\",\n \"createdTime\": {\n \"max\": 16041500,\n \"min\": 71538919\n },\n \"lastUpdatedTime\": {\n \"max\": 2438620,\n \"min\": 18087967\n }\n }\n}"
}
}
}
