Skip to content
AskTable

Documentation feedback

Current pageConnect Coze/en/integrations/coze

0 / 5,000

Your feedback will be sent to the maintenance team.

Go to console
Go to console
AskTable
Go to console

Configuration and administration

Connect Coze

Call AskTable to query data in Coze Agents or workflows.

Guide · Module: integrations · Developers · Deployment: Not specified · Confirmed product versions: Not specified · Source: Existing documentation

Coze is ByteDance's Agent building platform. Add AskTable's official plugin so your Coze bot can query data sources already connected to AskTable using natural language. The plugin calls AskTable's REST API, so credentials and data scope remain managed on the AskTable side.

Before you begin

  • An AskTable project with connected data sources; note the data source ID (such as ds_xxxxxxxx). If you have none, Connect data sources first.
  • An asker project API-Key: left main navigation → “Settings” → “API-Key” → “Create API-KEY”; choose asker. Its full value looks like ASKER_xxxxxxxx and is shown only once, on creation.
  • A Coze account.
  • Use the plugin with minimum permissions: do not use an admin Key.

Steps

Identify the official plugin

Search AskTable in the Coze plugin store and select Query Excel or databases with a sentence. It queries data sources already connected to AskTable, including Excel and databases.

Add the plugin to an Agent

Open Coze, create an Agent, and fill in its basic information. Find “Plugins” on the Agent editor page, click “+,” search AskTable, and add “Query Excel or databases with a sentence.”

Create two variables

Create two variables in the Agent's “Variables”:

Variable nameValue
at_authBearer YOUR_API_KEY; note the space after Bearer
at_ds_idYour data source ID, such as ds_xxxxxxxx

Bind plugin parameters to variables

In the plugin parameter configuration:

  • Bind Authorization to at_auth.
  • datasource_ids is an array. Add an array item and bind its value to at_ds_id. To query multiple data sources at once, add multiple array items, each containing a data source ID.

Debug using preview

Ask a data question using preview and confirm that it returns results. The plugin does not pass a role, so its data scope covers the full contents of these data sources. Select only the minimum sources needed.

Use the same configuration in workflows or chatflows

Add an AskTable plugin node in a workflow or chatflow and use the same variable bindings: keep Authorization in Bearer YOUR_API_KEY format, and bind the array items of datasource_ids to at_ds_id.

Key constraints

ItemValue or defaultWhere to change it
API-Key typeasker (minimum permissions)Coze at_auth variable; created in “Settings” → “API-Key”
at_auth formatBearer, one space, then the KeyCoze “Variables”
at_ds_id formatData source ID, such as ds_xxxxxxxxCoze “Variables”
datasource_idsArray; supports multiple data sourcesCoze plugin parameter configuration
Role-based data scope restrictionsNo role is passed; scope covers all selected data sourcesControl by selecting data sources
Data source ID locationCopy from “Data sources”Left main navigation → “More” → “Data sources”
Project API-Key countUp to 10 per project“Settings” → “API-Key”

Troubleshooting

SymptomIdentifying conditionResolution
Plugin call fails authenticationat_auth lacks the Bearer prefix, or the Key was deletedUse Bearer YOUR_API_KEY; recreate in “Settings” → “API-Key” if needed
Plugin reports data source not foundat_ds_id is not a data source ID, or belongs to another projectCopy the correct ID from “Data sources”
Plugin returns empty resultsNo matching data exists, or the question lacks enough filtersConfirm the same question returns results in web “Conversations,” then adjust the Coze wording
Preview is rejectedAn admin Key is used, or the Key belongs to another projectUse an asker Key from the target project
Workflow node reports a parameter errordatasource_ids is not an array, or its items are not bound to variablesConfigure datasource_ids as an array and bind each item to at_ds_id
Answer does not change after changing a data sourceat_ds_id changed but plugin parameters still point to the old variableConfirm the item is bound to at_ds_id and that you changed the variable value rather than a plugin constant

Next steps

  • Restrict data scope by role by passing role_id yourself: OpenAPI
  • Let AI clients call more AskTable capabilities directly: MCP
  • Connect data sources first: Connect data sources