Chilkat Online Tools

Foxpro / Cognite API v1 / Aggregate files

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
LOCAL loResp

* 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')
loHttp = 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": "irure sed",
*     "directoryPrefix": "nostrud consequat",
*     "mimeType": "dolor laborum in in",
*     "metadata": {},
*     "assetIds": [
*       7799666741900608,
*       6644214122015698
*     ],
*     "assetExternalIds": [
*       "quis voluptate laborum veniam",
*       "aute ut"
*     ],
*     "rootAssetIds": [
*       {
*         "id": 6254098074953880
*       },
*       {
*         "id": 8976017818812302
*       }
*     ],
*     "dataSetIds": [
*       {
*         "externalId": "aliquip pariatur culpa cillum laborum"
*       },
*       {
*         "id": 7695765338479954
*       }
*     ],
*     "assetSubtreeIds": [
*       {
*         "externalId": "Ut amet ex cillum"
*       },
*       {
*         "externalId": "sint"
*       }
*     ],
*     "source": "aute Ut",
*     "createdTime": {
*       "max": 56270544,
*       "min": 57758894
*     },
*     "lastUpdatedTime": {
*       "max": 52283870,
*       "min": 91808195
*     },
*     "uploadedTime": {
*       "max": 26896230,
*       "min": 27790663
*     },
*     "sourceCreatedTime": {
*       "max": 2593079,
*       "min": 10226586
*     },
*     "sourceModifiedTime": {
*       "max": 74076542,
*       "min": 32817651
*     },
*     "externalIdPrefix": "aliqua eu adipisicing",
*     "uploaded": false,
*     "labels": {
*       "containsAny": [
*         {
*           "externalId": "ad aute cupidatat mollit"
*         },
*         {
*           "externalId": "ex Duis sit"
*         }
*       ]
*     },
*     "geoLocation": {
*       "relation": "INTERSECTS",
*       "shape": {
*         "type": "Polygon",
*         "coordinates": [
*         ]
*       }
*     }
*   }
* }

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("filter.name","irure sed")
loJson.UpdateString("filter.directoryPrefix","nostrud consequat")
loJson.UpdateString("filter.mimeType","dolor laborum in in")
loJson.UpdateNewObject("filter.metadata")
loJson.UpdateInt("filter.assetIds[0]",7799666741900608)
loJson.UpdateInt("filter.assetIds[1]",6644214122015698)
loJson.UpdateString("filter.assetExternalIds[0]","quis voluptate laborum veniam")
loJson.UpdateString("filter.assetExternalIds[1]","aute ut")
loJson.UpdateInt("filter.rootAssetIds[0].id",123)
loJson.UpdateInt("filter.rootAssetIds[1].id",123)
loJson.UpdateString("filter.dataSetIds[0].externalId","aliquip pariatur culpa cillum laborum")
loJson.UpdateInt("filter.dataSetIds[1].id",123)
loJson.UpdateString("filter.assetSubtreeIds[0].externalId","Ut amet ex cillum")
loJson.UpdateString("filter.assetSubtreeIds[1].externalId","sint")
loJson.UpdateString("filter.source","aute Ut")
loJson.UpdateInt("filter.createdTime.max",56270544)
loJson.UpdateInt("filter.createdTime.min",57758894)
loJson.UpdateInt("filter.lastUpdatedTime.max",52283870)
loJson.UpdateInt("filter.lastUpdatedTime.min",91808195)
loJson.UpdateInt("filter.uploadedTime.max",26896230)
loJson.UpdateInt("filter.uploadedTime.min",27790663)
loJson.UpdateInt("filter.sourceCreatedTime.max",2593079)
loJson.UpdateInt("filter.sourceCreatedTime.min",10226586)
loJson.UpdateInt("filter.sourceModifiedTime.max",74076542)
loJson.UpdateInt("filter.sourceModifiedTime.min",32817651)
loJson.UpdateString("filter.externalIdPrefix","aliqua eu adipisicing")
loJson.UpdateBool("filter.uploaded",0)
loJson.UpdateString("filter.labels.containsAny[0].externalId","ad aute cupidatat mollit")
loJson.UpdateString("filter.labels.containsAny[1].externalId","ex Duis sit")
loJson.UpdateString("filter.geoLocation.relation","INTERSECTS")
loJson.UpdateString("filter.geoLocation.shape.type","Polygon")
loJson.UpdateNewArray("filter.geoLocation.shape.coordinates")

loHttp.SetRequestHeader("content-type","application/json")
loHttp.SetRequestHeader("api-key","{{api-key}}")

loResp = loHttp.PostJson3("https://domain.com/api/v1/projects/{{project}}/files/aggregate","application/json",loJson)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJson
    CANCEL
