Reference

Endpoint Delete documents

Name

delete_documents

Description

Deletes documents

Related Tables

[Dynamic Table] , [Dynamic Table]

Parameters

Parameter	Required	Options
Name: Index Label: Index

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length
ErrorFound	`DT_BOOL`	`bit`
Result	`DT_WSTR`	`nvarchar(4000)`	4000
HttpStatus	`DT_I4`	`int`
Id	`DT_WSTR`	`nvarchar(50)`	50
Index	`DT_WSTR`	`nvarchar(150)`	150
Type	`DT_WSTR`	`nvarchar(50)`	50
IndexUuid	`DT_WSTR`	`nvarchar(50)`	50
Reason	`DT_WSTR`	`nvarchar(4000)`	4000
ErrorType	`DT_WSTR`	`nvarchar(250)`	250
ErrorCausedByType	`DT_WSTR`	`nvarchar(250)`	250
ErrorCausedByreason	`DT_WSTR`	`nvarchar(2000)`	2000
Version	`DT_I4`	`int`
SequenceNo	`DT_I4`	`int`
PrimaryTerm	`DT_I4`	`int`
ShardsFailed	`DT_I4`	`int`
ShardsSuccessful	`DT_I4`	`int`
ShardsTotal	`DT_I4`	`int`
Took	`DT_I4`	`int`

If the column you are looking for is missing, consider customizing ElasticSearch Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Description
_id	`DT_WSTR`	`nvarchar(150)`	150

Required columns that you need to supply are bolded.

Examples

SSIS

Use ElasticSearch Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the [Dynamic Table] table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to delete documents:

API Destination - ElasticSearch

Read / write ElasticSearch data inside your app; perform many ElasticSearch operations without coding, just use easy to use high performance API Connector for ElasticSearch

ElasticSearch

[Dynamic Table]

Delete

Optional Parameters
DoNotAddMultiContentSeparator	True
Index

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Delete documents

-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!

delete_documents endpoint belongs to [Dynamic Table] , [Dynamic Table] table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Delete documents

DECLARE @MyQuery NVARCHAR(MAX) = '-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!';

EXEC (@MyQuery) AT [LS_TO_ELASTICSEARCH_IN_GATEWAY];

delete_documents endpoint belongs to [Dynamic Table] , [Dynamic Table] table(s), and can therefore be used via those table(s).