1. worksheet
Application API
  • V3 (AI-friendly-beta)
    • Overview
    • Field Type Comparison Table
    • Guidelines for Using Filters
    • Error Code
    • application
      • Get application information
    • worksheet
      • Get Worksheet List
      • Create worksheet
      • Get worksheet structure information
      • Update worksheet structure
      • Delete worksheet
      • Get worksheet list
    • worksheet Row Records
      • Create row record
      • Get row record list
      • Batch create row records
      • Batch update row record details
      • Batch delete row records
      • Get row record details
      • Update row record
      • Delete row record
      • Get row record discussions
      • Get row record logs
      • Get row record pivot data
      • Get related records
      • Get record share link
    • option set
      • Get option set list
      • Create option set
      • Edit option set
      • Deactivate option set
    • workflow
      • Get workflow list
      • Get workflow details
      • Trigger workflow
      • Get the list of approval workflow executions by worksheet ID and row ID
      • Get approval workflow execution detail
    • role
      • Get role list
      • Create role
      • Get role details
      • Delete role
      • Add role member
      • Remove role member
      • Remove member from all roles
    • public query
      • Find member
      • Find department
      • Get region information
    • knowledge
      • Get list of knowledge bases under an application
      • Knowledge base search
  • V2
    • Filter
    • Development Guide
    • Filter Demo
    • ErrorCode
    • 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
        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
    • app
      • Get Application Information
    • Public Inquiries
      • Get regional Information
    • Get Row Record Discussions
      POST
  • Schemas
    • Sample Schemas
      • option
      • relation
      • Pet
      • Category
      • Tag
    • Schemas
      • Authentication Information
      • obj_base_response
      • Person object
      • obj_field
      • Custom Page
      • obj_filter
      • Application Role
      • obj_record_row
      • obj_record_log
      • obj_record_discussion
      • obj_pivot_meta
      • obj_pivot_dimensions
      • obj_pivot_data
      • obj_process
      • obj_process_detail
      • obj_input
      • obj_output
      • obj_role
      • obj_role_permission
      • obj_user
      • obj_user_desensitized
      • obj_department
      • obj_custom_page
      • obj_optionset
      • obj_filter_children
      • obj_app
    • Base response object
    • memberInfo
    • department_with_path
    • departmentInfo
    • regionInfo
    • process
    • process_detail
    • input
    • output
    • role
    • role_permission
    • custom_page
    • optionset
    • field
    • worksheet
    • filter
    • filter_children
    • record_row
    • discussion
  1. worksheet

Create Worksheet

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

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 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://www.nocoly.com/v2/open/worksheet/addWorksheet' \
--header 'Authorization: Bearer <token>' \
--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

Examples
{
    "data": "67eb801bbb2af284541ae54c",
    "success": true,
    "error_code": 1
}
🟠401没有权限
Modified at 2025-04-07 02:41:02
Previous
Get Role Details
Next
Get worksheet structure information
Built with