# Database import

Debugging tools

Interface should be called on the server side, seeHattori API

# Interface Dxplaination

# Interface name

dbImport

# Functional description

Through this interface can be imported into the database, if you encounter problems in the process, you canOpen Platform Service Provider ZonePosting exchanges.

# Calling mode

# HTTPS call


POST https://api.weixin.qq.com/componenttcb/dbimport?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
collection_name string yes Import 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 HTTP Upload files for the API API Upload)
file_type number yes Import file types, file formats refer to the file format part
stop_on_error boolean yes Whether to stop importing when an error is encountered
conflict_mode number yes Conflict Handling Model

# Return parameters

初始值 type Introductions
errcode number Error code
errmsg string Error message
job_id number Import the task ID, you can use theDatabase Migration Progress Query API Query Import Progress and Results

# Other Notes

# file_type The enumeration value of the

value Introductions
1 JSON
2 CSV

# conflict_mode The enumeration value of the

value Introductions
1 INSERT
2 UPSERT

# 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",
    "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