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

Create Worksheet

fromal
https://api.mingdao.com
fromal
https://api.mingdao.com
POST
/v2/open/worksheet/addWorksheet
Create a worksheet. Currently supported control types include text, value, single selection, multiple selection, time, date, member, attachment, and associated record

Request

Body Params application/json
appkey
string 
required
AppKey
sign
string 
required
Signature
name
string 
required
Worksheet name
alias
string 
required
Worksheet alias
sectionId
string 
optional
Group id
controls
array [object {10}] 
required
Worksheet control information
controlName
string 
required
Control name
alias
string 
optional
Control alias
type
integer 
required
Control type
staticValue
string 
required
Default value
required
string 
required
Is it required?
dot
integer 
optional
Retain decimal places ( 0-14 ), the control type is 6: value , 8: amount
enumDefault
string 
optional
When the type is 26 members, it indicates the number of members. Enter the rule 0 : single selection , 1 : multiple selection
When the type is 29 associated records, it indicates the number of associated records. Enter the rule 1 : single entry 2 : multiple entries
options
object 
optional
Option information, control type is 11: single choice , 10: fill in when multiple choice
max
integer 
optional
When the control type is 28 levels, it indicates the maximum level, fill in the rule ( 0-10 )
dataSource
string 
required
Data source id , when type is 29 (associated record), pass in the associated table id
Example
{
    "appKey": "4fa7cd2c37b8444e",
    "sign": "YjE5YTg4YTg2MmY2ZjQ4ZjUxMDcxNjk4YTI1MDRmYjQ0N2NkOGExYTJhODdkMDEzYWE3ZTFmMTIwODBlODk4Yg==",
    "name": " China Airport Code ",
    "sectionId": "",
    "controls": [
        {
            "controlName": " Text ",
            "alias": "",
            "type": 2,
            "required": true
        },
        {
            "controlName": " Value ",
            "alias": "",
            "type": 6,
            "dot": 2,
            "required": true
        },
        {
            "controlName": " Single Selection ",
            "alias": "",
            "type": 11,
            "options": [
                {
                    "value": " Option Name 1",
                    "index": 1
                },
                {
                    "value": " Option Name 2",
                    "index": 2
                }
            ],
            "required": true
        },
        {
            "controlName": " Multiple Selection ",
            "alias": "",
            "type": 10,
            "options": [
                {
                    "value": " Option Name 1",
                    "index": 1
                },
                {
                    "value": " Option Name 2",
                    "index": 2
                },
                {
                    "value": " Option Name 3",
                    "index": 3
                }
            ],
            "required": true
        },
        {
            "controlName": " Time - Hours and Minutes ",
            "alias": "",
            "type": 46,
            "required": true,
            "unit": 1
        },
        {
            "controlName": " Time - Hours, Minutes, Seconds ",
            "alias": "",
            "type": 46,
            "required": true,
            "unit": 6
        },
        {
            "controlName": " Member - Single Selection ",
            "type": 26,
            "alias": "",
            "enumDefault": 0,
            "required": true
        },
        {
            "controlName": " Member - Multiple Selection ",
            "type": 26,
            "alias": "",
            "enumDefault": 1,
            "required": true
        },
        {
            "controlName": " Attachment ",
            "alias": "",
            "type": 14,
            "required": true
        },
        {
            "controlName": " Date ",
            "alias": "",
            "type": 15,
            "required": true
        },
        {
            "controlName": " DateTime ",
            "alias": "",
            "type": 16,
            "required": true
        },
        {
            "controlName": " Related Records ",
            "alias": "",
            "type": 29,
            "enumDefault": 1,
            "dataSource": "676910ad8d09d8a189da06a0",
            "required": true
        }
    ]
}

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/addWorksheet' \
--header 'Content-Type: application/json' \
--data-raw '{
    "appKey": "4fa7cd2c37b8444e",
    "sign": "YjE5YTg4YTg2MmY2ZjQ4ZjUxMDcxNjk4YTI1MDRmYjQ0N2NkOGExYTJhODdkMDEzYWE3ZTFmMTIwODBlODk4Yg==",
    "name": " China Airport Code ",
    "sectionId": "",
    "controls": [
        {
            "controlName": " Text ",
            "alias": "",
            "type": 2,
            "required": true
        },
        {
            "controlName": " Value ",
            "alias": "",
            "type": 6,
            "dot": 2,
            "required": true
        },
        {
            "controlName": " Single Selection ",
            "alias": "",
            "type": 11,
            "options": [
                {
                    "value": " Option Name 1",
                    "index": 1
                },
                {
                    "value": " Option Name 2",
                    "index": 2
                }
            ],
            "required": true
        },
        {
            "controlName": " Multiple Selection ",
            "alias": "",
            "type": 10,
            "options": [
                {
                    "value": " Option Name 1",
                    "index": 1
                },
                {
                    "value": " Option Name 2",
                    "index": 2
                },
                {
                    "value": " Option Name 3",
                    "index": 3
                }
            ],
            "required": true
        },
        {
            "controlName": " Time - Hours and Minutes ",
            "alias": "",
            "type": 46,
            "required": true,
            "unit": 1
        },
        {
            "controlName": " Time - Hours, Minutes, Seconds ",
            "alias": "",
            "type": 46,
            "required": true,
            "unit": 6
        },
        {
            "controlName": " Member - Single Selection ",
            "type": 26,
            "alias": "",
            "enumDefault": 0,
            "required": true
        },
        {
            "controlName": " Member - Multiple Selection ",
            "type": 26,
            "alias": "",
            "enumDefault": 1,
            "required": true
        },
        {
            "controlName": " Attachment ",
            "alias": "",
            "type": 14,
            "required": true
        },
        {
            "controlName": " Date ",
            "alias": "",
            "type": 15,
            "required": true
        },
        {
            "controlName": " DateTime ",
            "alias": "",
            "type": 16,
            "required": true
        },
        {
            "controlName": " Related Records ",
            "alias": "",
            "type": 29,
            "enumDefault": 1,
            "dataSource": "676910ad8d09d8a189da06a0",
            "required": true
        }
    ]
}'

Responses

🟢200成功
application/json
Body
success
boolean 
required
code
integer 
required
msg
string 
required
data
string 
required
Worksheet ID
Examples
{
    "data": "67eb801bbb2af284541ae54c",
    "success": true,
    "error_code": 1
}
🟠401没有权限
Modified at 2025-04-07 02:41:02
Previous
Get Application Information
Next
Get worksheet structure information
Built with