获取工作表结构信息

获取工作表配置及其控件信息

请求参数

Query 参数

url

string

可选

Body 参数application/json

appKey

string

AppKey

必需

sign

string

签名

必需

worksheetId

string

工作表 id

必需

示例

{
  "appKey": "4fa7cd2c37b8444e",
  "sign": "YjE5YTg4YTg2MmY2ZjQ4ZjUxMDcxNjk4YTI1MDRmYjQ0N2NkOGExYTJhODdkMDEzYWE3ZTFmMTIwODBlODk4Yg==",
  "worksheetId": "65dda1a5a608a40050774c72"
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

返回响应

🟢200成功

application/json

Body

success

boolean

必需

code

integer

必需

msg

string

必需

data

object

必需

projectId

string

组织ID

必需

appid

string

应用ID

必需

worksheetId

string

工作表ID

必需

name

string

工作表名称

必需

alias

string

工作表别名

必需

createTime

string

创建时间

必需

caid

string

创建人账号Id

必需

desc

string

说明

必需

entityName

string

记录实体名称

必需

groupId

string

分组ID

必需

shareRange

string

必需

分享范围 1：关闭分享 2：完全公开 3：成员可见

controls

array [object {5}]

控件列表

必需

views

array [object {2}]

必需

示例

成功示例异常示例

{
    "data": {
        "worksheetId": "65dda1a5a608a40050774c72",
        "name": "会员信息",
        "views": [
            {
                "viewId": "65dda1a5a608a40050774c8f",
                "name": "全部"
            },
            {
                "viewId": "65dda1a5a608a40050774c91",
                "name": "等级分类"
            },
            {
                "viewId": "65dda1a5a608a40050774c90",
                "name": "我的信息"
            }
        ],
        "controls": [
            {
                "controlId": "632444f6182c34e9180b0676",
                "controlName": "当前会员卡可用余额",
                "type": 31,
                "attribute": 0,
                "row": 3,
                "col": 0,
                "hint": "",
                "default": "",
                "dot": 2,
                "unit": "",
                "enumDefault": 1,
                "enumDefault2": 0,
                "defaultMen": [],
                "dataSource": "$632444f6182c34e9180b0675$-$632444f6182c34e9180b0672$",
                "sourceControlId": "",
                "sourceControlType": 0,
                "showControls": [],
                "noticeItem": 0,
                "userPermission": 0,
                "options": [],
                "required": false,
                "half": false,
                "relationControls": [],
                "viewId": "",
                "controlPermissions": "111",
                "unique": false,
                "coverCid": "",
                "strDefault": "",
                "desc": "",
                "fieldPermission": "110",
                "advancedSetting": {
                    "nullzero": "1",
                    "sorttype": "zh",
                    "isdecrypt": "0"
                },
                "alias": "",
                "size": 6,
                "editAttrs": [],
                "deleteAccountId": "",
                "deleteTime": "0001-01-01 08:00:00",
                "encryId": "",
                "sectionId": "",
                "remark": "",
                "lastEditTime": "0001-01-01 00:00:00",
                "disabled": false,
                "checked": false,
                "isDecrypt": "0"
            },
            {
                "controlId": "632444f6182c34e9180b066f",
                "controlName": "等级与折扣",
                "type": 29,
                "attribute": 0,
                "row": 8,
                "col": 0,
                "hint": "",
                "default": "",
                "dot": 0,
                "unit": "",
                "enumDefault": 1,
                "enumDefault2": 1,
                "defaultMen": [],
                "dataSource": "65dda1a5a608a40050774c75",
                "sourceControlId": "632444f6182c34e9180b068f",
                "sourceEntityName": "记录",
                "sourceTitleControlId": "632444f6182c34e9180b068e",
                "sourceControlType": 2,
                "showControls": [],
                "noticeItem": 0,
                "userPermission": 0,
                "options": [],
                "required": false,
                "half": false,
                "relationControls": [
                    {
                        "controlId": "632444f6182c34e9180b068e",
                        "controlName": "等级",
                        "type": 2,
                        "attribute": 1,
                        "row": 0,
                        "col": 0,
                        "hint": "",
                        "default": "",
                        "dot": 0,
                        "unit": "",
                        "enumDefault": 2,
                        "enumDefault2": 0,
                        "defaultMen": [],
                        "dataSource": "",
                        "sourceControlId": "",
                        "sourceControlType": 0,
                        "showControls": [],
                        "noticeItem": 0,
                        "userPermission": 0,
                        "options": [],
                        "required": true,
                        "half": false,
                        "relationControls": [],
                        "viewId": "",
                        "unique": false,
                        "coverCid": "",
                        "strDefault": "00",
                        "desc": "",
                        "fieldPermission": "",
                        "advancedSetting": {
                            "analysislink": "1",
                            "dismanual": "0",
                            "getinput": "0",
                            "getsave": "0",
                            "min": "",
                            "max": "",
                            "sorttype": "zh",
                            "isdecrypt": "0"
                        },
                        "alias": "",
                        "size": 4,
                        "editAttrs": [],
                        "deleteAccountId": "",
                        "deleteTime": "0001

🟠401没有权限

🟠404记录不存在