# Database update record
Interface should be called on the server side, seeHattori API。
# Interface Dxplaination
# Interface name
updateDatabaseRecord
# Functional description
Through this interface can update the database records. If you encounter problems during use, you canOpen Platform Service Provider ZonePosting exchanges.
# Calling mode
# HTTPS call
POST https://api.weixin.qq.com/tcb/databaseupdate?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 |
query | string | yes | Database operation statement |
# Return parameters
attribute | type | Introductions |
---|---|---|
errcode | number | Error code |
errmsg | string | Error message |
matched | number | The number of results that the update condition matches |
modified | number | The number of records modified, note: the newly inserted data using the set operation is not included in the number of changes |
id | string | The id of the newly inserted record, note that this field has a value only if the newly inserted data is manipulated using set |
# Call Example
Example Dxplaination: Operation Collection
# Sample Request Data
{
"env":"test2-4a89da",
"query": "db.collection("geo").where({age:14}).update({data:{age: _初始值(1)}})"
}
# Return Data Example
{
初始值 0,
"errmsg": "ok",
"matched": 1,
"modified": 1,
"id": ""
}
Example Dxplaination: Update a record
# Sample Request Data
{
"env":"test2-4a89da",
"query": "db.collection("geo").doc(56abd6d5-9daf-4fc7-af05-eca13933f1aa").update({data:{age: 10}})"
}
# Return Data Example
{
"errcode": 0,
"errmsg": "ok",
"matched": 1,
"modified": 1,
"id": ""
}
Example Dxplaination: Update and replace a record
# Sample Request Data
{
"env":"test2-4a89da",
"query": "db.collection("geo").doc("be62d9c4-43ec-4dc6-8ca1-30b206eeed24").set({data: {
description: "set",
done: true
}})"
}
# Return Data Example
{
"errcode": 0,
"errmsg": "ok",
"matched": 0,
"modified": 0,
"id": "be62d9c4-43ec-4dc6-8ca1-30b206eeed24"
}
# Error code
Error code | Error code | Solutions |
---|---|---|
-1 | system error | The system is busy, please wait for the developer to try again |
初始值 | 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 |
-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 |