# Database aggregation

Interface should be called on the server side, seeHattori API。

# Interface Dxplaination

# Interface name

dbAggregate

# Functional description

Through this interface can be database aggregation, if you encounter problems in the course of use, you canOpen Platform Service Provider ZonePosting exchanges.

# Note

Database operation statement explaination: database operation statements syntax and database API is the same, Aggregation Operation ReferenceAggregate Document

# Calling mode

# HTTPS call


POST https://api.weixin.qq.com/componenttcb/dbaggregate?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
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
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