- PGOpenAPI简介
- 接口分级说明
- 请求测试
- 签名认证
- OpenAPI
- 邮局
- 对象存储
- 点鸭赛事
- 转发代理
- PG登录
- 点鸭数据表
- OpenSDK
[3]得到数据表数据
POST
dbs/cloud/get_table_data
数据表
最后修改时间：2025-02-02 04:11:10
责任人：冷鱼闲风
请求参数
Header 参数
X-Pgaot-Key
string
ky2令牌
示例值:
yR5zVNyFw+qrhO2IVwmqACPCRuYaR5nTB/TNquu5A+BmMXqMqO0B5DFBcngYY2jyg7m2A/r6r0n4MivUP+7Okg==
X-Pgaot-Sign
string
签名数据
示例值:
5D0715DCEAA2FCC7645553311A9234DDC8F2CBB83DC8EA3E7F925C1B9D83F245
X-Pgaot-Time
string
请求时时间戳
示例值:
1708410928240
Body 参数application/json
fields
string
字段筛选
sort
string
字段排序
filter
string
条件筛选
page
integer
页码
limit
integer
展示数
tableid
string
可选
type
string
可选
示例
{
"fields": "string",
"sort": "string",
"filter": "string",
"page": 0,
"limit": 0,
"tableid": "string",
"type": "string"
}示例代码
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.pgaot.com/dbs/cloud/get_table_data' \
--header 'X-Pgaot-Key: yR5zVNyFw+qrhO2IVwmqACPCRuYaR5nTB/TNquu5A+BmMXqMqO0B5DFBcngYY2jyg7m2A/r6r0n4MivUP+7Okg==' \
--header 'X-Pgaot-Sign: 5D0715DCEAA2FCC7645553311A9234DDC8F2CBB83DC8EA3E7F925C1B9D83F245' \
--header 'X-Pgaot-Time: 1708410928240' \
--header 'Content-Type: application/json' \
--data-raw '{
"fields": "string",
"sort": "string",
"filter": "string",
"page": 0,
"limit": 0,
"tableid": "string",
"type": "string"
}'返回响应
🟢200成功
application/json
Body
code
integer
必需
msg
string
必需
logid
string
必需
createdAt
integer
必需
count
integer
必需
fields
array [object {6}]
必需
createdAt
integer
必需
updatedAt
integer
必需
名称
string
必需
住址
string
必需
性别
string | null
必需
平均分
integer | null
必需
示例
{
"code": 200,
"msg": "查询数据成功",
"logid": "125171a4aeb0271871f3878adb74de41",
"createdAt": 1708592404,
"count": 4,
"fields": [
{
"createdAt": 1705472855,
"updatedAt": 1708409255,
"名称": " cscc3",
"住址": "cscsc",
"性别": null,
"平均分": null
},
{
"createdAt": 1705155976,
"updatedAt": 1705463051,
"名称": "云韶",
"住址": "地球",
"性别": "女",
"平均分": 85
},
{
"createdAt": 1704971477,
"updatedAt": 1705121027,
"名称": "海藻酸钠",
"住址": "化学星球",
"性别": "男scsc",
"平均分": null
},
{
"createdAt": 1704944344,
"updatedAt": 1705027670,
"名称": "冷鱼",
"住址": "冷鱼国",
"性别": "未知",
"平均分": null
}
]
}