Application API
  1. worksheet
Application API
  • Development Guide
  • Filter
  • Filter Demo
  • ErrorCode
  • app
    • Get Application Information
      GET
  • worksheet
    • Create Worksheet
      POST
    • Get worksheet structure information
      POST
    • Get List
      POST
    • Create Row Record
      POST
    • Batch Create Row Records
      POST
    • Get Row Record Details
      GET
    • Get row record details
      POST
    • Update Row Record Details
      POST
    • Batch Update Row Record Details
      POST
    • Delete Row Record
      POST
    • Get associated record
      POST
    • Get Record Share Link
      POST
    • Get total row count of worksheet
      POST
    • Get Row Record Log
      POST
  • Application Role
    • Get Application Role List GET
      GET
    • Create Application Role
      POST
    • Delete Application Role
      POST
    • Add Application Role Member
      POST
    • Remove Application Role Member
      POST
    • Exit application
      POST
    • Get Role Details
      GET
  • Options Set
    • Add Option Set
    • Get Option Set
    • Edit Option Set
    • Delete Option Set
  • Get regional Information
    POST
  1. worksheet

Get List

fromal
https://api.mingdao.com
fromal
https://api.mingdao.com
POST
/v2/open/worksheet/getFilterRows
Get a list of worksheet records, including the record creator, owner information, and the corresponding values of each control

Request

Body Params application/json
appKey
string 
AppKey
required
sign
string 
Signature
required
worksheetId
string 
Worksheet ID
required
viewId
string 
View id
optional
pageSize
integer 
Number of pages, maximum is 1000
required
pageIndex
integer 
Page Number
required
listType
integer 
Return data type
optional
controls
array[string]
Return the specified control ( ID or alias)
optional
After filling in, the returned data will only contain these control information
filters
array[string]
Filter Combinations
optional
Please refer to the appendix for the parameters of each filter
sortId
string 
Sort Field ID
optional
isAsc
string 
Is it ascending?
optional
notGetTotal
boolean 
Whether to not count the total number of rows to improve performance
optional
Default:
false
useControlId
boolean 
Whether to return only controlId
optional
Default:
false
getSystemControl
boolean 
Whether to obtain system fields
optional
Default:
false
Example
{
    "appKey": "4fa7cd2c37b8444e",
    "sign": "YjE5YTg4YTg2MmY2ZjQ4ZjUxMDcxNjk4YTI1MDRmYjQ0N2NkOGExYTJhODdkMDEzYWE3ZTFmMTIwODBlODk4Yg==",
    "worksheetId": "65dda1a5a608a40050774c78",
    "viewId": "",
    "pageSize": 50,
    "pageIndex": 1,
    "listType": 0,
    "controls": [],
    "filters": [],
    "sortId": "",
    "isAsc": "false",
    "notGetTotal": "false",
    "useControlId": "false",
    "getSystemControl": "false"
}

Request 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/v2/open/worksheet/getFilterRows' \
--header 'Content-Type: application/json' \
--data-raw '{
    "appKey": "4fa7cd2c37b8444e",
    "sign": "YjE5YTg4YTg2MmY2ZjQ4ZjUxMDcxNjk4YTI1MDRmYjQ0N2NkOGExYTJhODdkMDEzYWE3ZTFmMTIwODBlODk4Yg==",
    "worksheetId": "65dda1a5a608a40050774c78",
    "viewId": "",
    "pageSize": 50,
    "pageIndex": 1,
    "listType": 0,
    "controls": [],
    "filters": [],
    "sortId": "",
    "isAsc": "false",
    "notGetTotal": "false",
    "useControlId": "false",
    "getSystemControl": "false"
}'

Responses

