data

Call data.query

Read rows from one Data table — 'which sponsors have no phone number?', 'show the ten newest venues' — with the same named-column filters, ordering and cursor paging as the product grid. It reads only. Not for the table's columns and limits — that is data.api_describe.

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.

post/api/v1/tools/data.query

Request

  • Base URL: https://app.goosybear.ai
  • URL: https://app.goosybear.ai/api/v1/tools/data.query
  • Auth: HTTP bearer

Headers

x-request-idstring

Your own id for this request, echoed back and recorded on the audit trail. 1–128 characters from A–Z a–z 0–9 . _ : -, starting with a letter or digit; anything else is replaced by a generated id.

Request body

table_idstring uuid required

The table being asked about.

has_value_instring[]

Only rows that HAVE a value in every one of these columns.

missing_value_instring[]

Only rows with NO value in any one of these columns — this is how you answer 'which of these have no phone?'.

equalsobject

Column key to exact value. Only for columns that exist on the table.

order_bystring

A column key to sort by. Leave it out for the natural order.

descendingboolean

Sort the other way.

limitinteger

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.

cursorstring

The next_cursor an earlier page answered with; leave it out for the first page.

workspacestring

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

Response

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.

OR

Changes

No recorded changes to this operation across all 4 revisions of this API.