Field Count Check API
This page documents how to create and manage a Field Count check via the REST API. The check uses the standard Quality Checks endpoints: set rule to fieldCount and provide the expected count as value under properties. The rule evaluates the container itself, so fields is not used. All endpoints share the base URL of your deployment (for example, https://your-instance.qualytics.io/api) and require a Bearer token.
Tip
For complete API documentation, including request and response schemas, visit the API docs.
Permissions
All endpoints require the Member role plus a team permission on the check's datastore: Reporter to read, Author to create or update an Active check, archive, or delete, and Drafter to create or update a Draft. See Permissions for the full matrix.
The properties object
Field Count carries its rule-specific configuration under properties:
| Field | Required | Type | Description |
|---|---|---|---|
value |
Yes | number |
The exact number of fields the container must hold. |
Create
Endpoint: POST /api/quality-checks
Permission: Member role + Author team permission on the container's datastore (Drafter when status is "Draft").
Create a Field Count check (every accepted field)
curl -X POST "https://your-instance.qualytics.io/api/quality-checks" \
-H "Authorization: Bearer YOUR_TOKEN" \
-H "Content-Type: application/json" \
-d '{
"description": "The ORDERS extract must hold exactly 9 fields.",
"rule": "fieldCount",
"fields": [],
"container_id": 145,
"properties": {"value": 9},
"tags": ["schema", "drift"],
"additional_metadata": {"jira": "DATA-9501"},
"template_id": null,
"status": "Active",
"owner_id": 7,
"default_anomaly_assignee_id": 12
}'
Field notes
| Field | Required | Notes |
|---|---|---|
description |
Yes | Free-text description shown in the UI. |
rule |
Yes | Must be "fieldCount". |
fields |
No | Field Count does not select columns. Send an empty array [] or omit. |
container_id |
Yes | ID of the container (table or file) the check runs against. |
properties |
Yes | Object with a single key, value. See above. |
tags |
No | List of tag names applied to the check for filtering and organization. |
additional_metadata |
No | Free-form key-value pairs (typically links to catalog entries, tickets, governance records). |
template_id |
No | ID of a Check Template to associate the check with. null if not using a template. |
status |
No | "Active" (default) or "Draft". Draft checks are not evaluated by Scans. |
owner_id |
No | ID of the user who owns the check. Defaults to the user creating the check when omitted. |
default_anomaly_assignee_id |
No | ID of the user automatically assigned to anomalies produced by the check. |
Three payload fields exist for other rule types but do not apply here:
filteris rejected. Field Count is not filterable, so any non-empty expression returns422 Unprocessable Entity. Sendnullor omit the field.coverageis rejected. The rule evaluates the container's shape, not its rows, so there is no per-row violation rate: any value other than1returns422 Unprocessable Entity. Sendnullor omit the field.anomaly_message_fieldis ignored. Field Count emits a Shape Anomaly only, and Shape Anomalies always use the fixed message.
Read
Endpoint: GET /api/quality-checks/{id}
Permission: Member role + Reporter team permission on the check's datastore.
Retrieve a check by ID
Update
Endpoint: PUT /api/quality-checks/{id}
Permission: Member role + Author team permission on the check's datastore (Drafter when the check stays Draft).
The PUT endpoint requires description; include the check's current description (or a new one) along with the fields you want to change. Send the whole properties object: partial property updates are not merged.
Update the expected count after a schema change
A PUT can update most fields on an existing Field Count check. Three values stay immutable: the rule type, the container the check is attached to, and the associated Check Template. If any of these needs to change, delete the check and create a new one.
Editable vs Immutable on PUT
Editable
descriptionproperties.value(the expected count)tagsadditional_metadatastatusowner_iddefault_anomaly_assignee_id
Immutable
rulecontainer_idtemplate_id
Delete
Endpoint: DELETE /api/quality-checks/{id}
Permission: Member role + Author team permission on the check's datastore.
Three query parameters control what happens, mirroring the two-stage flow in the UI:
| Parameter | Default | Description |
|---|---|---|
archive |
true |
When true, the check is archived and can be restored later. When false, the check is permanently deleted. |
status |
Discarded |
The archive resolution: Discarded (no longer relevant) or Invalid (wrong and suppressed from future AI generation). Only used when archive=true. |
delete_anomalies |
true |
Whether to permanently delete the anomalies the check produced. A permanent delete (archive=false) always removes them. |
Archive a check, keeping its anomalies
Delete a check permanently
Error responses
| Status | Description |
|---|---|
400 Bad Request |
A business-logic conflict prevents the operation (for example, changing properties while the check is archived, or switching an archived check between Discarded and Invalid). |
401 Unauthorized |
Missing or invalid API token. |
403 Forbidden |
The caller lacks the required team permission on the check's datastore. |
404 Not Found |
The check ID does not exist. |
422 Unprocessable Entity |
The payload fails schema validation (for example, description missing on PUT, properties.value missing or not a number, a non-empty filter, or a coverage other than 1). |