v1

latestOpenAPI 3.0.02026-07-14184214216.1 KB

filter

Filter data

Returns 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/file/{handle}/filter

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

columnHighlightsobject

endRowinteger

filterModelobject

pivotModeboolean

startRowinteger

Response

cellHighlightsobject

rowsobject[]