Chilkat Online Tools

PowerBuilder / Cognite API v1 / Aggregate sequences

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": {
//     "name": "officia dolor qui voluptate proident",
//     "externalIdPrefix": "incididunt ipsum dolor in",
//     "metadata": {},
//     "assetIds": [
//       6755940932372078,
//       466388817751490
//     ],
//     "rootAssetIds": [
//       2996959927277534,
//       4434140000089514
//     ],
//     "assetSubtreeIds": [
//       {
//         "externalId": "ullamco irure"
//       },
//       {
//         "externalId": "enim sint occaecat pariatur"
//       }
//     ],
//     "createdTime": {
//       "max": 21259346,
//       "min": 24330159
//     },
//     "lastUpdatedTime": {
//       "max": 20522993,
//       "min": 46705874
//     },
//     "dataSetIds": [
//       {
//         "externalId": "do mollit velit eiusmod sunt"
//       },
//       {
//         "id": 5963974930141452
//       }
//     ]
//   }
// }

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.UpdateString("filter.name","officia dolor qui voluptate proident")
loo_Json.UpdateString("filter.externalIdPrefix","incididunt ipsum dolor in")
loo_Json.UpdateNewObject("filter.metadata")
loo_Json.UpdateInt("filter.assetIds[0]",6755940932372078)
loo_Json.UpdateInt("filter.assetIds[1]",466388817751490)
loo_Json.UpdateInt("filter.rootAssetIds[0]",2996959927277534)
loo_Json.UpdateInt("filter.rootAssetIds[1]",4434140000089514)
loo_Json.UpdateString("filter.assetSubtreeIds[0].externalId","ullamco irure")
loo_Json.UpdateString("filter.assetSubtreeIds[1].externalId","enim sint occaecat pariatur")
loo_Json.UpdateInt("filter.createdTime.max",21259346)
loo_Json.UpdateInt("filter.createdTime.min",24330159)
loo_Json.UpdateInt("filter.lastUpdatedTime.max",20522993)
loo_Json.UpdateInt("filter.lastUpdatedTime.min",46705874)
loo_Json.UpdateString("filter.dataSetIds[0].externalId","do mollit velit eiusmod sunt")
loo_Json.UpdateInt("filter.dataSetIds[1].id",123)

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}}/sequences/aggregate","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": {
        "name": "officia dolor qui voluptate proident",
        "externalIdPrefix": "incididunt ipsum dolor in",
        "metadata": {},
        "assetIds": [
            6755940932372078,
            466388817751490
        ],
        "rootAssetIds": [
            2996959927277534,
            4434140000089514
        ],
        "assetSubtreeIds": [
            {
                "externalId": "ullamco irure"
            },
            {
                "externalId": "enim sint occaecat pariatur"
            }
        ],
        "createdTime": {
            "max": 21259346,
            "min": 24330159
        },
        "lastUpdatedTime": {
            "max": 20522993,
            "min": 46705874
        },
        "dataSetIds": [
            {
                "externalId": "do mollit velit eiusmod sunt"
            },
            {
                "id": 5963974930141452
            }
        ]
    }
}'
https://domain.com/api/v1/projects/{{project}}/sequences/aggregate

Postman Collection Item JSON

{
  "id": "aggregateSequences",
  "name": "Aggregate sequences",
  "request": {
    "url": {
      "host": "{{baseUrl}}",
      "path": [
        "api",
        "v1",
        "projects",
        "{{project}}",
        "sequences",
        "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 sequences that match the given filter",
    "body": {
      "mode": "raw",
      "raw": "{\n    \"filter\": {\n        \"name\": \"officia dolor qui voluptate proident\",\n        \"externalIdPrefix\": \"incididunt ipsum dolor in\",\n        \"metadata\": {},\n        \"assetIds\": [\n            6755940932372078,\n            466388817751490\n        ],\n        \"rootAssetIds\": [\n            2996959927277534,\n            4434140000089514\n        ],\n        \"assetSubtreeIds\": [\n            {\n                \"externalId\": \"ullamco irure\"\n            },\n            {\n                \"externalId\": \"enim sint occaecat pariatur\"\n            }\n        ],\n        \"createdTime\": {\n            \"max\": 21259346,\n            \"min\": 24330159\n        },\n        \"lastUpdatedTime\": {\n            \"max\": 20522993,\n            \"min\": 46705874\n        },\n        \"dataSetIds\": [\n            {\n                \"externalId\": \"do mollit velit eiusmod sunt\"\n            },\n            {\n                \"id\": 5963974930141452\n            }\n        ]\n    }\n}"
    }
  }
}