ENDIF

? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loResp

RELEASE loHttp
RELEASE loJson

Curl Command

curl -X POST
	-H "api-key: {{api-key}}"
	-H "content-type: application/json"
	-d '{
    "filter": {
        "name": "irure sed",
        "directoryPrefix": "nostrud consequat",
        "mimeType": "dolor laborum in in",
        "metadata": {},
        "assetIds": [
            7799666741900608,
            6644214122015698
        ],
        "assetExternalIds": [
            "quis voluptate laborum veniam",
            "aute ut"
        ],
        "rootAssetIds": [
            {
                "id": 6254098074953880
            },
            {
                "id": 8976017818812302
            }
        ],
        "dataSetIds": [
            {
                "externalId": "aliquip pariatur culpa cillum laborum"
            },
            {
                "id": 7695765338479954
            }
        ],
        "assetSubtreeIds": [
            {
                "externalId": "Ut amet ex cillum"
            },
            {
                "externalId": "sint"
            }
        ],
        "source": "aute Ut",
        "createdTime": {
            "max": 56270544,
            "min": 57758894
        },
        "lastUpdatedTime": {
            "max": 52283870,
            "min": 91808195
        },
        "uploadedTime": {
            "max": 26896230,
            "min": 27790663
        },
        "sourceCreatedTime": {
            "max": 2593079,
            "min": 10226586
        },
        "sourceModifiedTime": {
            "max": 74076542,
            "min": 32817651
        },
        "externalIdPrefix": "aliqua eu adipisicing",
        "uploaded": false,
        "labels": {
            "containsAny": [
                {
                    "externalId": "ad aute cupidatat mollit"
                },
                {
                    "externalId": "ex Duis sit"
                }
            ]
        },
        "geoLocation": {
            "relation": "INTERSECTS",
            "shape": {
                "type": "Polygon",
                "coordinates": []
            }
        }
    }
}'
https://domain.com/api/v1/projects/{{project}}/files/aggregate

Postman Collection Item JSON

{
  "id": "aggregateFiles",
  "name": "Aggregate files",
  "request": {
    "url": {
      "host": "{{baseUrl}}",
      "path": [
        "api",
        "v1",
        "projects",
        "{{project}}",
        "files",
        "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": "Calculate aggregates for files, based on optional filter specification. Returns the following aggregates: `count`",
    "body": {
      "mode": "raw",
      "raw": "{\n    \"filter\": {\n        \"name\": \"irure sed\",\n        \"directoryPrefix\": \"nostrud consequat\",\n        \"mimeType\": \"dolor laborum in in\",\n        \"metadata\": {},\n        \"assetIds\": [\n            7799666741900608,\n            6644214122015698\n        ],\n        \"assetExternalIds\": [\n            \"quis voluptate laborum veniam\",\n            \"aute ut\"\n        ],\n        \"rootAssetIds\": [\n            {\n                \"id\": 6254098074953880\n            },\n            {\n                \"id\": 8976017818812302\n            }\n        ],\n        \"dataSetIds\": [\n            {\n                \"externalId\": \"aliquip pariatur culpa cillum laborum\"\n            },\n            {\n                \"id\": 7695765338479954\n            }\n        ],\n        \"assetSubtreeIds\": [\n            {\n                \"externalId\": \"Ut amet ex cillum\"\n            },\n            {\n                \"externalId\": \"sint\"\n            }\n        ],\n        \"source\": \"aute Ut\",\n        \"createdTime\": {\n            \"max\": 56270544,\n            \"min\": 57758894\n        },\n        \"lastUpdatedTime\": {\n            \"max\": 52283870,\n            \"min\": 91808195\n        },\n        \"uploadedTime\": {\n            \"max\": 26896230,\n            \"min\": 27790663\n        },\n        \"sourceCreatedTime\": {\n            \"max\": 2593079,\n            \"min\": 10226586\n        },\n        \"sourceModifiedTime\": {\n            \"max\": 74076542,\n            \"min\": 32817651\n        },\n        \"externalIdPrefix\": \"aliqua eu adipisicing\",\n        \"uploaded\": false,\n        \"labels\": {\n            \"containsAny\": [\n                {\n                    \"externalId\": \"ad aute cupidatat mollit\"\n                },\n                {\n                    \"externalId\": \"ex Duis sit\"\n                }\n            ]\n        },\n        \"geoLocation\": {\n            \"relation\": \"INTERSECTS\",\n            \"shape\": {\n                \"type\": \"Polygon\",\n                \"coordinates\": []\n            }\n        }\n    }\n}"
    }
  }
}