使用本文档前，请确认您已经拥有集简云开发平台的账户权限，如果还没有，请访问：https://www.jijyun.cn/open.html

获取表数据

开发中

POST

/v1/api/datatable/openapi/table/rows

最后修改时间：2024-07-10 10:16:06

[
{
"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

curl --location --request POST 'https://developer.jijyun.cn/v1/api/datatable/openapi/table/rows' \
--header 'data-table-apikey: 8Fa3Qljb90dsNgT4' \
--header 'Content-Type: application/json' \
--data-raw '{
  "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"
  }
   ] 
  ]
  
}'

返回响应

🟢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}}}

修改于 2024-07-10 10:16:06

获取表字段信息

新增行数据