Right now, I’m using the MongoDB connector to receive a simple list of all records from a collection called “allStores” in my database to display a basic Pivot Table.
The default behaviour is that all the documents/records from the index allStores are shown. My use case requires me to perform some complicated MongoDB $aggregation pipelines on this index allStores before it can be used on the Pivot Table for data analysis.
Therefore, how do I go about customizing the initial and all subsequent queries on my “index” collection?
Look forward to your valuable feedback.
Thank you for contacting us.
We want to explain that Flexmonster MongoDB Connector serves as a proxy between Flexmonster and MongoDB database. It is responsible for converting Flexmonster’s requests to the corresponding MongoDB queries and translating MongoDB responses to the custom data source API structure.
If you want to expand this functionality, we suggest developing a custom connector that would implement the desired logic. You are welcome to use our MongoDB Connector source code as a base for your custom implementation.
Also, please note that Flexmonster still communicates with your back-end through the custom data source API protocol. It means the connector needs to accept and return the data structured accordingly to this protocol.
In the Custom API requests section, you will find all the API’s front-end and back-end specifications.
We hope it helps.
Feel free to contact us in case other questions arise.