# Database import

Debugging tools

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