# Database aggregation

<a href="https://developers.weixin.qq.com/初始值 target="_blank" class="api-explorer" > Debugging tools

Interface should be called on the server side, seeHattori API

# Interface Dxplaination

# Interface name

aggregateDatabase

# Functional description

This interface allows database aggregation. If you encounter problems during use, you canOpen Platform Service Provider ZonePosting exchanges

# Calling mode

# HTTPS call


POST https://api.weixin.qq.com/tcb/databaseaggregate?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
data array Record array

# Call Example

Example Dxplaination: HTTPS requests

# Sample Request Data


{
  "env":"test2-4a89da",
  "query": "db.collection(" test_collection").aggregate(). match({tags:"cloud"}).limit(10).end()"
} 

# Return Data Example


{
    "errcode": 0,
    "errmsg": "ok",
    "data": [
    "{"_id":f77e039f-f1cf-4aa8-bd59-16cbaa91e6ea","location":{"type":"Point","coordinates":[{"$numberDouble":"113.0"},{"$numberDouble":"23.0"}]},"done":false,"description":"learn cloud database","due":"2019-09-09","tags":["cloud","database"]}",
        "{"_id":6bb88938-49ea-42b6-a6f5-ce408970cfc6","due":"2019-09-09","tags":["cloud","database"],"location":{"type":"Point","coordinates":[{"$numberDouble":"113.0"},{"$numberDouble":"23.0"}]},"done":false,"description":" Study cloud database"}",
        "{"_id":"51F4F67E-A6A1-4C3E-A50F-827380B8DA86","description":" Study cloud database","due":"2019-09-09","tags":["cloud","database"],"location":{"coordinates":[{"$numberDouble":"113.0"},{"$numberDouble":"23.0"}],"type":"Point"},"done":false}",
        "{"_id":"ee1d69da-b7ec-4e7a-bc1f-2fae31da4ce0","tags":["cloud","database"],"location":{"type":"Point","coordinates":[{"$numberDouble":"113.0"},{"$numberDouble":"23.0"}]},"done":false,"description":" Study cloud database","due初始值"2019-09-09"}"
    ]
} 

# Error code

Error code Error code Solutions
-501000
-1 system error The system is busy, please wait for the developer to try again
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
-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