Records

List records

Lists records from one table, filtered by your permissions and optionally by a saved view.

GET/v1/tables/{tableId}/records

Request

curl --request GET \
  --url 'https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records' \
  --header 'Authorization: Bearer <token>'

import json
import requests

url = "https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records"
headers = {
  "Authorization": "Bearer <token>"
}

response = requests.request("GET", url, headers=headers)
print(response.json())

const response = await fetch("https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records", {
  method: "GET",
  headers: {
    "Authorization": "Bearer <token>"
  },
});

const data = await response.json();
console.log(data);

<?php
$client = curl_init();

curl_setopt($client, CURLOPT_URL, "https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records");
curl_setopt($client, CURLOPT_CUSTOMREQUEST, "GET");
curl_setopt($client, CURLOPT_HTTPHEADER, [
    "Authorization: Bearer <token>",
]);
curl_setopt($client, CURLOPT_RETURNTRANSFER, true);

$response = curl_exec($client);
curl_close($client);
echo $response;

package main

import (
  "fmt"
  "io"
  "net/http"
)

func main() {
  req, _ := http.NewRequest("GET", "https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records", nil)
  req.Header.Set("Authorization", "Bearer <token>")
  res, _ := http.DefaultClient.Do(req)
  defer res.Body.Close()
  data, _ := io.ReadAll(res.Body)
  fmt.Println(string(data))
}

import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;

var request = HttpRequest.newBuilder(URI.create("https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records"))
    .header("Authorization", "Bearer <token>")
    .method("GET", HttpRequest.BodyPublishers.noBody())
    .build();

var response = HttpClient.newHttpClient().send(
    request, HttpResponse.BodyHandlers.ofString());
System.out.println(response.body());

require 'net/http'
require 'json'

uri = URI("https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records")
request = Net::HTTP::Get.new(uri)
request["Authorization"] = "Bearer <token>"

response = Net::HTTP.start(uri.hostname, uri.port, use_ssl: uri.scheme == "https") do |http|
  http.request(request)
end

puts response.body

application/json

{
  "data": [
    {}
  ],
  "meta": {
    "nextCursor": null,
    "hasMore": true,
    "fields": {}
  }
}

{
  "error": {
    "code": "not_found",
    "message": "<string>",
    "details": {}
  }
}

Paginated with an opaque cursor; ask for a view rather than paging when you only need what a user would see.

Requires the records:read scope. Operation records.list. MCP tool records_list. CLI, once published: gtable records list.

Path parameters

Name	Type	Required	Description
`tableId`	string	yes

Query parameters

Name	Type	Required	Description
`limit`	integer	no	Default `50`.
`cursor`	string	no	Up to 512 characters.
`viewId`	string	no	Up to 64 characters.
`search`	string	no	Up to 200 characters.
`filter`	string	no	Up to 4000 characters.
`sorts`	string	no	Up to 1000 characters.
`where`	string	no	Up to 4000 characters.

Response

application/json

Success

dataRecord<string, object>[]required

metaobjectrequired

Show child attributes

nextCursorstringnullrequired

Pass as cursor for the next page. Null on the last one.

hasMorebooleanrequired

fieldsRecord<string, string>

Field id to field name, for the table the records came from.

List records

Path parameters

Query parameters

Response

Use these docs with your AI tools

Query these docs via MCP

Query these docs over HTTP

Read these docs as Markdown