获取表数据 - 集简云开发平台接口文档

[
{
"label": "大于(数值)",
"value": "gt"
},
{
"label": "大于等于(数值)",
"value": "gte"
},
{
"label": "小于(数值)",
"value": "lt"
},
{
"label": "小于等于(数值)",
"value": "lte"
},
{
"label": "不等于(数值)",
"value": "ne"
},
{
"label": "等于",
"value": "eq"
},
{
"label": "开头是(文本)",
"value": "begin"
},
{
"label": "结尾是(文本)",
"value": "end"
},
{
"label": "开头不是(文本)",
"value": "beginnot"
},
{
"label": "结尾不是(文本)",
"value": "endnot"
},
{
"label": "包含(文本)",
"value": "in"
},
{
"label": "不包含(文本)",
"value": "notin"
},
{
"label": "为空",
"value": "null"
},
{
"label": "不为空",
"value": "notnull"
},
{
"label": "早于(日期时间)",
"value": "before"
},
{
"label": "晚于(日期时间)",
"value": "after"
},
{
"label": "等于(日期时间)",
"value": "eqd"
}
]

请求参数

Header 参数

data-table-apikey

string

可选

示例值:

8Fa3Qljb90dsNgT4

Body 参数application/json

table_id

string

必需

page

string

0开始

可选

page_size

string

可选

最大1000，超过1000返回1000

sort

string

可选

排序字段+空格+排序方式示例：create_time asc

conditions

array [array]

可选

筛选条件组，多个为或的关系

object

条件对象

可选

示例

{
  "table_id": "CQVIZW1691652056540119632",
  "page": "0",
  "page_size": "20",
  "sort": "create_time asc",
  "conditions": [
    [
      {
        "column": "rlsgjahfvukx",
        "condition": "lte",
        "value": "2023-12-29 14:12:04"
      },
      {
        "column": "rlsgjahfvukx",
        "condition": "eq",
        "value": "2023-08-10T15:20:56"
      }
    ]
  ]
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

返回响应

🟢200成功

application/json

Body

Code

integer

必需

Msg

string

必需

Data

object

必需

rows

array [object {12}]

必需

page_info

object

必需

示例

{
  "Code": 2000,
  "Msg": "成功",
  "Data": {
    "rows": [
      {
        "row_id": "JYVWMU1691652056602950671",
        "rlsgjahfvukx": "",
        "gfqeyodkipsa": null,
        "yafrclwbhisv": null,
        "create_time": "2023-08-10T15:20:56",
        "update_time": "2023-08-25T16:14:08",
        "rxmtpkliwngj": "5",
        "rvbyajcmelnk": null,
        "ayuqwdkcgnjr": null,
        "creator_id": null,
        "updater_id": "yc4905bw",
        "coegxmzwrfph": null
      },
      {
        "row_id": "KCYNSH1691652056602931541",
        "rlsgjahfvukx": "0000-00-00 00:00:00",
        "gfqeyodkipsa": null,
        "yafrclwbhisv": null,
        "create_time": "2023-08-10T15:20:56",
        "update_time": "2023-08-25T16:14:11",
        "rxmtpkliwngj": "6",
        "rvbyajcmelnk": null,
        "ayuqwdkcgnjr": null,
        "creator_id": null,
        "updater_id": "yc4905bw",
        "coegxmzwrfph": null
      },
      {
        "row_id": "QYORLE1691652056602891463",
        "rlsgjahfvukx": "0000-00-00 00:00:00",
        "gfqeyodkipsa": "36",
        "yafrclwbhisv": null,
        "create_time": "2023-08-10T15:20:56",
        "update_time": "2023-08-25T16:14:14",
        "rxmtpkliwngj": "7",
        "rvbyajcmelnk": null,
        "ayuqwdkcgnjr": null,
        "creator_id": null,
        "updater_id": null,
        "coegxmzwrfph": null
      }
    ],
    "page_info": {
      "current_page": 0,
      "total": 3
    }
  }
}