批量新建行记录

正式环境

https://api.mingdao.com

POST

/v2/open/worksheet/addRows

批量新建行记录

请求参数

Query 参数

url

string

可选

Body 参数application/json

appkey

string

AppKey

必需

sign

string

签名

必需

worksheetId

string

工作表ID

必需

rows

array [object {2}]

必需

controlId

string

控件名称

必需

value

string

控件值

必需

controls

array [object {2}]

控件数据

必需

controlId

string

控件 id

必需

value

string

控件值

必需

triggerWorkflow

boolean

是否触发工作流

可选

默认值:

true

ReturnRowIds

boolean

可选

true：返回批量增加的rowIds，false返回时成功的条数

示例

{
 "appKey": "ab14bdc682de8bd0",
  "sign": "OTY0MTczZWE5ZGQxZGIyNjUwNTczNzUyYzk4ZDA5NDNjNGU1YjYxYWMxYzE4YmU2NzkwNGE1NDQ1ZmFkNWUyNQ==",
  "worksheetId": "6847f2a1e66b4b2aa67b1466",
  "triggerWorkflow": true,
  "rows": [
    [
  {
      "controlId": "6847f2a1e66b4b2aa67b1467",
      "value": "111"
    }
    ],
    [
  {
      "controlId": "6847f2a1e66b4b2aa67b1467",
      "value": "222"
    }
    ]
  ]
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://api.mingdao.com/v2/open/worksheet/addRows?url=' \
--header 'Content-Type: application/json' \
--data-raw '{
 "appKey": "ab14bdc682de8bd0",
  "sign": "OTY0MTczZWE5ZGQxZGIyNjUwNTczNzUyYzk4ZDA5NDNjNGU1YjYxYWMxYzE4YmU2NzkwNGE1NDQ1ZmFkNWUyNQ==",
  "worksheetId": "6847f2a1e66b4b2aa67b1466",
  "triggerWorkflow": true,
  "rows": [
    [
  {
      "controlId": "6847f2a1e66b4b2aa67b1467",
      "value": "111"
    }
    ],
    [
  {
      "controlId": "6847f2a1e66b4b2aa67b1467",
      "value": "222"
    }
    ]
  ]
}'

返回响应

🟢200成功

application/json

Body

success

boolean

必需

code

integer

必需

msg

string

必需

data

string

创建成功数量

必需

示例

成功示例异常示例

{
    "data": "67eb801bbb2af284541ae54c",
    "success": true,
    "error_code": 1
}

🟠401没有权限

修改于 2025-06-27 03:59:23

新建行记录

获取行记录详情