ElasticSearch Connector
Documentation
Version: 5
Documentation

EndPoint Get document by ID from Index or Alias


Name

get_document

Description

No description available

Parameters

Parameter Label Required Options Description
Id Enter Document ID YES
Index Index YES
Alias Alias (Deprecated - Use Index instead) NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
_id DT_WSTR nvarchar(150) 150 False
_score DT_R8 float 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) False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.