wxhook

微信


查询聊天消息

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

页面列表

ITEM_HTML