EndPoint Get documents from Index or Alias

Name

get_documents

Gets documents from Index or Alias [API reference]

Parameter

Label

Required

Options

Description

Index

YES

Query

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"} }

[API reference]

CursorTimeout

CursorTimeout (Minutes)

Enter this value carefully. Do not enter very long timeout else it will hold cursor longer on server memory space

PageSize

How many Record to fetch per request

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

Alias

Alias (Deprecated - Use Index instead)

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
_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`

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.

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

ElasticSearch

Get documents from Index or Alias

ElasticSearch

Get documents from Index or Alias