Reference

Endpoint List indexes

Name

list_indexes

Description

Lists indexes

Related Tables

Indexes

Parameters

Parameter Required Options
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Name DT_WSTR nvarchar(4000) 4000
Uuid DT_WSTR nvarchar(50) 50
Status DT_WSTR nvarchar(50) 50
Health DT_WSTR nvarchar(50) 50
Pri DT_I4 int
Rep DT_I4 int
DocsCount DT_I4 int
DocsDeleted DT_I4 int
StoreSize DT_WSTR nvarchar(50) 50
PriStoreSize DT_WSTR nvarchar(50) 50
Type DT_WSTR nvarchar(10) 10
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

This Endpoint belongs to the Indexes table, therefore it is better to use it, instead of accessing the endpoint directly:

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
Indexes
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Indexes table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to list indexes:

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
Indexes
Select
There are no parameters to configure.
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List indexes

Lists indexes 

SELECT * FROM Indexes

list_indexes endpoint belongs to Indexes 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:

List indexes

Lists indexes 

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

EXEC (@MyQuery) AT [LS_TO_ELASTICSEARCH_IN_GATEWAY];

list_indexes endpoint belongs to Indexes table(s), and can therefore be used via those table(s).