Query a page of a Sheet's logical row view.

Up to 20 filter clauses, ANDed together. Each clause must specify exactly one kind: text (case-insensitive contains; text/uuid columns), min/max (number/integer columns — may use either or both), after/before (date/ timestamp columns; before is inclusive of the whole selected day), eq (exact match against one scalar), or in (exact match against any of 1..1000 scalars). A clause that mixes kinds is rejected with 400. eq/in apply to text, uuid, integer, boolean and date columns; text matching is exact and case-sensitive. Values may be string, number or boolean — never null — and a string value is at most 256 characters. in is capped at 1000 values in aggregate across all clauses. A value that cannot be coerced to the column's type is rejected with 400 and code: filter_value_invalid.

Optional (DVT-5453). Ask for the n-th largest (top) or smallest (bottom) value of numeric columns over the whole filtered population, returned as rankThresholds so a topN/bottomN conditional-format rule can be evaluated exactly rather than over the loaded page. Honoured on the first page only: ignored when cursor is present. At most 8 entries; a malformed entry, or a column that is not a declared number/integer column (matched case-insensitively), is rejected with 400, so send numeric columns only.

One page of a sheet's logical row view (POST /v1/sheets/{id}/rows/query). For a linked sheet (DVT-2931), this page can contain MORE rows than the requested pageSize: rows whose primary key has an unflushed pending edit but which fell outside the merged-read page are hydrated by a bounded keyed lookup and appended after the page rows (each with pending: true) so read-your-writes holds even when the edited row isn't on the current page. A linked-sheet page with filters may be shorter than pageSize, even empty, while hasMore is true; page on hasMore/nextCursor, not row count.

Response metadata.