获取关联记录

正式环境

https://api.mingdao.com

POST

/v2/open/worksheet/getRowRelations

获取关联记录列表，包括关联记录来源工作表信息，行记录信息，行记录详细信息，创建者信息

请求参数

Query 参数

url

string

可选

Body 参数application/json

appKey

string

AppKey

必需

sign

string

签名

必需

worksheetId

string

工作表ID

必需

pageSize

integer

行数

必需

pageIndex

integer

页码

必需

rowId

string

行记录ID

必需

controlId

string

关联字段 ID

必需

getSystemControl

boolean

是否获取系统字段

可选

默认值:

false

示例

{
  "appKey": "b09410353a7d607e",
  "sign": "MDg2MzlmZGFhMTFiYjIwODE0MDdkMGNlZmU4YWM2ZmU5NjFkZWUzYWI5NTM5MzNiZDEzNjUxZTA4M2UyMDI3OQ==",
  "worksheetId": "67eb8326143184e59c37575a",
  "pageSize": 50,
  "pageIndex": 1,
  "rowId": "099236ee-01df-458b-9c62-125289fd3de7",
  "controlId": "67eb8326bb2af284541ae765",
  "getSystemControl": false
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://api.mingdao.com/v2/open/worksheet/getRowRelations?url=' \
--header 'Content-Type: application/json' \
--data-raw '{
  "appKey": "b09410353a7d607e",
  "sign": "MDg2MzlmZGFhMTFiYjIwODE0MDdkMGNlZmU4YWM2ZmU5NjFkZWUzYWI5NTM5MzNiZDEzNjUxZTA4M2UyMDI3OQ==",
  "worksheetId": "67eb8326143184e59c37575a",
  "pageSize": 50,
  "pageIndex": 1,
  "rowId": "099236ee-01df-458b-9c62-125289fd3de7",
  "controlId": "67eb8326bb2af284541ae765",
  "getSystemControl": false
}'

返回响应

🟢200成功

application/json

Body

data

object

必需

rows

array [object {4}]

必需

total

string

总条数

必需

success

boolean

必需

error_code

integer

必需

示例

{
  "data": {
    "rows": [
      {
        "rowid": "关联记录id",
        "ctime": "创建时间",
        "utime": "更新时间",
        "关联记录控件id/别名": "控件值"
      }
    ],
    "total": "总条数"
  },
  "success": true,
  "error_code": 1
}

修改于 2025-06-25 08:38:55

删除行记录

获取记录分享链接