通过多主表id批量查询从表数据

接口说明

本接口通过多个主表记录，查询每个主表id对应的所有从表记录。
适用场景
通过多主表ids查询对应的所有从表记录。

SDK使用

请求参数

Path 参数

appId

string

应用id

必需

Header 参数

secretId

string

密钥

必需

randomStr

string

随机字符串

必需

sign

string

签名

必需

Body 参数application/json

entId

string

企业ID

必需

示例值:

企业ID

userId

string

用户ID

必需

示例值:

用户ID

appId

string

应用ID

必需

示例值:

应用ID

recordIds

string

必需

主表数据ids（一次最多支持十个）

示例值:

主表数据ids（一次最多支持十个）

slaveTableId

string

从表ID

必需

示例值:

从表ID

fields

string

可选

显示字段，例： "fields":"["id"]",

示例值:

显示字段，例： "fields":"[\"id\"]",

conditions

string

查询条件

可选

示例值:

查询条件

sort

string

可选

排序字段，例："sort":"[{"field":"shuzi","type":"asc"}]"

示例值:

排序字段，例："sort":"[{\"field\":\"shuzi\",\"type\":\"asc\"}]"

start

integer

当前页数

可选

perPage

integer

每页查询条数

可选

示例

{
    "entId": "企业ID",
    "userId": "用户ID",
    "appId": "应用ID",
    "recordIds": "主表数据ids（一次最多支持十个）",
    "slaveTableId": "从表ID",
    "fields": "显示字段，例： \"fields\":\"[\\\"id\\\"]\",",
    "conditions": "查询条件",
    "sort": "排序字段，例：\"sort\":\"[{\\\"field\\\":\\\"shuzi\\\",\\\"type\\\":\\\"asc\\\"}]\"",
    "start": 0,
    "perPage": 0
}

返回响应

🟢200成功

application/json

Body

result

array [object {3}]

必需

recordId

integer

必需

count

integer

必需

list

array [object]

必需

msg

string

成功

必需

code

integer

必需

guid

string

必需

status

integer

必需

originResp

string

必需

success

boolean

必需

uuid

string

必需

示例

{
    "msg": "成功",
    "result": [
        {
            "recordId": 2,
            "count": 1,
            "list": [
                {
                    "owner": "admin_pretest",
                    "zifuchuancongbiao": "从",
                    "modifier": "admin_pretest",
                    "created_at": "2022-03-30 16:31:54",
                    "app_key": "",
                    "access_write_fields": [
                        "zifuchuancongbiao",
                        "shuzicongbiao"
                    ],
                    "disable": 0,
                    "access_delete": "true",
                    "app_extend_key": "",
                    "id": 4,
                    "modified_method": "info/jiandandfyingyong",
                    "last_modified": "2022-03-30 16:31:54",
                    "shuzicongbiao": 1,
                    "access_write": "true"
                }
            ]
        },
        {
            "recordId": 3,
            "count": 1,
            "list": [
                {
                    "owner": "admin_pretest",
                    "zifuchuancongbiao": "test3-sub",
                    "modifier": "admin_pretest",
                    "created_at": "2022-03-29 16:40:10",
                    "app_key": "",
                    "access_write_fields": [
                        "zifuchuancongbiao",
                        "shuzicongbiao"
                    ],
                    "disable": 0,
                    "access_delete": "true",
                    "app_extend_key": "",
                    "id": 3,
                    "modified_method": "info/jiandandfyingyong",
                    "last_modified": "2022-03-29 16:40:10",
                    "shuzicongbiao": 3,
                    "access_write": "true"
                }
            ]
        }
    ],
    "code": 8010001,
    "originResp": "{\"result\":[{\"recordId\":2,\"count\":1,\"list\":[{\"owner\":\"admin_pretest\",\"zifuchuancongbiao\":\"从\",\"modifier\":\"admin_pretest\",\"created_at\":\"2022-03-30 16:31:54\",\"app_key\":\"\",\"access_write_fields\":[\"zifuchuancongbiao\",\"shuzicongbiao\"],\"disable\":0,\"access_delete\":\"true\",\"app_extend_key\":\"\",\"id\":4,\"modified_method\":\"info/jiandandfyingyong\",\"last_modified\":\"2022-03-30 16:31:54\",\"shuzicongbiao\":1,\"access_write\":\"true\"}]},{\"recordId\":3,\"count\":1,\"list\":[{\"owner\":\"admin_pretest\",\"zifuchuancongbiao\":\"test3-sub\",\"modifier\":\"admin_pretest\",\"created_at\":\"2022-03-29 16:40:10\",\"app_key\":\"\",\"access_write_fields\":[\"zifuchuancongbiao\",\"shuzicongbiao\"],\"disable\":0,\"access_delete\":\"true\",\"app_extend_key\":\"\",\"id\":3,\"modified_method\":\"info/jiandandfyingyong\",\"last_modified\":\"2022-03-29 16:40:10\",\"shuzicongbiao\":3,\"access_write\":\"true\"}]}],\"msg\":\"成功\",\"code\":1000000,\"status\":200}",
    "success": true,
    "guid": "81278aa502d7b10a",
    "uuid": "81278aa502d7b10a",
    "status": 200
}

通过多主表id批量查询从表数据

接口说明#

SDK使用#

请求参数

返回响应

接口说明

SDK使用