When it's done we can start looking at how to play with those data in Forest Admin.
First, we declare the bank-accounts collection in the forest/ directory. In this Smart Collection, all fields are related to document mapping attributes except the field id that is computed using the document _id.
You MUST declare an id field when creating a Smart Collection. The value of this field for each record MUST be unique. On the following example, we simply use the UUID provided on every Elasticsearch documents.
You can add the option isSearchable: true to your collection to display the search bar. Note that you will have to implement the search yourself by including it into your own GET logic.
Implementing the routes
It's not an easy job to connect several data sources in the same structure. To accommodate you in this journey we already provide you a simple service ElasticsearchHelper that handles all the logic to connect with your Elasticsearch data.
Before getting further, in order to search your data using filters, we need to define the Elasticsearch configuration.
Name
Type
Description
index
string
The name of your Elasticsearch index.
filterDefinition
string
Type of your Elasticsearch fields. Can be number, date, text,keyword
sort
array of objects
mappingFunction
function
(optional) Required only to modify the data retrieved from Elasticsearch. Example: (id, source) => { id, ...source}
Our custom filter translator only support number, keyword, text, date data types. Nonetheless, you can implement more filter mapper type in theutils/filter-translator.js
Implementing the GET (all records)
In the file routes/bank-accounts.js, we’ve created a new route to implement the API behind the Smart Collection.
The logic here is to list all the BankAccount records. We use a custom service service/elasticsearch-helper.js for this example. The implementation code of this service is available here.
Finally, the last step is to serialize the response data in the expected format which is simply a standard JSON API document. You are lucky forest-express-sequelize already does this for you using the RecordSerializer.
To access the details view of a Smart Collection record, you have to catch the GET API call on a specific record. One more time, we use a custom service that encapsulates the Elasticsearch business logic for this example.
Now we are able to see all the bank accounts on Forest Admin, it’s time to implement the DELETE HTTP method in order to remove the documents on Elasticsearch when the authorized user needs it.
Delete a list a single record
/routes/bank-accounts.js
// Imports and ElasticsearchHelper base definition ...router.delete('/bank-accounts/:id',permissionMiddlewareCreator.delete(),async (request, response, next) => {try {awaitelasticsearchHelper.removeRecord(request.params.id);response.status(204).send(); } catch (e) {next(e); } });module.exports= router;