Get associated record - Application API

Request

Body Params application/json

appKey

string

AppKey

required

sign

string

Signature

required

worksheetId

string

Worksheet ID

required

pageSize

integer

Number of rows

required

pageIndex

integer

Page Number

required

rowId

string

Row Record ID

required

controlId

string

Related Field ID

required

getSystemControl

boolean

Whether to obtain system fields

optional

Default:

false

Example

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

Request samples

Shell

JavaScript

Java

Swift

Go

PHP

Python

HTTP

C

C#

Objective-C

Ruby

OCaml

Dart

R

curl --location --request POST 'https://api.mingdao.com/v2/open/worksheet/getRowRelations' \
--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
}'

Responses

🟢200成功

application/json

Body

data

object

required

rows

array [object {6}]

required

total

integer

Total number of entries

required

success

boolean

required

error_code

integer

required

code

integer

required

msg

string

required

Example

{
    "data": {
        "rows": [
            {
                "_id": "67eb9b95951074c1a9cee656",
                "6305f0ae9845bd8cdfee4ba9": "",
                "rowid": "b89d5833-8f27-4bff-b9e4-d570622e1099",
                "6305f0ae9845bd8cdfee4b9d": "",
                "6305f0ae9845bd8cdfee4b9c": " Tencent ",
                "6305f0ae9845bd8cdfee4b9f": "",
                "autoid": 0,
                "6305f0ae9845bd8cdfee4ba0": "",
                "6305f0ae9845bd8cdfee4b9a": "",
                "6305f0ae9845bd8cdfee4ba6": "",
                "6305f0ae9845bd8cdfee4baa": "",
                "6305f0ae9845bd8cdfee4b9b": "",
                "6305f0ae9845bd8cdfee4ba4": "",
                "6305f0ae9845bd8cdfee4b9e": "",
                "6305f0ae9845bd8cdfee4ba3": "",
                "6307162b480f2194bb3b52f6": "",
                "6307162b480f2194bb3b52f7": "",
                "6307162b480f2194bb3b52f8": "",
                "6305f0ae9845bd8cdfee4ba2": "",
                "6305f0ae9845bd8cdfee4ba5": "",
                "6308a599ed2aacb5681e2872": "",
                "6305f0ae9845bd8cdfee4ba1": "",
                "6305f0ae9845bd8cdfee4ba8": "",
                "6307147bde36638a0ea9ede7": "",
                "6305f0ae9845bd8cdfee4ba7": "",
                "6307181c9c60fb09d4d038bd": "",
                "6307181c9c60fb09d4d038be": "",
                "ownerid": "",
                "caid": "",
                "ctime": "",
                "utime": "",
                "uaid": ""
            }
        ],
        "total": 1
    },
    "success": true,
    "error_code": 1
}

🟠401没有权限

🟠404记录不存在