1. 表单操作
云表OpenApi接口文档
  • openApi接口常见问题
  • 错误代码列表
  • 错误返回格式
  • 登录登出
    • openapi登入请求
      POST
    • 登出请求
      GET
  • 数据接口
    • 调用模板的数据接口
      POST
    • 调用全局的数据接口
      POST
  • 表单操作
    • 获取所有模板名称列表
      POST
    • 新建/修改表单
      POST
    • 批量新建/修改表单
      POST
    • 打开表单接口
      GET
    • 打开表单总表接口
      GET
    • 总表表单过滤
      POST
    • 获取指定模板字段定义
      GET
    • 获取明细表总表
      POST
  • 系统表操作
    • 打开用户总表
      GET
    • 打开用户表单
      GET
    • 新增/更新用户对象
      POST
    • 打开角色总表
      GET
    • 打开指定角色对象
      GET
    • 新增/更新角色对象
      POST
  • 附件操作
    • 上传附件接口
      POST
    • 下载附件接口
      GET
    • 上传云盘附件接口
      POST
    • 下载网盘附件接口
      GET
  1. 表单操作

获取指定模板字段定义

GET
http://{url}/{enpId}/openapi/1.0/{模板名称}/structure
获取指定模板字段定义
需要在服务器版本3.3.45.43及以上版本才支持

请求参数

Path 参数

Header 参数

请求示例代码

Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request GET 'http://free.iyunbiao.cn/1538136/openapi/1.0/测试模板/structure' \
--header 'x-eversheet-application-name: e3396c22-83b9-47bd-9ab6-c24654d7ee46' \
--header 'x-eversheet-request-sign: {{sign}}' \
--header 'x-eversheet-session-token: 9a694a3b-5f46-45ed-bf0b-84101641661c'

返回响应

🟢200OK
application/json
操作成功
Body

示例
{
    "templateCode": "测试文本列表",
    "templateName": "测试文本列表",
    "templateCaption": "测试文本列表",

    "tableCaption": "测试文本列表",
    "fieldMapList": [
        {
            "caption": "原文本",
            "col": 4,
            "dataSpec": null,
            "defValue": "",
            "editable": true,
            "fieldKind": "dataField",
            "formatString": "@",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": true,
            "isTemp": false,
            "mustFill": false,
            "name": "f1",
            "row": 3,
            "type": 0,
            "visible": true,
            "width": 75
        },
        {
            "caption": "分隔符",
            "col": 4,
            "dataSpec": null,
            "defValue": "",
            "editable": true,
            "fieldKind": "dataField",
            "formatString": "@",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f4",
            "row": 4,
            "type": 0,
            "visible": true,
            "width": 75
        },
        {
            "caption": "是否去重",
            "col": 4,
            "dataSpec": null,
            "defValue": "",
            "editable": true,
            "fieldKind": "dataField",
            "formatString": "",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f5",
            "row": 5,
            "type": 3,
            "visible": true,
            "width": 75
        },
        {
            "caption": "文本列表",
            "col": 4,
            "dataSpec": null,
            "defValue": "",
            "editable": true,
            "fieldKind": "dataField",
            "formatString": "@",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f2",
            "row": 7,
            "type": 0,
            "visible": true,
            "width": 75
        },
        {
            "caption": "文本下拉列表",
            "col": 4,
            "dataSpec": null,
            "defValue": "",
            "editable": true,
            "fieldKind": "dataField",
            "formatString": "@",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f3",
            "row": 8,
            "type": 0,
            "visible": true,
            "width": 75
        },
        {
            "cancelCaption": "计算文本列表",
            "caption": "计算文本列表",
            "col": -1,
            "dataSpec": null,
            "defValue": "",
            "doCaption": "计算文本列表",
            "editable": true,
            "fieldKind": "stateField",
            "formatString": "",
            "friendlyName": "计算文本列表",
            "gridName": "",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f6",
            "row": -1,
            "triggerType": "byManual",
            "type": 3,
            "visible": true,
            "width": 50
        },
        {
            "caption": "当前姓名",
            "col": 4,
            "dataSpec": {
                "fillConfig": {
                    "IsClearDataBeforeInsert": false,
                    "customFillList": [
                        {
                            "assignType": "value",
                            "destFieldCaption": "当前姓名",
                            "destFieldName": "f7",
                            "editable": false,
                            "isSilent": false,
                            "srcExpression": "数据源.账号"
                        }
                    ],
                    "destMatch": "",
                    "destTable": "测试文本列表",
                    "destTableFuncType": "insert",
                    "isAppendDataWhenNotMatch": false,
                    "isClearCellData": false,
                    "isDelFreeColRow": false,
                    "version": 1
                },
                "functionCaption": "用户选择",
                "functionName": "15",
                "functionType": 3,
                "inputMode": [
                    "keyboard",
                    "dialogSelect"
                ],
                "isComposeMultiRecAsOne": false,
                "isMultiSelect": false,
                "restricted": true,
                "templateId": "0",
                "templateName": "root",
                "type": "templateFunction",
                "version": 2
            },
            "defValue": "",
            "editable": true,
            "fieldKind": "dataField",
            "formatString": "@",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f7",
            "row": 10,
            "type": 0,
            "visible": true,
            "width": 50
        },
        {
            "caption": "rtf",
            "col": 4,
            "dataSpec": null,
            "defValue": "",
            "editable": true,
            "exCellType": 1,
            "fieldKind": "dataField",
            "formatString": "@",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f8",
            "row": 12,
            "type": 9,
            "visible": true,
            "width": 75
        },
        {
            "caption": "markdown",
            "col": 4,
            "dataSpec": null,
            "defValue": "",
            "editable": true,
            "exCellType": 5,
            "fieldKind": "dataField",
            "formatString": "@",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f9",
            "row": 13,
            "type": 9,
            "visible": true,
            "width": 75
        },
        {
            "caption": "html",
            "col": 4,
            "dataSpec": null,
            "defValue": "",
            "editable": true,
            "exCellType": 4,
            "exCellTypeProp": {
                "imageSaveConfig": {
                    "enabled": false,
                    "fileSystemName": "\"fileBox\"",
                    "folderPath": ""
                }
            },
            "fieldKind": "dataField",
            "formatString": "@",
            "friendlyName": "",
            "gridName": "sheet1",
            "isMergeSameValue": false,
            "isPrimaryKey": false,
            "isTemp": false,
            "mustFill": false,
            "name": "f10",
            "row": 14,
            "type": 9,
            "visible": true,
            "width": 75
        }
    ],
    "childTableList": [
        {
            "tableCaption": "明细",
            "fieldMapList": [
                {
                    "caption": "内容",
                    "col": 1,
                    "dataSpec": null,
                    "defValue": "",
                    "editable": true,
                    "fieldKind": "dataField",
                    "formatString": "@",
                    "friendlyName": "",
                    "gridName": "",
                    "isMergeSameValue": false,
                    "isPrimaryKey": false,
                    "isTemp": false,
                    "mustFill": false,
                    "name": "f1",
                    "row": 1,
                    "type": 0,
                    "visible": true,
                    "width": 75
                }
            ]
        }
    ]
}
修改于 2026-03-27 02:49:54
上一页
总表表单过滤
下一页
获取明细表总表
Built with