> ## 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.

# ExecuteSqlResponse

> ExecuteSqlResponse — Kinetica JavaScript API

interface ExecuteSqlResponse \{\
&#x20;[binary\_encoded\_response](#binary_encoded_response): string;\
&#x20;[count\_affected](#count_affected): number;\
&#x20;[data](#data): [DynamicSchemaData](https://docs.kinetica.com/content/api/javascript/interfaces/DynamicSchemaData.md);\
&#x20;[has\_more\_records](#has_more_records): boolean;\
&#x20;[info](#info): Record\<string, string>;\
&#x20;[json\_encoded\_response](#json_encoded_response): string;\
&#x20;[paging\_table](#paging_table): string;\
&#x20;[request\_time\_secs](#request_time_secs)?: number;\
&#x20;[response\_schema\_str](#response_schema_str): string;\
&#x20;[total\_number\_of\_records](#total_number_of_records): number;\
}

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

##### Index

### Properties

[binary\_encoded\_response](#binary_encoded_response) [count\_affected](#count_affected) [data](#data) [has\_more\_records](#has_more_records) [info](#info) [json\_encoded\_response](#json_encoded_response) [paging\_table](#paging_table) [request\_time\_secs?](#request_time_secs) [response\_schema\_str](#response_schema_str) [total\_number\_of\_records](#total_number_of_records)&#x20;

## Properties

### binary\_encoded\_response

binary\_encoded\_response: string

Avro binary encoded response.

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

### count\_affected

count\_affected: number

The number of objects/records affected.

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

### data

data: [DynamicSchemaData](https://docs.kinetica.com/content/api/javascript/interfaces/DynamicSchemaData.md)

Decoded column-major data; see `DynamicSchemaData`

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

### has\_more\_records

has\_more\_records: boolean

Too many records. Returned a partial set.

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

### info

info: Record\<string, string>

Additional information.

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

### json\_encoded\_response

json\_encoded\_response: string

Avro JSON encoded response.

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

### paging\_table

paging\_table: string

Name of the table that has the result records of the query. Valid, when `has_more_records` is true. The caller should clear this and all tables in result\_table\_list when they are done querying.

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

### `Optional`request\_time\_secs

request\_time\_secs?: number

Server-reported request time in seconds, when it sent one

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

### response\_schema\_str

response\_schema\_str: string

Avro schema of `binary_encoded_response` or `json_encoded_response`.

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

### total\_number\_of\_records

total\_number\_of\_records: number

Total/Filtered number of records.

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


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