Grist Run Sql Query
Tool to execute a read-only SQL SELECT query on a Grist document. Use after confirming the document ID and preparing a valid SQL SELECT statement.
Write ActionRisk level 2 of 5API key connectionFree Action
Tool to execute a read-only SQL SELECT query on a Grist document. Use after confirming the document ID and preparing a valid SQL SELECT statement.
sqlRequiredstringSQL SELECT statement to execute. Must be a single read-only SELECT (no INSERT/UPDATE/DELETE). Do not include trailing semicolon. WITH clauses and parameterized queries (using '?' placeholders) are supported.
argsarrayPositional parameters to substitute for '?' placeholders in the SQL statement. Provide values in order matching the placeholders.
docIdRequiredstringDocument ID of the Grist document to query. Obtain this via GRIST_LIST_WORKSPACES or from the document URL.
timeoutintegerMaximum execution time in milliseconds. Default is 1000ms. Can only be reduced from the default, not increased.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.