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

get\_records\_json

get\_records\_json(
table\_name: string,
column\_names?: string\[] | null,
offset?: number,
limit?: number,
expression?: string | null,
orderby\_columns?: string\[] | null,
having\_clause?: string | null,
callback?: GPUdbCallback,
): Promise\<GetRecordsJsonResponse>
Retrieves records as JSON, via /get/records/json.

Only table\_name is required; every other parameter is optional. Like insert\_records\_from\_json, this endpoint takes its parameters in the query string and is sent with an empty body.
Parameters
- table\_name: string
  
  Table to read from
- Optionalcolumn\_names: string\[] | null
  
  Columns to return; all columns if omitted
- Optionaloffset: number
  
  Record offset; negative values are treated as 0
- Optionallimit: number
  
  Maximum records; negative values mean END\_OF\_SET
- Optionalexpression: string | null
  
  Optional filter expression
- Optionalorderby\_columns: string\[] | null
  
  Optional ordering columns
- Optionalhaving\_clause: string | null
  
  Optional HAVING clause
- Optionalcallback: GPUdbCallback
  
  Optional callback function
Returns Promise\<GetRecordsJsonResponse>

Promise resolving to the matching records

Example

``` const response = await gpudb.get_records_json( 'my_table', ['id', 'name'], 0, 100, 'value > 10', ['id'], ''); response.records; // [{ id: 3, name: 'Charlie' }, ...] response.total_number_of_records; // matches ignoring the limit ```
- Defined in src/GPUdb.ts:16015

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