getSelectResult

getSelectResult(mongoDBInstance: Db instance, index: String, query: Object, page: Object)

[starting from version: 2.8]

This API call allows getting the data from a MongoDB database. Used in the handler of the Flexmonster /select request. The getSelectResult method is a part of the Flexmonster MongoDB Connector API.

Parameters: 

• mongoDBInstance – Db instance. The instance of the needed MongoDB database.
• index – String. The collection’s name. index is sent in the body of the Flexmonster request.
• query – Object. query is sent in the body of the Flexmonster request.
• page – Object. Has the following properties:
  • pageNumber – Number. Page number. Used to load members by parts. Starts from 0. pageNumber is sent in the body of the Flexmonster request.
  • pageToken – String. A key calculated on the server that defines which part of the data should be loaded next. pageToken is sent in the body of the Flexmonster request.

Returns

Array of objects, which contains the aggregated data. The response format for compact and classic tables is the same as in the /select request for the pivot table. The response for the flat table corresponds to the response of the /select request for the flat table.

Example

mongo.post("/select", async (req, res) => {
    try {
        const result = await MongoDataAPI.getSelectResult(mongoDBInstance, req.body.index, req.body.query,{ page: req.body.page, pageToken: req.body.pageToken });
        res.json(result);
    } catch (err) { }
});

See also

getSchema
getMembers