🟢200成功
application/json
Body
success
boolean 
required
code
integer 
required
msg
string 
required
data
object 
required
rows
array [object {6}] 
required
Example
{
    "data": {
        "rows": [
            {
                "_id": "66012d5a9c20ba7170852df3",
                "rowid": "0bc19fb7-4100-43ad-8f0e-7d2879427677",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Router Resetter ",
                "632444f6182c34e9180b069f": "9.99",
                "632444f6182c34e9180b06a1": " Product -30",
                "autoid": 15
            },
            {
                "_id": "66012d5a9c20ba7170852df2",
                "rowid": "3dd94902-8ee4-498d-bd5b-c030e9d7e9da",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Mobile hard disk ",
                "632444f6182c34e9180b069f": "129.99",
                "632444f6182c34e9180b06a1": " Product -29",
                "autoid": 14
            },
            {
                "_id": "66012d5a9c20ba7170852df1",
                "rowid": "65fdfb74-12a8-485d-b125-805f3170fc82",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Keyboard and Mouse Set ",
                "632444f6182c34e9180b069f": "59.99",
                "632444f6182c34e9180b06a1": " Product -28",
                "autoid": 13
            },
            {
                "_id": "66012d5a9c20ba7170852df0",
                "rowid": "85a34a10-48cb-4724-922a-bfcaf9290acd",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Headset ",
                "632444f6182c34e9180b069f": "69.99",
                "632444f6182c34e9180b06a1": " Product -27",
                "autoid": 12
            },
            {
                "_id": "66012d5a9c20ba7170852def",
                "rowid": "6fc9e804-48af-4e56-be5a-c2b35d6635a1",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Display ",
                "632444f6182c34e9180b069f": "299.99",
                "632444f6182c34e9180b06a1": " Product -26",
                "autoid": 11
            },
            {
                "_id": "66012d5a9c20ba7170852dee",
                "rowid": "f6789557-6759-46a9-a88b-1f98dc9b5863",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Mouse ",
                "632444f6182c34e9180b069f": "19.99",
                "632444f6182c34e9180b06a1": " Product -25",
                "autoid": 10
            },
            {
                "_id": "66012d5a9c20ba7170852ded",
                "rowid": "edab740e-7918-42b8-aadd-929c2e3dc08b",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Keyboard ",
                "632444f6182c34e9180b069f": "39.99",
                "632444f6182c34e9180b06a1": " Product -24",
                "autoid": 9
            },
            {
                "_id": "66012d5a9c20ba7170852dec",
                "rowid": "74da83e3-96fc-403a-8ba3-3d3442a1633b",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Router ",
                "632444f6182c34e9180b069f": "99.99",
                "632444f6182c34e9180b06a1": " Product -23",
                "autoid": 8
            },
            {
                "_id": "66012d5a9c20ba7170852deb",
                "rowid": "e6ec418c-5919-4d15-8282-d44228bbf6cb",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Speaker ",
                "632444f6182c34e9180b069f": "199.99",
                "632444f6182c34e9180b06a1": " Product -22",
                "autoid": 7
            },
            {
                "_id": "66012d5a9c20ba7170852dea",
                "rowid": "0fcdd777-8189-4181-9905-dd4385982ac3",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Camera ",
                "632444f6182c34e9180b069f": "799.99",
                "632444f6182c34e9180b06a1": " Product -21",
                "autoid": 6
            },
            {
                "_id": "66012d5a9c20ba7170852de9",
                "rowid": "15da1889-c566-419a-9878-5fab27c28d7a",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Computer ",
                "632444f6182c34e9180b069f": "1999.99",
                "632444f6182c34e9180b06a1": " Product -20",
                "autoid": 5
            },
            {
                "_id": "66012d5a9c20ba7170852de8",
                "rowid": "290a5c44-e25c-4516-a95a-22b173eee35c",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Headphones ",
                "632444f6182c34e9180b069f": "59.99",
                "632444f6182c34e9180b06a1": " Product -19",
                "autoid": 4
            },
            {
                "_id": "66012d5a9c20ba7170852de7",
                "rowid": "f54ea86a-8914-46f2-b5b3-5bd0d7c097cc",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " TV ",
                "632444f6182c34e9180b069f": "1999.99",
                "632444f6182c34e9180b06a1": " Product -18",
                "autoid": 3
            },
            {
                "_id": "66012d5a9c20ba7170852de6",
                "rowid": "1294e9fd-3b26-4e02-8394-598ef3a0b49b",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Tablet computer ",
                "632444f6182c34e9180b069f": "1299.99",
                "632444f6182c34e9180b06a1": " Product -17",
                "autoid": 2
            },
            {
                "_id": "66012d5a9c20ba7170852de5",
                "rowid": "88d31795-0e4a-4a90-be6f-202c01b23907",
                "ctime": "2024-03-25 15:52:58",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": " Mobile phone ",
                "632444f6182c34e9180b069f": "999.99",
                "632444f6182c34e9180b06a1": " Product -16",
                "autoid": 1
            },
            {
                "_id": "65fd61b94209df8611d96478",
                "rowid": "495ba93b-3a10-4c0f-ba9f-d6d9e6db9335",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Tablet stand ",
                "632444f6182c34e9180b069f": "19.99",
                "632444f6182c34e9180b06a1": " Product -15",
                "autoid": 15
            },
            {
                "_id": "65fd61b94209df8611d96477",
                "rowid": "0e22ab3d-11d7-4875-b7bc-e210d94a8452",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Wireless headphones ",
                "632444f6182c34e9180b069f": "89.99",
                "632444f6182c34e9180b06a1": " Product -14",
                "autoid": 14
            },
            {
                "_id": "65fd61b94209df8611d96476",
                "rowid": "e8b0d576-8de6-4bb1-be2e-3291a17827f4",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Smart watch ",
                "632444f6182c34e9180b069f": "199.99",
                "632444f6182c34e9180b06a1": " Product -13",
                "autoid": 13
            },
            {
                "_id": "65fd61b94209df8611d96475",
                "rowid": "3dd11d5e-42a2-4a4b-8cdf-9839eae27e4b",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Audio and video headphones ",
                "632444f6182c34e9180b069f": "69.99",
                "632444f6182c34e9180b06a1": " Product -12",
                "autoid": 12
            },
            {
                "_id": "65fd61b94209df8611d96474",
                "rowid": "c799691f-bde8-4c0f-80bc-72ed40520828",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Power bank ",
                "632444f6182c34e9180b069f": "39.99",
                "632444f6182c34e9180b06a1": " Product -11",
                "autoid": 11
            },
            {
                "_id": "65fd61b94209df8611d96473",
                "rowid": "e7d61fd6-43df-4b3b-99e1-5e5b1e3fb858",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Display ",
                "632444f6182c34e9180b069f": "399.99",
                "632444f6182c34e9180b06a1": " Product -10",
                "autoid": 10
            },
            {
                "_id": "65fd61b94209df8611d96472",
                "rowid": "e2127642-e48a-411c-8863-23b61983d37a",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Headset ",
                "632444f6182c34e9180b069f": "59.99",
                "632444f6182c34e9180b06a1": " Product -9",
                "autoid": 9
            },
            {
                "_id": "65fd61b94209df8611d96471",
                "rowid": "be528ee9-88eb-42d4-949f-d0b258cfad35",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Mouse ",
                "632444f6182c34e9180b069f": "29.99",
                "632444f6182c34e9180b06a1": " Product -8",
                "autoid": 8
            },
            {
                "_id": "65fd61b94209df8611d96470",
                "rowid": "99e42997-15c3-43ab-a43f-b5b34a16bc1a",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Keyboard ",
                "632444f6182c34e9180b069f": "49.99",
                "632444f6182c34e9180b06a1": " Product -7",
                "autoid": 7
            },
            {
                "_id": "65fd61b94209df8611d9646f",
                "rowid": "5fdcba26-e7dc-4a9b-ac8c-b88b0b509190",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Router ",
                "632444f6182c34e9180b069f": "79.99",
                "632444f6182c34e9180b06a1": " Product -6",
                "autoid": 6
            },
            {
                "_id": "65fd61b94209df8611d9646e",
                "rowid": "090b0e53-3b1d-4a9d-90ec-fa432d32abea",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Camera ",
                "632444f6182c34e9180b069f": "1499.99",
                "632444f6182c34e9180b06a1": " Product -5",
                "autoid": 5
            },
            {
                "_id": "65fd61b94209df8611d9646d",
                "rowid": "30d29d37-950e-4e70-b4ca-a65eb21ee777",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Tablet computer ",
                "632444f6182c34e9180b069f": "2999.99",
                "632444f6182c34e9180b06a1": " Product -4",
                "autoid": 4
            },
            {
                "_id": "65fd61b94209df8611d9646c",
                "rowid": "f625d926-8474-4bb0-9c1f-5662de0aecc9",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Headphones ",
                "632444f6182c34e9180b069f": "99.99",
                "632444f6182c34e9180b06a1": " Product -3",
                "autoid": 3
            },
            {
                "_id": "65fd61b94209df8611d9646b",
                "rowid": "1dac6252-5637-46fe-bb75-f45b0f118f5e",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " TV ",
                "632444f6182c34e9180b069f": "1999.99",
                "632444f6182c34e9180b06a1": " Product -2",
                "autoid": 2
            },
            {
                "_id": "65fd61b94209df8611d9646a",
                "rowid": "3e8f1d75-31ac-42c4-8d99-e13f40a384e6",
                "ctime": "2024-03-22 18:47:21",
                "caid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "uaid": {
                    "accountId": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "user-undefined",
                    "fullname": " Unspecified ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "utime": "2024-03-22 18:47:21",
                "632444f6182c34e9180b069e": " Mobile phone ",
                "632444f6182c34e9180b069f": "999.99",
                "632444f6182c34e9180b06a1": " Product -1",
                "autoid": 1
            },
            {
                "_id": "65dda1a5a608a40050774d0c",
                "rowid": "2d4316d3-4871-4958-a8c4-d6b027395f1c",
                "caid": {
                    "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
                    "fullname": " Bu Jiafei ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
                    "fullname": " Bu Jiafei ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "632444f6182c34e9180b069e": " TV ",
                "632444f6182c34e9180b069f": "7000.00",
                "632444f6182c34e9180b06a1": " Product -4",
                "autoid": 4,
                "ctime": "2024-02-27 16:47:33",
                "utime": "2024-02-27 16:47:33",
                "uaid": ""
            },
            {
                "_id": "65dda1a5a608a40050774d0b",
                "rowid": "dcfb7316-971c-4828-ba8d-ac6e294b9281",
                "caid": {
                    "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
                    "fullname": " Bu Jiafei ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
                    "fullname": " Bu Jiafei ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "632444f6182c34e9180b069e": " Game console ",
                "632444f6182c34e9180b069f": "2500.00",
                "632444f6182c34e9180b06a1": " Product -3",
                "autoid": 3,
                "ctime": "2024-02-27 16:47:33",
                "utime": "2024-02-27 16:47:33",
                "uaid": ""
            },
            {
                "_id": "65dda1a5a608a40050774d0a",
                "rowid": "66d4f50e-5670-4214-a428-c8f1f1fb80e0",
                "caid": {
                    "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
                    "fullname": " Bu Jiafei ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
                    "fullname": " Bu Jiafei ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "632444f6182c34e9180b069e": " Computer ",
                "632444f6182c34e9180b069f": "8000.00",
                "632444f6182c34e9180b06a1": " Product -2",
                "autoid": 2,
                "ctime": "2024-02-27 16:47:33",
                "utime": "2024-02-27 16:47:33",
                "uaid": ""
            },
            {
                "_id": "65dda1a5a608a40050774d09",
                "rowid": "3f35d6d6-88c6-4e3a-b38a-8b8e8e7a605b",
                "caid": {
                    "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
                    "fullname": " Bu Jiafei ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "ownerid": {
                    "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
                    "fullname": " Bu Jiafei ",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "632444f6182c34e9180b069e": " Mobile phone ",
                "632444f6182c34e9180b069f": "5000.00",
                "632444f6182c34e9180b06a1": " Product -1",
                "autoid": 1,
                "ctime": "2024-02-27 16:47:33",
                "utime": "2024-02-27 16:47:33",
                "uaid": ""
            }
        ],
        "total": 34
    },
    "success": true,
    "error_code": 1
}
🟠401没有权限
🟠404记录不存在
Modified at 2025-04-07 02:42:34
Previous
Get worksheet structure information
Next
Create Row Record
Built with