forked from Gitee 极速下载/tooljet

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

文件

.do

.github

.husky

.vscode

cli

cypress-tests

deploy

docker

docs

docs

src

static

versioned_docs

version-1.x.x

Enterprise

actions

contributing-guide

data-sources

_category_.json

airtable.md

amazonses.md

appwrite.md

athena.md

baserow.md

bigquery.md

clickhouse.md

cosmosdb.md

couchdb.md

custom-js.md

dynamodb.md

elasticsearch.md

firestore.md

gcs.md

google.sheets.md

graphql.md

influxdb.md

mailgun.md

mariadb.md

minio.md

mongodb.md

mssql.md

mysql.md

n8n.md

notion.md

openapi.md

oracledb.md

postgresql.md

redis.md

restapi.md

rethinkdb.md

s3.md

saphana.md

sendgrid.md

slack.md

smtp.md

snowflake.md

stripe.md

twilio.md

typesense.md

woocommerce.md

zendesk.md

how-to

setup

tutorial

user-authentication

widgets

intro.md

marketplace.md

security.md

tracking.md

version-2.0.0-beta-zh

version-2.0.0

version-2.1.0

versioned_sidebars

.dockerignore

.gitignore

Dockerfile

README.md

babel.config.js

docusaurus.config.js

firebase.json

netlify.toml

package-lock.json

package.json

sidebars.js

versions.json

yarn.lock

zh.Dockerfile

frontend

marketplace

plugins

server

.dockerignore

.env.example

.eslintignore

.gitattributes

.gitignore

.nvmrc

.slugignore

.version

Aptfile

CODE_OF_CONDUCT.md

CONTRIBUTING.md

LICENSE

Procfile

README.md

app.json

docker-compose.yaml

heroku-postbuild.sh

netlify.toml

package-lock.json

package.json

render.yaml

克隆/下载

elasticsearch.md 3.06 KB

---
id: elasticsearch
title: Elasticsearch
---

# Elasticsearch
ToolJet can connect to your Elasticsearch cluster to read and write data.

## Connection 
Please make sure the host/IP of the Elasticsearch cluster is accessible from your VPC if you have self-hosted ToolJet. If you are using ToolJet cloud, please **whitelist our IP**.

To add a new Elasticsearch database, click on the `+` button on data sources panel at the left-bottom corner of the app editor. Select Elasticsearch from the modal that pops up.

ToolJet requires the following to connect to your Elasticsearch cluster: 
- **Host**
- **Port**
- **Username**
- **Password**

<div style={{textAlign: 'center'}}>

<img className="screenshot-full" src="/img/datasource-reference/elasticsearch/connect.png" alt="Elastic connect" />

</div>

Elastic search datasource is also providing an option for connecting services with ssl certificates. 
- You can either use CA / Client certificates option. 
  
<img className="screenshot-full" src="/img/datasource-reference/elasticsearch/ssl.png" alt="Elastic ssl" />

## Querying Elasticsearch

Click on `+` button of the query manager at the bottom panel of the editor and select the Elasticsearch added in the previous step as the data source. 
Select the operation that you want to perform on your Elasticsearch cluster and click `Create` to save the query.

<div style={{textAlign: 'center'}}>

<img className="screenshot-full" src="/img/datasource-reference/elasticsearch/query.png" alt="Elastic query" />

</div>

:::tip
Query results can be transformed using transformations. Read our transformations documentation to see how: **[link](/docs/tutorial/transformations)**
:::

## Supported operations

#### Search

This operation allows you to execute a search query and get back search hits that match the query. Read the Elasticsearch's `Search` guide **[here](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-search.html)**.

<img className="screenshot-full" src="/img/datasource-reference/elasticsearch/elastic-search.png" alt="Elastic search" />

#### Index a document

This operation allows you to add a JSON document to the specified data stream or index. Read the Elasticsearch's `Index` guide **[here](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-index_.html)**.

<img className="screenshot-full" src="/img/datasource-reference/elasticsearch/index.png" alt="Elastic index"/>

#### Get a document

This operation allows you to retrieve the specified JSON document from the index. Read the Elasticsearch's `Get` guide **[here](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-get.html)**.

<img className="screenshot-full" src="/img/datasource-reference/elasticsearch/get.png"  alt="Elastic get"/>

#### Update a document

This operation allows to update a document using the specified script. Read the Elasticsearch's `Update` guide **[here](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-update.html)**.

<img className="screenshot-full" src="/img/datasource-reference/elasticsearch/update.png" alt="Elastic update" />

一键复制原始数据按行查看历史

提交于 3年前 . Versioning for Docusaurus (#4926)

Elasticsearch

id	title
elasticsearch	Elasticsearch

Elasticsearch

ToolJet can connect to your Elasticsearch cluster to read and write data.

Connection

Please make sure the host/IP of the Elasticsearch cluster is accessible from your VPC if you have self-hosted ToolJet. If you are using ToolJet cloud, please whitelist our IP.

To add a new Elasticsearch database, click on the + button on data sources panel at the left-bottom corner of the app editor. Select Elasticsearch from the modal that pops up.

ToolJet requires the following to connect to your Elasticsearch cluster:

Host
Port
Username
Password

Elastic connect

Elastic search datasource is also providing an option for connecting services with ssl certificates.

You can either use CA / Client certificates option.

Elastic ssl

Querying Elasticsearch

Click on + button of the query manager at the bottom panel of the editor and select the Elasticsearch added in the previous step as the data source. Select the operation that you want to perform on your Elasticsearch cluster and click Create to save the query.

Elastic query

:::tip Query results can be transformed using transformations. Read our transformations documentation to see how: link :::

Supported operations

Search

This operation allows you to execute a search query and get back search hits that match the query. Read the Elasticsearch's Search guide here.

Index a document

This operation allows you to add a JSON document to the specified data stream or index. Read the Elasticsearch's Index guide here.

Elastic index

Get a document

This operation allows you to retrieve the specified JSON document from the index. Read the Elasticsearch's Get guide here.

Elastic get

Update a document

This operation allows to update a document using the specified script. Read the Elasticsearch's Update guide here.

Elastic update

Loading...

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

JavaScript

1

https://gitee.com/wanddyh/tooljet.git

git@gitee.com:wanddyh/tooljet.git

wanddyh

tooljet

tooljet

develop