[TOC]
简要描述
请求URL
请求方式
参数
参数名 |
类型 |
说明 |
dbname |
string |
数据库文件名(注意区分大小写) |
sql |
string |
查询语句 |
发送示例
{
"dbname":"MSG0.db",
"sql":"select * from MSG where StrTalker = '25350948040@chatroom'"
}
返回示例
{
"data": [
{
"localId": "35",
"TalkerId": "10",
"MsgSvrID": "2587501163508675819",
"Type": "1",
"SubType": "0",
"IsSender": "0",
"CreateTime": "1658807627",
"Sequence": "1658807627000",
"StatusEx": "0",
"FlagEx": "0",
"Status": "2",
"MsgServerSeq": "1",
"MsgSequence": "763738230",
"StrTalker": "25350948040@chatroom",
"StrContent": "[炸弹]酒泉、武威等多个地市确定27号开始资格复审,8月6日面试,面试时间紧张,省市县乡面试有啥区别??老师正在讲,快来听课,听课入口:https://i.offcn.com/c/1095614?mis=lht74958\n\n[嘴唇]成绩排名还没发布,大家可以扫码查,出排名前报名面试班,交200抢占2000,最高优惠15000元,课程私聊即可咨询!!",
"Reserved0": "0",
"BytesExtra":"\n\b"
},
{
"localId": "36",
"TalkerId": "10",
"MsgSvrID": "5705531825961494711",
"Type": "3",
"SubType": "0",
"IsSender": "0",
"CreateTime": "1658807627",
"Sequence": "1658807627001",
"StatusEx": "0",
"FlagEx": "0",
"Status": "2",
"MsgServerSeq": "1",
"MsgSequence": "763738231",
"StrTalker": "25350948040@chatroom",
"StrContent": "<?xml version=\"1.0\"?>\n<msg>\n\t<img aeskey=\"e03658d85f4d491db938ec9919bccdb9\" encryver=\"0\" cdnthumbaeskey=\"\" cdnthumburl=\"\" cdnthumblength=\"0\" cdnthumbheight=\"0\" cdnthumbwidth=\"0\" cdnmidheight=\"0\" cdnmidwidth=\"0\" cdnhdheight=\"0\" cdnhdwidth=\"0\" cdnmidimgurl=\"\" length=\"0\" tpthumburl=\"https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&p=3\" tpthumblength=\"158989\" tpthumbheight=\"0\" tpthumbwidth=\"0\" tpthumbaeskey=\"e03658d85f4d491db938ec9919bccdb9\" tpurl=\"https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&p=2\" tplength=\"173494\" tpheight=\"2160\" tpwidth=\"2160\" tpauthkey=\"0A2B6F4E2D4D77415141414141436A6E4B576975452D756D687A67457A3348354A646E40696D2E7778776F726B10E083DCE706\" tphdurl=\"https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&p=1\" tphdlength=\"825300\" />\n</msg>\n",
"Reserved0": "0",
"BytesExtra":"\n\b"
}
]
}
返回参数说明
参数名 |
类型 |
说明 |
data |
string |
查询到的数据 |
备注