May 20, 2021 WeChat Mini Program Development Document
This interface should be called on the server side, as detailed in the service side API.
The database query record
POST https://api.weixin.qq.com/tcb/databasequery?access_token=ACCESS_TOKEN
| Property | Type | The default | Required | Description |
|---|---|---|---|---|
| access_token | string | Is | The interface calls the credentials | |
| Env | string | Is | Cloud environment ID | |
| query | string | Is | The database action statement |
The returned JSON packet
| Property | Type | Description |
|---|---|---|
| errcode | number | Error code |
| errmsg | string | The error message |
| pager | Object | Peddle information |
| data | Array.<string> | Record an array |
The legal value of errcode
| Value | Description | The lowest version |
|---|---|---|
| 0 | The request was successful | |
| -1 | System error | |
| -1000 | System error | |
| 40014 | AccessToken is illegal | |
| 40097 | The request parameter is wrong | |
| 40101 | Required parameters are missing | |
| 41001 | Missing AccessToken | |
| 42001 | AccessToken expires | |
| 43002 | HTTP METHOD error | |
| 44002 | POST BODY is empty | |
| 47001 | POST BODY format is incorrect | |
| 85088 | The APP is not open for cloud development | |
| Other error codes | Cloud development error code |
The structure of the pager
| Property | Type | Description |
|---|---|---|
| Offset | number | Offset |
| Limit | number | Single query limit |
| Total | number | The total number of records that meet the query criteria |
The query should use limit() to limit the number of single pulls, which defaults to 10.
{
"env":"test2-4a89da",
"query": "db.collection(\"geo\").where({done:true}).limit(10).skip(1).get()"
}
{
"errcode": 0,
"errmsg": "ok",
"pager": {
"Offset": 1,
"Limit": 10,
"Total": 2
},
"data": [
"{\"_id\":\"b15498af-1a5a-40b4-a4e7-b3fc4a1df482\",\"done\":true,\"name\":\"test\"}"
]
}
The database action statement syntax is the same as the database API