Reference

Endpoint Search / Query documents

Name

search

Description

Gets documents (Using JSON Query Language) [API reference]

Parameters

Parameter Required Options
Name: Index

Label: Index

 YES
Name: Query

Label: Enter Query (JSON Format)
Option Value
All Records {"match_all": { } }
Record where comment or name contains TV word {"query_string": {"query": "comment:TV OR name:TV"} }
Record with comment field (attribute exists) {"query_string": {"query": "_exists_:comment"} }
Name: CursorTimeout

Label: CursorTimeout (Minutes)

Enter this value carefully. Do not enter very long timeout else it will hold cursor longer on server memory space
Option Value
1 1
2 2
5 5
10 10
60 60
180 180
Name: PageSize

Label: How many Record to fetch per request

Do not enter very large number or too small number to avoid performance issues.
Name: Alias

Label: Alias (Deprecated - Use Index instead)

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
_id DT_WSTR nvarchar(150) 150
_score DT_R8 float
[$parent.Pivot_Path$] DT_WSTR nvarchar(4000) 4000
[$parent.Pivot_Path$].lat DT_R8 float
[$parent.Pivot_Path$].lon DT_R8 float
[$parent.Pivot_Path$].type DT_WSTR nvarchar(30) 30
[$parent.Pivot_Path$].coordinates DT_TEXT varchar(MAX)
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 / write ElasticSearch data inside your app; perform many ElasticSearch operations without coding, just use easy to use high performance API Connector for ElasticSearch
ElasticSearch
Search / Query documents
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

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
Search / Query documents
There are no parameters to configure.
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Search / query documents 

SELECT * FROM search

SQL Server

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

Search / query documents 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM search';

EXEC (@MyQuery) AT [LS_TO_ELASTICSEARCH_IN_GATEWAY];