---
title: "Fetch the Count of Documents with a Not-Null Field/Key in a Collection"
method: POST
path: "/api/collections/data/fetch/count"
tags: ["Database Management"]
---

# Fetch the Count of Documents with a Not-Null Field/Key in a Collection

`POST /api/collections/data/fetch/count`

Fetch the Count of Documents in a Collection. This is to fetch the number of Documents that have a specific Field/Key that is not null.

## Request body

- object
  - `collection` string — The Name of the Collection or the Group where you want to store all your data.
  - `key` string — The Field/Key that you want to check for.

## Response `200`

Output from the Database Collection Fetch Process

- object
  - `status` string — Status indicating the success of the text moderation.
  - `processing_time` integer — The time taken to process the request, in milliseconds.
  - `processing_id` string — A universally unique identifier for the request. This can be used to track the request in the logs.
  - `processing_count` integer — The number of times the request has been processed. This is what is considered in the Billing Process. This is either the number of times the image is processed or the number of words that the server processes.
  - `data` object
    - `databaseId` string — The ID of the Database where the data is stored.
    - `collection` string — The Name of the Collection or the Group where you want to store all your data.
    - `elapsed_time` integer — The time taken to process the request, in milliseconds.
    - `data` string — The Count of Documents with a Not-Null Field/Key in a Collection

## Other responses

- `400` — Bad Request.
- `401` — Unauthorized
- `404` — Not Found
- `406` — Not Acceptable
- `500` — Internal Server Error

---

[API](https://skmtc.net/worqhat/apis/worqhat-ai-api-endpoints-2.md) · [All operations](https://skmtc.net/worqhat/apis/worqhat-ai-api-endpoints-2/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/worqhat/worqhat-ai-api-endpoints-2/versions/fc369f69a3e6/schema)