Chilkat Online Tools

VBScript / Cognite API v1 / Filter files

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": "ex nostrud consectetur",
'     "directoryPrefix": "tempor laborum ad consectetur",
'     "mimeType": "aute dolor sit Duis",
'     "metadata": {},
'     "assetIds": [
'       467579989120294,
'       8421974867540202
'     ],
'     "assetExternalIds": [
'       "",
'       "sint minim aliqua "
'     ],
'     "rootAssetIds": [
'       {
'         "id": 1543391847125216
'       },
'       {
'         "id": 6483833221883084
'       }
'     ],
'     "dataSetIds": [
'       {
'         "externalId": "eu aliqua dolor ea"
'       },
'       {
'         "id": 954668826986822
'       }
'     ],
'     "assetSubtreeIds": [
'       {
'         "externalId": "nisi occaecat sunt enim Ut"
'       },
'       {
'         "externalId": "anim reprehenderit ex nostrud"
'       }
'     ],
'     "source": "nulla mollit exercita",
'     "createdTime": {
'       "max": 35775661,
'       "min": 68358871
'     },
'     "lastUpdatedTime": {
'       "max": 39458190,
'       "min": 53247476
'     },
'     "uploadedTime": {
'       "max": 20009824,
'       "min": 24281615
'     },
'     "sourceCreatedTime": {
'       "max": 94237198,
'       "min": 59856114
'     },
'     "sourceModifiedTime": {
'       "max": 74319204,
'       "min": 63072110
'     },
'     "externalIdPrefix": "et",
'     "uploaded": false,
'     "labels": {
'       "containsAll": [
'         {
'           "externalId": "Ut ipsum in"
'         },
'         {
'           "externalId": "amet reprehenderit velit"
'         }
'       ]
'     },
'     "geoLocation": {
'       "relation": "WITHIN",
'       "shape": {
'         "type": "LineString",
'         "coordinates": [
'         ]
'       }
'     }
'   },
'   "partition": "proident est Duis nisi et",
'   "limit": 100,
'   "cursor": "incididunt"
' }

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("filter.name","ex nostrud consectetur")
success = json.UpdateString("filter.directoryPrefix","tempor laborum ad consectetur")
success = json.UpdateString("filter.mimeType","aute dolor sit Duis")
success = json.UpdateNewObject("filter.metadata")
success = json.UpdateInt("filter.assetIds[0]",467579989120294)
success = json.UpdateInt("filter.assetIds[1]",8421974867540202)
success = json.UpdateString("filter.assetExternalIds[0]","")
success = json.UpdateString("filter.assetExternalIds[1]","sint minim aliqua ")
success = json.UpdateInt("filter.rootAssetIds[0].id",123)
success = json.UpdateInt("filter.rootAssetIds[1].id",123)
success = json.UpdateString("filter.dataSetIds[0].externalId","eu aliqua dolor ea")
success = json.UpdateInt("filter.dataSetIds[1].id",123)
success = json.UpdateString("filter.assetSubtreeIds[0].externalId","nisi occaecat sunt enim Ut")
success = json.UpdateString("filter.assetSubtreeIds[1].externalId","anim reprehenderit ex nostrud")
success = json.UpdateString("filter.source","nulla mollit exercita")
success = json.UpdateInt("filter.createdTime.max",35775661)
success = json.UpdateInt("filter.createdTime.min",68358871)
success = json.UpdateInt("filter.lastUpdatedTime.max",39458190)
success = json.UpdateInt("filter.lastUpdatedTime.min",53247476)
success = json.UpdateInt("filter.uploadedTime.max",20009824)
success = json.UpdateInt("filter.uploadedTime.min",24281615)
success = json.UpdateInt("filter.sourceCreatedTime.max",94237198)
success = json.UpdateInt("filter.sourceCreatedTime.min",59856114)
success = json.UpdateInt("filter.sourceModifiedTime.max",74319204)
success = json.UpdateInt("filter.sourceModifiedTime.min",63072110)
success = json.UpdateString("filter.externalIdPrefix","et")
success = json.UpdateBool("filter.uploaded",0)
success = json.UpdateString("filter.labels.containsAll[0].externalId","Ut ipsum in")
success = json.UpdateString("filter.labels.containsAll[1].externalId","amet reprehenderit velit")
success = json.UpdateString("filter.geoLocation.relation","WITHIN")
success = json.UpdateString("filter.geoLocation.shape.type","LineString")
success = json.UpdateNewArray("filter.geoLocation.shape.coordinates")
success = json.UpdateString("partition","proident est Duis nisi et")
success = json.UpdateInt("limit",100)
success = json.UpdateString("cursor","incididunt")

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}}/files/list","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": "ex nostrud consectetur",
        "directoryPrefix": "tempor laborum ad consectetur",
        "mimeType": "aute dolor sit Duis",
        "metadata": {},
        "assetIds": [
            467579989120294,
            8421974867540202
        ],
        "assetExternalIds": [
            "",
            "sint minim aliqua "
        ],
        "rootAssetIds": [
            {
                "id": 1543391847125216
            },
            {
                "id": 6483833221883084
            }
        ],
        "dataSetIds": [
            {
                "externalId": "eu aliqua dolor ea"
            },
            {
                "id": 954668826986822
            }
        ],
        "assetSubtreeIds": [
            {
                "externalId": "nisi occaecat sunt enim Ut"
            },
            {
                "externalId": "anim reprehenderit ex nostrud"
            }
        ],
        "source": "nulla mollit exercita",
        "createdTime": {
            "max": 35775661,
            "min": 68358871
        },
        "lastUpdatedTime": {
            "max": 39458190,
            "min": 53247476
        },
        "uploadedTime": {
            "max": 20009824,
            "min": 24281615
        },
        "sourceCreatedTime": {
            "max": 94237198,
            "min": 59856114
        },
        "sourceModifiedTime": {
            "max": 74319204,
            "min": 63072110
        },
        "externalIdPrefix": "et",
        "uploaded": false,
        "labels": {
            "containsAll": [
                {
                    "externalId": "Ut ipsum in"
                },
                {
                    "externalId": "amet reprehenderit velit"
                }
            ]
        },
        "geoLocation": {
            "relation": "WITHIN",
            "shape": {
                "type": "LineString",
                "coordinates": []
            }
        }
    },
    "partition": "proident est Duis nisi et",
    "limit": 100,
    "cursor": "incididunt"
}'
https://domain.com/api/v1/projects/{{project}}/files/list

