Application API
  1. worksheet Row Records
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
        POST
      • Get line record details
        GET
      • Update line records
        PATCH
      • Delete line records
        DELETE
      • Get relation records
        GET
      • Create a new row record
        POST
      • Add new line records in batches
        POST
      • Batch update line records
        PATCH
      • Batch delete row records
        DELETE
      • Obtain line record perspective data
        POST
      • Get record sharing links
        POST
      • Get a row record log
        GET
      • Get line record discussion
        GET
    • 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. worksheet Row Records

Get a list of line records

Testing
fromal
https://api.mingdao.com
fromal
https://api.mingdao.com
POST
/v3/app/worksheets/{worksheet_id}/rows/list
Get a list of worksheet records, including record creator and owner information, and the corresponding values for each control

Request

Path Params

Header Params

Body Params application/json

Example
{
    "pageSize": 100,
    "pageIndex": 1,
    "viewId": "",
    "fields": [
        ""
    ],
    "filter": {
        "type": "group",
        "logic": "OR",
        "children": [
            {
                "type": "group",
                "logic": "AND",
                "children": [
                    {
                        "type": "condition",
                        "field": "677b4a73d14fcf3edf4e7f15",
                        "operator": "eq",
                        "value": [
                            "1"
                        ]
                    },
                    {
                        "type": "condition",
                        "field": "677b4a73d14fcf3edf4e7f15",
                        "operator": "eq"
                    }
                ]
            }
        ]
    },
    "sorts": [
        {
            "field": "",
            "isAsc": false
        }
    ],
    "search": "",
    "tableView": true,
    "useFieldIdAsKey": true,
    "includeTotalCount": true,
    "includeSystemFields": true
}

Request Code Samples

Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request POST 'https://api.mingdao.com/v3/app/worksheets//rows/list' \
--header 'HAP-Appkey: {{appkey}}' \
--header 'HAP-Sign: {{sign}}' \
--header 'Content-Type: application/json' \
--data-raw '{
    "pageSize": 100,
    "pageIndex": 1,
    "viewId": "",
    "fields": [
        ""
    ],
    "filter": {
        "type": "group",
        "logic": "OR",
        "children": [
            {
                "type": "group",
                "logic": "AND",
                "children": [
                    {
                        "type": "condition",
                        "field": "677b4a73d14fcf3edf4e7f15",
                        "operator": "eq",
                        "value": [
                            "1"
                        ]
                    },
                    {
                        "type": "condition",
                        "field": "677b4a73d14fcf3edf4e7f15",
                        "operator": "eq"
                    }
                ]
            }
        ]
    },
    "sorts": [
        {
            "field": "",
            "isAsc": false
        }
    ],
    "search": "",
    "tableView": true,
    "useFieldIdAsKey": true,
    "includeTotalCount": true,
    "includeSystemFields": true
}'

Responses

🟢200OK
application/json
Body

Example
{
    "data": {
        "rows": [
            {
                "id": "0bc19fb7-4100-43ad-8f0e-7d2879427677",
                "_createdAt": "2024-03-25 15:52:58",
                "_createdBy": {
                    "id": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "_updatedBy": {
                    "id": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "_owner": {
                    "id": "user-undefined",
                    "fullname": "not specified",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "_updatedAt": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": "Router Resetting Device",
                "632444f6182c34e9180b069f": "9.99",
                "632444f6182c34e9180b06a1": "Products-30",
                "autoid": 15
            }
        ],
        "total": 1
    },
    "success": true
}
Modified at 2025-08-21 09:35:00
Previous
Create worksheet
Next
Get line record details
Built with