EndPoint Search / Query documents

Contents

Name

Gets documents (Using JSON Query Language) [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.