[TOC]
简要描述
请求URL
请求方式
参数
参数名 |
类型 |
说明 |
dbname |
string |
数据库文件名(注意区分大小写) |
sql |
string |
查询语句 |
发送示例
{
"dbname":"MSG0.db",
"sql":"select * from MSG limit 2"
}
返回示例
{
"data": [
{
"localId": "1",
"TalkerId": "1",
"MsgSvrID": "8411306876558530937",
"Type": "1",
"SubType": "0",
"IsSender": "1",
"CreateTime": "1657456857",
"Sequence": "1657456857000",
"StatusEx": "0",
"FlagEx": "0",
"Status": "2",
"MsgServerSeq": "0",
"MsgSequence": "0",
"StrTalker": "filehelper",
"StrContent": "haha666",
"Reserved0": "0",
"BytesExtra":"$\b f422de16a450607ca514e688b0a89235"
},
{
"localId": "2",
"TalkerId": "2",
"MsgSvrID": "8248358209354624495",
"Type": "34",
"SubType": "0",
"IsSender": "0",
"CreateTime": "1657456865",
"Sequence": "1657456865000",
"StatusEx": "0",
"FlagEx": "0",
"Status": "2",
"MsgServerSeq": "1",
"MsgSequence": "763728862",
"StrTalker": "wxid_7jcwnh1hfaka22",
"StrContent": "<msg><voicemsg endflag=\"1\" cancelflag=\"0\" forwardflag=\"0\" voiceformat=\"4\" voicelength=\"6397\" length=\"10750\" bufid=\"796522310088982944\" aeskey=\"727562667567737266796f6a74646854\" voiceurl=\"3052020100044b30490201000204c53fdf6f02033d14b902046b692fb7020462cac8e1042462633166626465332d376665622d343865652d383132322d64326366613034353734333802040128000f0201000400373940b2\" voicemd5=\"db859a0c59c125d9abca13643aa64d88\" clientmsgid=\"416239303931363362353434353664005720400710222ba8da479e1123\" fromusername=\"wxid_123456\" /></msg>",
"Reserved0": "0",
"BytesExtra":"\n\b"
},
]
}
返回参数说明
参数名 |
类型 |
说明 |
data |
string |
查询到的数据 |
备注