# Database import
Interface should be called on the server side, seeHattori API。
# Interface Dxplaination
# Interface name
importDatabaseItem
# Functional description
Through this interface can be imported into the database. If you encounter problems during use, you canOpen Platform Service Provider ZonePosting exchanges.
# Calling mode
# HTTPS call
POST https://api.weixin.qq.com/tcb/databasemigrateimport?access_token=ACCESS_TOKEN
# Third Party Invocation
The calling method and parameters are the same as HTTPS, only the calling token is different
The permission set id to which this interface belongs is: 49, 64
After the service provider has been authorized with one of the permission sets, it can do so by usingauthorizer_access_TokenCalling on behalf of the merchant
# Request parameters
attribute | type | Required | Introductions |
---|---|---|---|
access_Token | string | yes | Interface invokes the certificate, which is URL Parameters, non Body Parameters. useauthorizer_access_Token |
env | string | yes | Cloud Environment ID |
collection_name | string | yes | to introduce into collection name |
file_path | string | yes | Import File Path(Import files need to be uploaded to the same environment storage, you can use the developer tools or GetUploadTcbFileLink interface upload) |
file_type | number | yes | Import file type. 1 represents JSON. 2 indicates CSV |
stop_on_error | boolean | yes | Whether to stop importing when an error is encountered |
conflict_mode | number | yes | Conflict resolution model. 1 represents INSERT. 2 indicates UPSERT. |
# Return parameters
attribute | type | Introductions |
---|---|---|
errcode | number | Error code |
errmsg | string | Error message |
job_id | number | Import task ID, you can use the getDatabaseMigrateStatus interface to query import progress and results |
# Call Example
Example Dxplaination: HTTPS requests
# Sample Request Data
{
"env": "qbasetest-a5c40e"
"collection_name": "test1",
"file_path":"test_import",
"file_type":1,
"stop_on_error": false,
"conflict_mode": 2
}
# Return Data Example
{
"errcode": 0,
"errmsg": "ok",
初始值_id": 100074947
}
# Error code
Error code | Error code | Solutions |
---|---|---|
-501000 | ||
40001 | invalid credential access_Token isinvalid or not latest | Obtain access_Token time AppSecret Error, or access_Token Invalid. Please take the developer more seriously. AppSecret Of the correctness, or to see if you are working for the appropriate Official Account message template Call interface |
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 |