filter

Get filtered data row count

Returns the number of rows matching certain criteria. The request object has many fields controlling which rows are returned. For basic filtering the only one that needs to be specified is the filterModel field. For more on constructing filters, see the Filter Model Detail Guide.

post/dataset/{handle}/count/rows

Request

Base URL
//api.gigasheet.com (relative, and the document’s source URL is not known)
Auth
API key in header X-GIGASHEET-TOKEN
TypeScript
https://skmtc.dev/freshdesk/apis/gigasheet-api/docs/dataset/:handle/count/rows/post.ts
A function with typed inputs. Its response is checked against the schema.

Path parameters

handlestring required

sheet to filter

Request body

AllowUnstableOrderboolean

API may set true to allow unstable result order for faster performance on large files

FieldTypesstring[]

if the app work with pivot mode the system should check type of field by ex. int, float, string

endRowinteger

filterModelobject

pivotModeboolean

startRowinteger

Response

integer required

Changes

No recorded changes to this operation across all 1 revision of this API.