查询数据列表
/openapi/v1/item/list
获取指定表格的数据列表。
请求参数
Body 参数application/json
table_id
integer
表格ID
filter
#/definitions/9184953可选
order
object {2}
排序
field_id
string
排序字段ID
type
string
排序类型
正序:asc,倒序:desc
limit
integer
每页条数
默认 20 条,最大 100 条
offset
integer
分页偏移量
默认为 0
示例
{
"table_id": "{{TABLE_ID}}",
"filter": {
"and": [
{
"field": "2200000137788634",
"query": {
"gte": 100
}
},
{
"field": "2200000137788650",
"query": {
"eq": [
"1"
]
}
}
]
},
"order": {
"field_id": "created_on",
"type": "desc"
},
"limit": 20,
"offset": 0,
"with_field_config": 0
}
示例代码
返回响应
成功(200)
HTTP 状态码: 200
内容格式: JSON
数据结构
object {0}
示例成功示例
{
"code": 0,
"message": "success",
"data": {
"items": [
{
"item_id": "2300000000000001",
"title": "数据标题",
"created_by": {
"user_id": "1024",
"name": "接口",
"avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/317474452/0?imageMogr2/thumbnail/128x128>"
},
"created_on": "2021-12-15 20:45:25",
"updated_by": {
"user_id": "1024",
"name": "接口",
"avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/317474452/0?imageMogr2/thumbnail/128x128>"
},
"updated_on": "2022-03-31 18:33:15",
"fields": {
"2200000137788628": "单行文本",
"2200000137788629": "多行文本1<br>多行文本2<br>多行文本3",
"2200000137788630": "<p><b>富文本1</b></p><p><font color=\"#dc0000\">富文本2</font></p><ol><li>富文本3</li><li>富文本4</li></ol>",
"2200000137788631": "18612345678",
"2200000137788632": "6954432710706",
"2200000137788634": 23456,
"2200000137788635": 0.85,
"2200000137788642": 234.56,
"2200000137788643": "2022-03-03",
"2200000137788644": "2022-03-03 00:00:00",
"2200000137788645": 23456,
"2200000137788646": 0.85,
"2200000137788647": "2022-03-03",
"2200000137788648": "2022-03-03 00:00:00",
"2200000137788650": [
{
"id": "1",
"name": "选项1"
}
],
"2200000137788651": [
{
"id": "1",
"name": "选项1"
},
{
"id": "2",
"name": "选项2"
}
],
"2200000137788652": [
{
"id": "1",
"name": "选项1"
}
],
"2200000137788653": [
{
"id": "1",
"name": "选项1"
},
{
"id": "2",
"name": "选项2"
}
],
"2200000137788654": [
{
"user_id": "1000001",
"name": "张三",
"avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/1000001/0?imageMogr2/thumbnail/128x128>"
}
],
"2200000137788655": [
{
"user_id": "1000001",
"name": "张三",
"avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/1000001/0?imageMogr2/thumbnail/128x128>"
},
{
"user_id": "1000002",
"name": "李四",
"avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/1000002/0?imageMogr2/thumbnail/128x128>"
}
],
"2200000137788659": [
{
"item_id": "2300000000000011",
"title": "数据标题1"
}
],
"2200000137788660": [
{
"item_id": "2300000000000011",
"title": "数据标题1"
},
{
"item_id": "2300000000000012",
"title": "数据标题2"
}
],
"2200000137788661": {
"poi": "青岛大学(浮山校区)",
"address": "山东省青岛市崂山区宁夏路308号",
"name": "青岛大学(浮山校区),山东省青岛市崂山区宁夏路308号",
"pcode": "370000",
"pname": "山东省",
"citycode": "0532",
"cityname": "青岛市",
"adcode": "370212",
"adname": "崂山区",
"coordinate": {
"lat": 36.071915,
"lon": 120.422859
}
},
"2200000137788663": [
{
"file_id": "188000001",
"name": "image.png",
"size": 300,
"link": {
"source": "https://hb-v4-attachment-oss.huoban.com/attachment/188000001/0",
"square": "https://hb-v4-attachment-oss.huoban.com/attachment/188000001/0?imageMogr2/thumbnail/!320x320r|imageMogr2/crop/320x320/gravity/center"
}
}
],
"2200000137788666": [
{
"file_id": "188000002",
"name": "file.zip",
"size": 500,
"link": {
"source": "https://hb-v4-attachment-oss.huoban.com/attachment/188000002/0"
}
}
],
"2200000137788667": {
"user": {
"user_id": "1000001",
"name": "张三",
"avatar": "https://hb-v4-public-oss.huoban.com/user_avatar/1000001/0?imageMogr2/thumbnail/128x128>"
},
"signature": {
"time": "2022-03-31 17:06:05",
"file": {
"file_id": "188000003",
"name": "signature.png",
"size": 9450,
"link": {
"source": "https://hb-v4-attachment-oss.huoban.com/attachment/188000003/0",
"square": "https://hb-v4-attachment-oss.huoban.com/attachment/188000003/0?imageMogr2/thumbnail/!320x320r|imageMogr2/crop/320x320/gravity/center"
}
}
}
}
}
}
]
},
"meta": {
"trace_id": "1650349377817634"
}
}
修改时间 2 年前