通过多主表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使用