> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ExecuteSqlRequest

> ExecuteSqlRequest — Kinetica Node.js API

interface ExecuteSqlRequest \{\
&#x20;[data](#data)?: string\[];\
&#x20;[encoding](#encoding)?: string;\
&#x20;[limit](#limit)?: number;\
&#x20;[offset](#offset)?: number;\
&#x20;[options](#options)?: Record\<string, string>;\
&#x20;[request\_schema\_str](#request_schema_str)?: string;\
&#x20;[statement](#statement): string;\
}

<ul>
  <li>Defined in [src/types.ts:2606](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L2606)</li>
</ul>

##### Index

### Properties

[data?](#data) [encoding?](#encoding) [limit?](#limit) [offset?](#offset) [options?](#options) [request\_schema\_str?](#request_schema_str) [statement](#statement)&#x20;

## Properties

### `Optional`data

data?: string\[]

An array of binary-encoded data for the records to be binded to the SQL query. Or use query\_parameters to pass the data in JSON format.

<ul>
  <li>Defined in [src/types.ts:2627](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L2627)</li>
</ul>

### `Optional`encoding

encoding?: string

Specifies the encoding for returned records; one of 'binary', 'json' or 'arrow'.

<ul>
  <li>Defined in [src/types.ts:2623](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L2623)</li>
</ul>

### `Optional`limit

limit?: number

A positive integer indicating the maximum number of results to be returned, or END\_OF\_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned. The number of records returned will never exceed the server's own limit, defined by the max\_get\_records\_size parameter in the server configuration. Use `has_more_records` to see if more records exist in the result to be fetched, and `offset` and `limit` to request subsequent pages of results.

<ul>
  <li>Defined in [src/types.ts:2621](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L2621)</li>
</ul>

### `Optional`offset

offset?: number

A positive integer indicating the number of initial results to skip (this can be useful for paging through the results).

<ul>
  <li>Defined in [src/types.ts:2610](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L2610)</li>
</ul>

### `Optional`options

options?: Record\<string, string>

Optional parameters.

<ul>
  <li>Defined in [src/types.ts:2629](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L2629)</li>
</ul>

### `Optional`request\_schema\_str

request\_schema\_str?: string

Avro schema of `data`.

<ul>
  <li>Defined in [src/types.ts:2625](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L2625)</li>
</ul>

### statement

statement: string

SQL statement (query, DML, or DDL) to be executed.

<ul>
  <li>Defined in [src/types.ts:2608](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L2608)</li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.