# Database export
Interface should be called on the server side, seeHattori API。
# Interface Dxplaination
# Interface name
dbExport
# Functional description
Through this interface can be exported to the database, if you encounter problems during use, you canOpen Platform Service Provider ZonePosting exchanges.
# Note
- Dxplaination of Export Conditions: Query Statement Syntax anddata base APISame.
# Calling mode
# HTTPS call
POST https://api.weixin.qq.com/componenttcb/dbexport?access_token=ACCESS_TOKEN
# Request parameters
| attribute | type | Required | Introductions |
|---|---|---|---|
| access_Token | string | yes | Interface invokes the certificate, which is URL Parameters, non Body Parameters. usecomponent_access_Token |
| env | string | yes | Cloud Environment ID |
| file_path | string | yes | Export file path (files are exported to public cloud storage and can be accessed usingGet the download link API Get the download link) |
| file_type | number | yes | Export document type, 1 represents JSON2 indicates CSV. File Format ReferenceDatabase Import Guidelinesto hit the target file format part |
| query | string | yes | Export conditions. |
# Return parameters
| attribute | type | Introductions |
|---|---|---|
| errcode | number | Error code |
| errmsg | string | Error message |
| job_id | number | Export the task ID, using theDatabase Migration Progress Query API Query the export result, get the file download link. |
# Call Example
Example Dxplaination: HTTPS requests
# Sample Request Data
{
"env":"test2-4a89da",
"file_path":"test_export",
"file_type":1,
"query":"const Point = db.Geo.Pointdb.collection('geo').where({name: 'x',age: _.gt(10).and(_.lt(20)),loc: new Point(113,23),array: [1,2]}).limit(10).skip(1).orderBy('age','asc').orderBy('name', 'desc').field({ name: true }).get()"
}
# Return Data Example
{
"errcode": 0,
"errmsg": "ok",
"job_id": 100074947
}
# Error code
| Error code | Error code | Solutions |
|---|---|---|
| 0 | ok | ok |
| -1 | system error | The system is busy, please wait for the developer to try again |
| -1000 | system error | System error |
| 40014 | invalid access_Token | Illegal access_Token Please take the developer seriously. access_Token Of the validity (such as whether it is expired), or to see if you are working for the appropriate Official Account message template Call interface |
| 40097 | invalid args | Parameter error |
| 40101 | missing parameter | Missing required parameters |
| 41001 | access_Token missing | lack access_Token parameter |
| 42001 | access_Token expired | access_Token Timeout, please check access_Token Of the validity period, please refer to the Basic Support - Obtain access_Token Middle, right. access_Token Detailed mechanism explaination of the |
| 43002 | require POST method | Need POST request |
| 44002 | empty post data | POST The packet is empty. |
| 47001 | data format error | analysis JSON/XML Content errorpost Missing parameters in the dataCheck for corrections and try again. |
| 85088 | no qbase privilege | The app is not open for cloud development |