- 开发指南
- 工作区
- 表格数据
- 数据仓库数据
- 文件
- 订阅
- 服务商
查询数据列表
POST
https://api.huoban.com/openapi/v1/dw_item/list
请求参数
Header 参数
Open-Authorization
string
必需
默认值:
Bearer {{API_KEY}}
Body 参数application/json
table_id
integer
表格ID
filter
筛选器
Any of
One of
order
object
排序
field_id
string
排序字段ID
type
string
排序类型
limit
integer
每页条数
offset
integer
分页偏移量
示例
{
"table_id": "{{EXT_TABLE_ID}}",
"filter": {
"and": [
{
"field": "2200000137788634",
"query": {
"gte": 100
}
},
{
"field": "2200000137788650",
"query": {
"eq": [
"1"
]
}
}
]
},
"order": {
"field_id": "created_on",
"type": "desc"
},
"limit": 20,
"last_item_id": "",
"with_field_config": 0
}
示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST 'https://api.huoban.com/openapi/v1/dw_item/list' \
--header 'Open-Authorization;' \
--header 'Content-Type: application/json' \
--data-raw '{
"table_id": "{{EXT_TABLE_ID}}",
"filter": {
"and": [
{
"field": "2200000137788634",
"query": {
"gte": 100
}
},
{
"field": "2200000137788650",
"query": {
"eq": ["1"]
}
}
]
},
"order": {
"field_id": "created_on",
"type": "desc"
},
"limit": 20,
"last_item_id": "",
"with_field_config": 0
}'
返回响应
🟢200成功
application/json
Body
code
integer
错误码
message
string
错误信息
data
object
返回数据
items
array[object (数据) {7}]
数据列表
meta
object
元数据
trace_id
string
请求ID
示例
{
"code": 0,
"message": "string",
"data": {
"items": [
{
"item_id": "string",
"title": "string",
"created_on": "string",
"created_by": {},
"updated_on": "string",
"updated_by": {},
"fields": [
{}
]
}
]
},
"meta": {
"trace_id": "string"
}
}
修改于 2022-07-04 02:22:16