Skip to main content

Using the AskTable Component

In the Baidu Smart Cloud AppBuilder platform, using the AskTable component allows you to perform queries on Excel files or databases with a single sentence.

1. Open the Component​

Go to the Baidu Smart Cloud AppBuilder page and locate the One Sentence to Query Excel or Database component.

2. Add to "My Components"​

Click the Add to button, select My Components, and add it to your AppBuilder account.

Adding the Component

3. Add the "One Sentence to Query Excel or Database" Component in My Components​

Go to the My Components page, find the One Sentence to Query Excel or Database component, and add it to your application.

4. Modify Component Parameters​

In the component's Parameter Configuration, update the following parameters:

  • at_auth: Used to store the authentication token (API-Key) for AskTable.
    • Click here to learn how to get the API-Key
    • The value of at_auth must start with Bearer , in full format: Bearer ASKER_XXXXXXXX
    • For security reasons, it is recommended to use a lower-privileged asker API-Key (starting with ASKER_) instead of an admin-level admin API-Key (starting with ADMIN_)
  • at_ds_id: Store the ID of the Excel file or database (starting with ds_). How to get datasource_id
Component Configuration

5. Debug and Save​

Enter test queries, such as "How many total records are there?" and check if the returned results are correct. If the test passes, save the component, and you can then use it in your application.