Postman Collection Item JSON

{
  "id": "advancedListFiles",
  "name": "Filter files",
  "request": {
    "url": {
      "host": "{{baseUrl}}",
      "path": [
        "api",
        "v1",
        "projects",
        "{{project}}",
        "files",
        "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": "Retrieves a list of all files in a project. Criteria can be supplied to select a subset of files. This operation supports pagination with cursors.",
    "body": {
      "mode": "raw",
      "raw": "{\n    \"filter\": {\n        \"name\": \"ex nostrud consectetur\",\n        \"directoryPrefix\": \"tempor laborum ad consectetur\",\n        \"mimeType\": \"aute dolor sit Duis\",\n        \"metadata\": {},\n        \"assetIds\": [\n            467579989120294,\n            8421974867540202\n        ],\n        \"assetExternalIds\": [\n            \"\",\n            \"sint minim aliqua \"\n        ],\n        \"rootAssetIds\": [\n            {\n                \"id\": 1543391847125216\n            },\n            {\n                \"id\": 6483833221883084\n            }\n        ],\n        \"dataSetIds\": [\n            {\n                \"externalId\": \"eu aliqua dolor ea\"\n            },\n            {\n                \"id\": 954668826986822\n            }\n        ],\n        \"assetSubtreeIds\": [\n            {\n                \"externalId\": \"nisi occaecat sunt enim Ut\"\n            },\n            {\n                \"externalId\": \"anim reprehenderit ex nostrud\"\n            }\n        ],\n        \"source\": \"nulla mollit exercita\",\n        \"createdTime\": {\n            \"max\": 35775661,\n            \"min\": 68358871\n        },\n        \"lastUpdatedTime\": {\n            \"max\": 39458190,\n            \"min\": 53247476\n        },\n        \"uploadedTime\": {\n            \"max\": 20009824,\n            \"min\": 24281615\n        },\n        \"sourceCreatedTime\": {\n            \"max\": 94237198,\n            \"min\": 59856114\n        },\n        \"sourceModifiedTime\": {\n            \"max\": 74319204,\n            \"min\": 63072110\n        },\n        \"externalIdPrefix\": \"et\",\n        \"uploaded\": false,\n        \"labels\": {\n            \"containsAll\": [\n                {\n                    \"externalId\": \"Ut ipsum in\"\n                },\n                {\n                    \"externalId\": \"amet reprehenderit velit\"\n                }\n            ]\n        },\n        \"geoLocation\": {\n            \"relation\": \"WITHIN\",\n            \"shape\": {\n                \"type\": \"LineString\",\n                \"coordinates\": []\n            }\n        }\n    },\n    \"partition\": \"proident est Duis nisi et\",\n    \"limit\": 100,\n    \"cursor\": \"incididunt\"\n}"
    }
  }
}