Application API
  1. V2
Application API
  • V3 (AI-friendly-beta)
    • Overview
    • Field Type Comparison Table
    • Guidelines for Using Filters
    • Error Code
    • application
      • Get application information
    • worksheet
      • Get worksheet structure information
      • Edit the worksheet
      • Delete worksheets
      • Create worksheet
    • worksheet Row Records
      • Get a list of line records
      • Get line record details
      • Update line records
      • Delete line records
      • Get relation records
      • Create a new row record
      • Add new line records in batches
      • Batch update line records
      • Batch delete row records
      • Obtain line record perspective data
      • Get record sharing links
      • Get a row record log
      • Get line record discussion
    • option set
      • Get a list of option sets
      • Create an option set
      • Edit option set
      • Delete option set
    • workflow
      • Get a list of processes
      • Get process details
      • Trigger process
    • role
      • Get a list of roles
      • create role
      • Get role details
      • remove roles
      • Add role members
      • Remove role members
      • Members withdraw from all roles
    • public query
      • find members
      • Find departments
      • Get regional information
  • V2
    • Development Guide
    • ErrorCode
    • Filter Demo
    • Filter
    • Options Set
      • Add Option Set
      • Get Option Set
      • Edit Option Set
      • Delete Option Set
    • Application Role
      • Get Application Role List GET
      • Create Application Role
      • Delete Application Role
      • Add Application Role Member
      • Remove Application Role Member
      • Exit application
      • Get Role Details
    • worksheet
      • Create Worksheet
      • Get worksheet structure information
      • Get List
      • Create Row Record
      • Batch Create Row Records
      • Get Row Record Details
      • Get row record details
      • Update Row Record Details
      • Batch Update Row Record Details
      • Delete Row Record
      • Get associated record
      • Get Record Share Link
      • Get total row count of worksheet
      • Get Row Record Log
    • app
      • Get Application Information
    • Public Inquiries
      • Get regional Information
    • Get Row Record Discussions
      POST
  1. V2

Filter Demo

text#

image.png
[
 {
 "controlId": "630b1fba3578400b4810f745",
 "dataType": 2,
 "spliceType": 1,
 "filterType": 2,
 "value": "Zhang San"
 }
]

Value#

image.png
[
 {
 "controlId": "630b1fba3578400b4810f767",
 "dataType": 6,
 "spliceType": 1,
 "filterType": 13,
 "value": "3"
 }
]

Date/Time#

image.png
[
 {
 "controlId": "630b1fba3578400b4810f764",
 "dataType": 15,
 "spliceType": 1,
 "filterType": 31, "dateRange": 0,
 "dateRangeType": 3,
 "maxValue": "2025-05-03",
 "minValue": "2024-01-01"
 }
]

Options#

image.png
[
{
 "controlId": "630b1fba3578400b4810f75a",
 "dataType": 11,
 "spliceType": 1,
 "filterType": 26,
 "values": [ "19ee464f-0688-4866-9972-bd4a1a62d0dd"
 ]
 }
]

Associated records#

image.png
[
 {
 "controlId": "630b1fba3578400b4810f784",
 "dataType": 29,
 "spliceType": 1,
 "filterType": 51,
 "values": [ "1e487b74-7d05-41c9-b58e-7fc846e86e8d"
 ]
 }
]

Level#

image.png
[
 {
 "controlId": "67edf3a8c92270e474824e51",
 "dataType": 28,
 "spliceType": 1,
 "filterType": 2,
 "values": [
 "3",
 "4"
 ]
 }
]

Check items#

image.png
[
{
"controlId": "67edf3961e00fbbb49b63fac",
"dataType": 36,
"spliceType": 1,
"filterType": 2,
"value": 1
}
]

Regular combination filtering#

1.
Text + single selection
image.png
[
{
"controlId": "630b1fba3578400b4810f745",
"dataType": 2,
"spliceType": 1,
"filterType": 2,
"value": "Zhang San"
},
{
"controlId": "630b1fba3578400b4810f75a",
"dataType": 11,
"spliceType": 1,
"filterType": 26,
"values": [
"19ee464f-0688-4866-9972-bd4a1a62d0dd"
] }
]
Modified at 2025-08-21 08:51:41
Previous
ErrorCode
Next
Filter
Built with