Endpoint Delete Index
Name
delete_index
Description
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: Index to delete |
YES |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Acknowledged |
DT_BOOL
|
bit
|
||
| Name |
DT_WSTR
|
nvarchar(255)
|
255 | |
| ErrorStatus |
DT_I4
|
int
|
||
| ErrorReason |
DT_WSTR
|
nvarchar(1000)
|
1000 | |
| ErrorType |
DT_WSTR
|
nvarchar(255)
|
255 | |
| ErrorId |
DT_WSTR
|
nvarchar(255)
|
255 | |
| ErrorIndex |
DT_WSTR
|
nvarchar(255)
|
255 |
If the column you are looking for is missing, consider customizing ElasticSearch Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use ElasticSearch Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - ElasticSearch
Read and write Elasticsearch data effortlessly. Integrate, manage, and automate indexes and documents — almost no coding required.
ElasticSearch
Delete Index
| Required Parameters | |
|---|---|
| Index to delete | Fill-in the parameter... |
| Optional Parameters | |
| ContineOn404Error | True |
| ConsumeResponseOnError | True |
API Destination
API Destination - ElasticSearch
Read and write Elasticsearch data effortlessly. Integrate, manage, and automate indexes and documents — almost no coding required.
ElasticSearch
Delete Index
| Required Parameters | |
|---|---|
| Index to delete | Fill-in the parameter... |
| Optional Parameters | |
| ContineOn404Error | True |
| ConsumeResponseOnError | True |
ODBC application
Use these SQL queries in your ODBC application data source:
Delete an existing index
<p>Deletes an existing index. Supply the index name in the <code>WITH</code> clause. Use <code>ContineOn404Error=1</code> to avoid errors when the index does not exist.</p>
SELECT * FROM delete_index WITH(Name='my_index_name', ContineOn404Error=1 )SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Delete an existing index
<p>Deletes an existing index. Supply the index name in the <code>WITH</code> clause. Use <code>ContineOn404Error=1</code> to avoid errors when the index does not exist.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_index WITH(Name=''my_index_name'', ContineOn404Error=1 )';
EXEC (@MyQuery) AT [LS_TO_ELASTICSEARCH_IN_GATEWAY];