ElasticSearch Connector
Documentation
Version: 5
Documentation

EndPoint Update documents


Name

update_documents

Description

Update documents

Parameters

Parameter Label Required Options Description
Index Index YES
Alias Alias (Deprecated - Use Index instead) NO

Output Columns

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

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
_id DT_WSTR nvarchar(150) 150 False
[$parent.Pivot_Path$] DT_WSTR nvarchar(4000) 4000 False
[$parent.Pivot_Path$].lat DT_R8 float False
[$parent.Pivot_Path$].lon DT_R8 float False
[$parent.Pivot_Path$].type DT_WSTR nvarchar(30) 30 False
[$parent.Pivot_Path$].coordinates DT_TEXT varchar(MAX) True
Required columns that you need to supply are bolded.