Get row record details - Application API

Request

Header Params

Authorization

string

optional

Example:

Bearer keyQMY1hFpQysisMe

Body Params application/json

appKey

string

AppKey

required

sign

string

Signature

required

worksheetId

string

Worksheet ID

required

rowId

string

Row Record ID

required

getSystemControl

string

Whether to obtain system fields

required

Example

{
    "appKey": "5004e1f1c103fc82",
    "sign": "MWQzYWJiNTNlYzZmNjZhNTA1NTExMGZhNzEyMjU3ZTMzM2Q2YWFmZWJkMTZjMWM1NTRjNDZiODUwNjc5OTUzNg==",
    "worksheetId": "6773abdab945df4389d21c17",
    "rowId": " Row record ID",
    "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/getRowByIdPost' \
--header 'Authorization: Bearer keyQMY1hFpQysisMe' \
--header 'Content-Type: application/json' \
--data-raw '{
    "appKey": "5004e1f1c103fc82",
    "sign": "MWQzYWJiNTNlYzZmNjZhNTA1NTExMGZhNzEyMjU3ZTMzM2Q2YWFmZWJkMTZjMWM1NTRjNDZiODUwNjc5OTUzNg==",
    "worksheetId": "6773abdab945df4389d21c17",
    "rowId": " Row record ID",
    "getSystemControl": false
}'

Responses

🟢200成功

application/json

Body

success

boolean

required

code

integer

required

msg

string

required

data

object

required

rowid

string

required

ctime

string

required

caid

object

required

ownerid

object

required

utime

string

required

controlIds

array [object {2}]

required

Example

{
    "data": {
        "_id": "6773abdab945df4389d21c7f",
        "rowid": "0142c26c-144d-490b-8f58-7dd3b2221dfe",
        "ctime": "2024-12-31 16:31:22",
        "caid": {
            "email": "1@qq.com",
            "mobilePhone": "+8611111111111",
            "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
            "fullname": "bb",
            "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
            "isPortal": false,
            "status": 1
        },
        "uaid": {
            "email": "1@qq.com",
            "mobilePhone": "+8611111111111",
            "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
            "fullname": "bb",
            "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
            "isPortal": false,
            "status": 1
        },
        "ownerid": {
            "email": "1@qq.com",
            "mobilePhone": "+8611111111111",
            "accountId": "e2453de8-1a6a-4d4f-ba36-87fdff880a20",
            "fullname": "bb",
            "avatar": "https://p1.mingdaoyun.cn/UserAvatar/fe9c4374-68f1-4f64-88ea-47050dff28bd.jpg?imageView2/1/w/48/h/48/q/90",
            "isPortal": false,
            "status": 1
        },
        "utime": "2024-12-31 16:31:22",
        "autoid": 99,
        "60d42c197766e73dc71929a2": " Guilin Liangjiang International Airport ",
        "60d42c197766e73dc71929a3": "KWL",
        "60d42c197766e73dc71929a4": "ZGKL"
    },
    "success": true,
    "error_code": 1
}

🟠401没有权限

🟠404记录不存在