API Reference

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.

Log in to see full request history
Path Params
string
required

sheet to filter

Body Params

filtered data request

FieldTypes
array of strings

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

FieldTypes
integer
filterModel
object
groupKeys
array
groupKeys
pivotCols
array of objects
pivotCols
boolean
rowGroupCols
array of objects
rowGroupCols
sortModel
array of objects
sortModel
integer
ungroupedAggregations
array of objects
ungroupedAggregations
valueCols
array of objects
valueCols
Responses

Language
Credentials
Click Try It! to start a request and see the response here!