Chilkat Online Tools

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

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

loResp = loHttp.PostJson3("https://domain.com/api/v1/projects/{{project}}/files/list","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": "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}"
    }
  }
}