应用 API

批量更新行记录详情

www

https://www.mingdao.com

POST

/v2/open/worksheet/editRows

批量更新行记录

请求参数

Body 参数application/json

appkey

string

AppKey

必需

sign

string

签名

必需

worksheetId

string

工作表ID

必需

rowIds

array[string]

行记录列表

必需

control

object

控件信息

必需

旧字段，用于单个字段更新

controid

string

控件ID

必需

value

string

控件值

必需

controls

array [object {2}]

控件列表数据

必需

用于多个字段更新

controlId

string

控件 ID

必需

value

string

控件值

必需

triggerWorkflow

boolean

是否触发工作流

可选

默认值:

true

示例

{
    "appKey": "5004e1f1c103fc82",
    "sign": "MWQzYWJiNTNlYzZmNjZhNTA1NTExMGZhNzEyMjU3ZTMzM2Q2YWFmZWJkMTZjMWM1NTRjNDZiODUwNjc5OTUzNg==",
    "worksheetId": "6773abdab945df4389d21c17",
    "rowIds": [
        "0142c26c-144d-490b-8f58-7dd3b2221dfe",
        "0772e57d-1832-4ab9-9487-658c5e6e0ea1"
    ],
    "control": "",
    "triggerWorkflow": true,
    "controls": [
        {
            "controlId": "60d42c197766e73dc71929a2",
            "value": "昆明长水国际机场"
        },
        {
            "controlId": "60d42c197766e73dc71929a3",
            "value": "KMG"
        }
    ]
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://www.mingdao.com/v2/open/worksheet/editRows' \
--header 'Content-Type: application/json' \
--data-raw '{
    "appKey": "5004e1f1c103fc82",
    "sign": "MWQzYWJiNTNlYzZmNjZhNTA1NTExMGZhNzEyMjU3ZTMzM2Q2YWFmZWJkMTZjMWM1NTRjNDZiODUwNjc5OTUzNg==",
    "worksheetId": "6773abdab945df4389d21c17",
    "rowIds": [
        "0142c26c-144d-490b-8f58-7dd3b2221dfe",
        "0772e57d-1832-4ab9-9487-658c5e6e0ea1"
    ],
    "control": "",
    "triggerWorkflow": true,
    "controls": [
        {
            "controlId": "60d42c197766e73dc71929a2",
            "value": "昆明长水国际机场"
        },
        {
            "controlId": "60d42c197766e73dc71929a3",
            "value": "KMG"
        }
    ]
}'

返回响应

🟢200成功

application/json

Body

object {0}

示例

{}

更新行记录详情

删除行记录