ElasticSearch Connector
Documentation
Version: 5
Documentation
Endpoint

Get document by ID from Index or Alias


Name

get_document

Description

No description available

Related Tables

[Dynamic Table] , [Dynamic Table]

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
If the column you are looking for is missing, consider customizing ElasticSearch Connector.

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.

Examples

SSIS

Use ElasticSearch Connector in API Source component to read data or in API Destination component to read/write data:

Lookup a row in [Dynamic Table] table using API Destination

This Endpoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

ElasticSearch
[Dynamic Table]
Lookup
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get document by id from index or alias

SELECT * FROM get_document
WHERE _id = 'abcd-1234-id'

get_document 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:

Get document by id from index or alias

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_document
WHERE _id = ''abcd-1234-id''';

EXEC (@MyQuery) AT [LS_TO_ELASTICSEARCH_IN_GATEWAY];

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