Trash

What was deleted, and can still be put back

The app's trash: every deleted table and field, and every column a type change converted, with how many records' values it holds and when it expires (thirty days after the change).

GET/v1/apps/{appId}/trash

Request

curl --request GET \
  --url 'https://studio.gtable.app/v1/apps/<appId>/trash' \
  --header 'Authorization: Bearer <token>'

import json
import requests

url = "https://studio.gtable.app/v1/apps/<appId>/trash"
headers = {
  "Authorization": "Bearer <token>"
}

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

const response = await fetch("https://studio.gtable.app/v1/apps/<appId>/trash", {
  method: "GET",
  headers: {
    "Authorization": "Bearer <token>"
  },
});

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

<?php
$client = curl_init();

curl_setopt($client, CURLOPT_URL, "https://studio.gtable.app/v1/apps/<appId>/trash");
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://studio.gtable.app/v1/apps/<appId>/trash", 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://studio.gtable.app/v1/apps/<appId>/trash"))
    .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://studio.gtable.app/v1/apps/<appId>/trash")
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": [
    {
      "id": "<string>",
      "kind": "<string>",
      "label": "<string>",
      "at": "<string>",
      "actor": "<string>",
      "rows": 123.45,
      "expiresAt": "<string>",
      "restoredAt": null
    }
  ]
}

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

Restore one with trash.restore.

Requires the schema:read scope. Operation trash.list. MCP tool trash_list. CLI, once published: gtable trash list.

Path parameters

Name	Type	Required	Description
`appId`	string	yes

Response

application/json

Success

dataobject[]required

Show child attributes

idstringrequired

kindstringrequired

labelstringrequired

atstringrequired

actorstringrequired

rowsnumberrequired

expiresAtstringrequired

restoredAtstringnullrequired

{ "data": [ { "id": "<string>", "kind": "<string>", "label": "<string>", "at": "<string>", "actor": "<string>", "rows": 123.45, "expiresAt": "<string>", "restoredAt": null } ] }

What was deleted, and can still be put back

Path parameters

Response

Use these docs with your AI tools

Query these docs via MCP

Query these docs over HTTP

Read these docs as Markdown