Elasticsearch

Github Discord Appsmith Cloud Community Forum
Search…
Elasticsearch
The following document assumes that you understand the basics of connecting to databases on Appsmith. If not, please go over them before reading further.
Connection Settings
The Elasticsearch plugin requires two pieces of information to establish a connection.
Click to expand
Host Address / Port*: Fill in the elasticsearch instance's address and port. This field supports multiple endpoints if that be the need.
Username / Password: The authentication detail for the elastic search instance. The password for your datasource is encrypted when it is stored within the Appsmith database.
Authorization Header: In case you choose to connect to your instance with another mechanism, you can use the Authorization Header field. This field is only considered when the Username and Password fields are empty.
After filling up the fields as described above, click on the "Test" button to verify the configuration and click "Save".
Querying Elasticsearch
Elasticsearch support a rich set of REST APIs that can be accessed using the Elasticsearch plugin in Appsmith. The plugin itself supports all requests that would use the GET, POST, PUT, or DELETE HTTP methods. These APIs support single as well as bulk queries, some of which are demonstrated below. Do note the leading / that needs to be added for each of these requests.
While Elasticsearch has a comprehensive reference list for its APIs, please make sure that you refer to specific documentation by your provider for requests that may or may not be applicable.
Creating a single document
As part of the Document API, you can create a single new document by using the POST URI /{index}/_doc/{id} with a JSON body that represents the document. For instance, the following request will create a document in the movies index with an id of 1.
1
Path: /movies/_doc/1
2
Body:
3
{
4
    "title": "Castle in the Sky",
5
    "director": "Hayao Miyazaki",
6
    "producer": "Isao Takahata",
7
    "release_date": "1986",
8
    "rt_score": "95"
9
}
Copied!
Creating multiple documents
Bulk additions can be done using the POST endpoint /_bulk, with a request body that specifies the index for each document separately as shown below. The following request will add 4 more documents in addition to the single indexed document we added in the previous request.
1
Path: /_bulk
2
Body:
3
{"index": {"_index": "movies", "_id": "2"}}
4
{"title":"Grave of the Fireflies", "director":"Isao Takahata", "producer":"Toru Hara", "release_date":"1988", "rt_score":"97"}
5
{"index": {"_index": "movies", "_id": "3"}}
6
{"title": "My Neighbor Totoro", "director": "Hayao Miyazaki", "producer": "Hayao Miyazaki", "release_date": "1988", "rt_score": "93"}
7
{"index": {"_index": "movies", "_id": "4"}}
8
{"title": "Kiki's Delivery Service", "director": "Hayao Miyazaki", "producer": "Hayao Miyazaki", "release_date": "1989", "rt_score": "96"}
9
{"index": {"_index": "movies", "_id": "5"}}
10
{"title": "Only Yesterday", "director": "Isao Takahata", "producer": "Toshio Suzuki", "release_date": "1991", "rt_score": "100"}
Copied!
Retrieving a single document
A single document can be accessed using it id within an index using a GET request that has the following path:
1
Path: /movies/_doc/2
Copied!
Searching through documents
Queries run on top of indexed documents can be configured using the GET method, without a JSON body. The following search query scans through the movies index created previously to return documents that match the query string.
1
Path: /movies/_search?q=Hayao%20Miyazaki
Copied!
Deleting a document
Deleting documents only requires a reference to the relevant id field that is sent across in a DELETE request. The request below will return with the deleted resource if it exists.
1
Path: /movies/_doc/5
Copied!
Using Queries in applications
Once you have successfully run a Query, you can use it in your application to
​Display Data​
​Capture Data​
Datasource Reference - Previous
DynamoDB
Next - Datasource Reference
Firestore
Last modified 8mo ago
Copy link
Contents
Connection Settings
Querying Elasticsearch
Creating a single document
Creating multiple documents
Retrieving a single document
Searching through documents
Deleting a document
Using Queries in applications