Count Table Records

Enables you to define specific conditions for filtering record count in your API response. Multiple conditions can be combined using logical operators such as 'and' and 'or'. Each condition consists of three parts: a field name, a comparison operator, and a value.

Example: where=(field1,eq,value1)~and(field2,eq,value2) will filter records where 'field1' is equal to 'value1' AND 'field2' is equal to 'value2'.

More examples: where=(Title,like,report) matches records whose Title contains 'report'; where=(Tags,anyof,urgent,bug) matches records whose multi-select Tags has 'urgent' or 'bug'.

Operators: eq, neq, gt, ge, lt, le, like, nlike, in, btw, nbtw, is, isnot, blank, notblank, checked, notchecked, anyof, allof, nanyof, nallof, isWithin (gte and lte are accepted as aliases of ge and le). Which ones apply depends on the field type, see filtering.

If viewId query parameter is also included, then the filters included here will be applied over the filtering configuration defined in the view.

Please remember to maintain the specified format; for quoting values that contain commas, parentheses or spaces, see the where syntax.

API Token. Refer here to know more