curl --request POST \
--url https://app.goosybear.ai/api/v1/tools/data.query \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"has_value_in": [
"<string>"
],
"missing_value_in": [
"<string>"
],
"equals": {},
"order_by": "<string>",
"descending": true,
"limit": 50,
"cursor": "<string>",
"workspace": "<string>"
}
'import requests
url = "https://app.goosybear.ai/api/v1/tools/data.query"
payload = {
"table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"has_value_in": ["<string>"],
"missing_value_in": ["<string>"],
"equals": {},
"order_by": "<string>",
"descending": True,
"limit": 50,
"cursor": "<string>",
"workspace": "<string>"
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
table_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
has_value_in: ['<string>'],
missing_value_in: ['<string>'],
equals: {},
order_by: '<string>',
descending: true,
limit: 50,
cursor: '<string>',
workspace: '<string>'
})
};
fetch('https://app.goosybear.ai/api/v1/tools/data.query', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://app.goosybear.ai/api/v1/tools/data.query",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'table_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
'has_value_in' => [
'<string>'
],
'missing_value_in' => [
'<string>'
],
'equals' => [
],
'order_by' => '<string>',
'descending' => true,
'limit' => 50,
'cursor' => '<string>',
'workspace' => '<string>'
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://app.goosybear.ai/api/v1/tools/data.query"
payload := strings.NewReader("{\n \"table_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"has_value_in\": [\n \"<string>\"\n ],\n \"missing_value_in\": [\n \"<string>\"\n ],\n \"equals\": {},\n \"order_by\": \"<string>\",\n \"descending\": true,\n \"limit\": 50,\n \"cursor\": \"<string>\",\n \"workspace\": \"<string>\"\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://app.goosybear.ai/api/v1/tools/data.query")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"table_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"has_value_in\": [\n \"<string>\"\n ],\n \"missing_value_in\": [\n \"<string>\"\n ],\n \"equals\": {},\n \"order_by\": \"<string>\",\n \"descending\": true,\n \"limit\": 50,\n \"cursor\": \"<string>\",\n \"workspace\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://app.goosybear.ai/api/v1/tools/data.query")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"table_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"has_value_in\": [\n \"<string>\"\n ],\n \"missing_value_in\": [\n \"<string>\"\n ],\n \"equals\": {},\n \"order_by\": \"<string>\",\n \"descending\": true,\n \"limit\": 50,\n \"cursor\": \"<string>\",\n \"workspace\": \"<string>\"\n}"
response = http.request(request)
puts response.read_body{
"ok": true,
"table_id": "<string>",
"count_line": "<string>",
"total": 123,
"returned": 123,
"rows": [
{
"row_id": "<string>",
"values": {},
"source": "<string>"
}
],
"workspace": "<string>",
"working_in": {
"label": "<string>",
"note": "<string>",
"workspace": "<string>",
"source": "call-override"
},
"next_cursor": "<string>"
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}Call data.query
Query rows from one Data table using the same named-column filters, ordering and cursor contract as the product grid.
Every result names the workspace it ran in. Say which workspace the answer is about. When the account has more than one workspace and none is selected, this tool refuses with workspace_ambiguous and lists the choices — offer them, never pick one.
curl --request POST \
--url https://app.goosybear.ai/api/v1/tools/data.query \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"has_value_in": [
"<string>"
],
"missing_value_in": [
"<string>"
],
"equals": {},
"order_by": "<string>",
"descending": true,
"limit": 50,
"cursor": "<string>",
"workspace": "<string>"
}
'import requests
url = "https://app.goosybear.ai/api/v1/tools/data.query"
payload = {
"table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"has_value_in": ["<string>"],
"missing_value_in": ["<string>"],
"equals": {},
"order_by": "<string>",
"descending": True,
"limit": 50,
"cursor": "<string>",
"workspace": "<string>"
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
table_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
has_value_in: ['<string>'],
missing_value_in: ['<string>'],
equals: {},
order_by: '<string>',
descending: true,
limit: 50,
cursor: '<string>',
workspace: '<string>'
})
};
fetch('https://app.goosybear.ai/api/v1/tools/data.query', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://app.goosybear.ai/api/v1/tools/data.query",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'table_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
'has_value_in' => [
'<string>'
],
'missing_value_in' => [
'<string>'
],
'equals' => [
],
'order_by' => '<string>',
'descending' => true,
'limit' => 50,
'cursor' => '<string>',
'workspace' => '<string>'
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://app.goosybear.ai/api/v1/tools/data.query"
payload := strings.NewReader("{\n \"table_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"has_value_in\": [\n \"<string>\"\n ],\n \"missing_value_in\": [\n \"<string>\"\n ],\n \"equals\": {},\n \"order_by\": \"<string>\",\n \"descending\": true,\n \"limit\": 50,\n \"cursor\": \"<string>\",\n \"workspace\": \"<string>\"\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://app.goosybear.ai/api/v1/tools/data.query")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"table_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"has_value_in\": [\n \"<string>\"\n ],\n \"missing_value_in\": [\n \"<string>\"\n ],\n \"equals\": {},\n \"order_by\": \"<string>\",\n \"descending\": true,\n \"limit\": 50,\n \"cursor\": \"<string>\",\n \"workspace\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://app.goosybear.ai/api/v1/tools/data.query")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"table_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"has_value_in\": [\n \"<string>\"\n ],\n \"missing_value_in\": [\n \"<string>\"\n ],\n \"equals\": {},\n \"order_by\": \"<string>\",\n \"descending\": true,\n \"limit\": 50,\n \"cursor\": \"<string>\",\n \"workspace\": \"<string>\"\n}"
response = http.request(request)
puts response.read_body{
"ok": true,
"table_id": "<string>",
"count_line": "<string>",
"total": 123,
"returned": 123,
"rows": [
{
"row_id": "<string>",
"values": {},
"source": "<string>"
}
],
"workspace": "<string>",
"working_in": {
"label": "<string>",
"note": "<string>",
"workspace": "<string>",
"source": "call-override"
},
"next_cursor": "<string>"
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"retry_after_seconds": 123
}
}Authorizations
An API key minted at Settings › API & MCP. Send it as Authorization: Bearer <key>. A key carries its holder's own permissions, resolved on every call — revoking a membership closes the key's reach immediately. Keep it in an environment variable (GOOSY_API_KEY), never in a committed file.
Body
The table being asked about.
Only rows that HAVE a value in every one of these columns.
Only rows with NO value in any one of these columns — this is how you answer 'which of these have no phone?'.
Column key to exact value. Only for columns that exist on the table.
Show child attributes
Show child attributes
A column key to sort by. Leave it out for the natural order.
Sort the other way.
How many rows to bring back, at most 100. The total count is always returned whatever this is, so ask for few rows and report the count.
1 <= x <= 100Which workspace to run in — its slug. Omit to use your default. With more than one reachable workspace and no default, the call is refused and the choices are listed.
1Response
The call was admitted and dispatched. ok says whether the tool succeeded — a refusal the tool itself produced is still a 200, exactly as it is a successful JSON-RPC result over MCP.
- Option 1
- Option 2
The tool ran and answered.
Show child attributes
Show child attributes
The slug of the workspace this call ran in.
Which workspace this call ran in, and how that was decided. Present on every workspace-scoped result.
Show child attributes
Show child attributes