insert_data_into_table
Append rows to an existing SQLite table to merge data from multiple API calls or add new time periods, keeping your datasets up to date.
Instructions
Appends rows (list of dicts) into an ALREADY EXISTING SQLite table. Use this only to add more data to a table that was previously created.
For the common "fetch API data then store" workflow, use create_table_from_data or fetch_vectors_to_database instead — both create the table AND insert data in a single call, so you do NOT need to call this tool after them.
This tool is useful when:
You want to merge data from multiple API calls into one table
You're appending new time periods to an existing dataset
Args: table_input: Object containing table_name and data (list of dicts).
Returns: Dict[str, str]: A dictionary indicating success (with row count) or failure.
IMPORTANT: In your final response to the user, you MUST cite the source of the data you are inserting if it comes from an API call (e.g., "Data from Product ID 123456").
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Data to insert, as a list of dictionaries. | |
| table_name | Yes | Name for the SQL table (alphanumeric and underscores recommended). |