apitable_langchain_toolkit.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# APITable Langchain Toolkit\n",
    "\n",
    "This is [Langchain](https://python.langchain.com/) toolkits allows agents to interact with APITable Fusion API, performing actions such as get spaces, get datasheets, get records, create fields and create datasheet. The tool wraps the [apitable.py](https://github.com/apitable/apitable-sdks/tree/develop/apitable.py) library. \n",
    "\n",
    "And it is in beta, please don't use it in production.\n",
    "\n",
    "To use this tool, you must first set as environment variables: APITABLE_API_TOKEN\n",
    "```python\n",
    "os.environ[\"OPENAI_API_KEY\"] = \"xxx\"\n",
    "os.environ[\"APITABLE_API_TOKEN\"] = \"xxx\"\n",
    "```\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from langchain.agents import AgentType\n",
    "from langchain.agents import initialize_agent\n",
    "\n",
    "from langchain.chat_models import ChatOpenAI\n",
    "\n",
    "from langchain.callbacks import get_openai_callback\n",
    "\n",
    "from apitable_toolkit.tool.prompt import PREFIX, FORMAT_INSTRUCTIONS, SUFFIX\n",
    "from apitable_toolkit.toolkit import APITableToolkit\n",
    "from apitable_toolkit.utilities.apitable import APITableAPIWrapper\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "llm = ChatOpenAI(temperature=0)\n",
    "apitable = APITableAPIWrapper()\n",
    "toolkit = APITableToolkit.from_apitable_api_wrapper(apitable)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def run(prompt):\n",
    "    tools = toolkit.get_tools(prompt)\n",
    "    print([t.name for t in tools])\n",
    "\n",
    "    agent = initialize_agent(\n",
    "        tools,\n",
    "        llm,\n",
    "        agent=AgentType.ZERO_SHOT_REACT_DESCRIPTION,\n",
    "        verbose=True,\n",
    "        agent_kwargs={\n",
    "            \"prefix\": PREFIX,\n",
    "            \"format_instructions\": FORMAT_INSTRUCTIONS,\n",
    "            \"suffix\": SUFFIX,\n",
    "        },\n",
    "    )\n",
    "\n",
    "    with get_openai_callback() as cb:\n",
    "        try:\n",
    "            agent.run(prompt)\n",
    "        except Exception as e:\n",
    "            print(e)\n",
    "        print(f\"Total Tokens: {cb.total_tokens}\")\n",
    "        print(f\"Prompt Tokens: {cb.prompt_tokens}\")\n",
    "        print(f\"Completion Tokens: {cb.completion_tokens}\")\n",
    "        print(f\"Successful Requests: {cb.successful_requests}\")\n",
    "        print(f\"Total Cost (USD): ${cb.total_cost}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Create Datasheets', 'Create Fields', 'Get Spaces', 'Get Nodes']\n",
      "\n",
      "\n",
      "\u001b[1m> Entering new AgentExecutor chain...\u001b[0m\n",
      "\u001b[32;1m\u001b[1;3mThought: I need to use the Get Spaces tool to fetch all the spaces I have access to.\n",
      "Action: Get Spaces\n",
      "Action Input: No input required\u001b[0m\n",
      "Observation: \u001b[38;5;200m\u001b[1;3mFound 4 spaces:\n",
      "[{'id': 'spctqtTZpssYw', 'name': \"xukecheng's Space\", 'isAdmin': True}, {'id': 'spcS0eZxZ8mSA', 'name': 'APITable Ltd.', 'isAdmin': None}, {'id': 'spcGSVizcwRYF', 'name': 'Gmail Space', 'isAdmin': None}, {'id': 'spcV5VkzU71Lf', 'name': 'test03-bug验证升级', 'isAdmin': None}]\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mI have found all the spaces I have access to, so I can now answer the original question.\n",
      "Final Answer: I have access to 4 spaces: \"xukecheng's Space\", \"APITable Ltd.\", \"Gmail Space\", and \"test03-bug验证升级\".\u001b[0m\n",
      "\n",
      "\u001b[1m> Finished chain.\u001b[0m\n",
      "Total Tokens: 3446\n",
      "Prompt Tokens: 3355\n",
      "Completion Tokens: 91\n",
      "Successful Requests: 2\n",
      "Total Cost (USD): $0.0068920000000000006\n"
     ]
    }
   ],
   "source": [
    "run(\"What spaces do I have\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Get Fields', 'Get Records', 'Get Spaces', 'Get Nodes']\n",
      "\n",
      "\n",
      "\u001b[1m> Entering new AgentExecutor chain...\u001b[0m\n",
      "\u001b[32;1m\u001b[1;3mThought: We need to find the latest value of APITable MAU in xukecheng's space. We need to use the Get Fields tool to get the field key for APITable MAU first.\n",
      "Action: Get Fields\n",
      "Action Input: datasheet_id for xukecheng's space\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Expecting value: line 1 column 1 (char 0)', you should only output Action Input in JSON format\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mWe need to input the datasheet_id for xukecheng's space in JSON format to use the Get Fields tool.\n",
      "Action: Get Fields\n",
      "Action Input: {\"datasheet_id\": \"dstxxxxxxxxxxxxxx\"}\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'the specified datasheet does not exist', please try another tool to get right datasheet_id.\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mWe need to use the Get Nodes tool to find the correct datasheet_id for APITable MAU in xukecheng's space.\n",
      "Action: Get Nodes\n",
      "Action Input: space_id for xukecheng's space\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Expecting value: line 1 column 1 (char 0)', you should only output Action Input in JSON format\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mWe need to input the space_id for xukecheng's space in JSON format to use the Get Nodes tool.\n",
      "Action: Get Nodes\n",
      "Action Input: {\"space_id\": \"spacexxxxxxxxxxxxxx\"}\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Action input need effective space_id', please try another tool to get right space_id.\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mWe need to use the Get Spaces tool to find the correct space_id for xukecheng's space.\n",
      "Action: Get Spaces\n",
      "Action Input: None\u001b[0m\n",
      "Observation: \u001b[38;5;200m\u001b[1;3mFound 4 spaces:\n",
      "[{'id': 'spctqtTZpssYw', 'name': \"xukecheng's Space\", 'isAdmin': True}, {'id': 'spcS0eZxZ8mSA', 'name': 'APITable Ltd.', 'isAdmin': None}, {'id': 'spcGSVizcwRYF', 'name': 'Gmail Space', 'isAdmin': None}, {'id': 'spcV5VkzU71Lf', 'name': 'test03-bug验证升级', 'isAdmin': None}]\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mThe space_id for xukecheng's space is 'spctqtTZpssYw'. Now we can use the Get Nodes tool to find the correct datasheet_id for APITable MAU in xukecheng's space.\n",
      "Action: Get Nodes\n",
      "Action Input: {\"space_id\": \"spctqtTZpssYw\"}\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound 6 nodes:\n",
      "[{'id': 'dstt7qKSqsV4DXfQ4R', 'name': 'Project management', 'type': 'Datasheet', 'icon': '', 'isFav': False}, {'id': 'fodHl5i2LeMBH', 'name': 'Make Test', 'type': 'Folder', 'icon': '', 'isFav': False}, {'id': 'fomh7eepvbqkBrwCvW', 'name': 'Form', 'type': 'Form', 'icon': '', 'isFav': False}, {'id': 'dstFQKumRsAp4p5RBE', 'name': 'AITEST', 'type': 'Datasheet', 'icon': '', 'isFav': False}, {'id': 'dstWuVdBJNDzpjn8ck', 'name': 'email_oss', 'type': 'Datasheet', 'icon': '', 'isFav': False}, {'id': 'dsti6VpNpuKQpHVSnh', 'name': 'APITable MAUs', 'type': 'Datasheet', 'icon': '', 'isFav': False}]\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mThe datasheet_id for APITable MAUs in xukecheng's space is 'dsti6VpNpuKQpHVSnh'. Now we can use the Get Records tool to find the latest value of APITable MAU.\n",
      "Action: Get Records\n",
      "Action Input: {\"datasheet_id\": \"dsti6VpNpuKQpHVSnh\", \"sort_condition\": [{\"field\": \"Date\", \"order\": \"desc\"}], \"maxRecords_condition\": 1}\u001b[0m\n",
      "Observation: \u001b[33;1m\u001b[1;3mFound a error 'The sorted field does not exist', please try another tool to get right field name.\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mWe need to use the Get Fields tool to get the correct field key for the Date field in APITable MAUs datasheet.\n",
      "Action: Get Fields\n",
      "Action Input: {\"datasheet_id\": \"dsti6VpNpuKQpHVSnh\"}\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound 4 fields:\n",
      "[{'id': 'fldLhv7h9t2nh', 'name': 'Title', 'type': 'SingleText', 'isPrimary': True, 'desc': None, 'editable': True, 'property': {'defaultValue': ''}}, {'id': 'fldpWusKR8gZc', 'name': 'MAU', 'type': 'Number', 'isPrimary': False, 'desc': None, 'editable': True, 'property': {'defaultValue': None, 'precision': 0}}, {'id': 'fldahS3qDuSuH', 'name': 'Created time', 'type': 'CreatedTime', 'isPrimary': False, 'desc': None, 'editable': False, 'property': {'format': 'YYYY/MM/DD HH:mm', 'autoFill': False, 'includeTime': True}}, {'id': 'fldbZpUhT5dEb', 'name': '是否为整百', 'type': 'Formula', 'isPrimary': False, 'desc': None, 'editable': False, 'property': {'expression': 'ROUND({fldpWusKR8gZc},-2)={fldpWusKR8gZc}', 'valueType': 'Boolean', 'hasError': False}}]\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mThe field key for the Date field in APITable MAUs datasheet is not found. We need to check if the field name is different or if the field is missing.\n",
      "Action: Get Records\n",
      "Action Input: {\"datasheet_id\": \"dsti6VpNpuKQpHVSnh\", \"sort_condition\": [{\"field\": \"Created time\", \"order\": \"desc\"}], \"maxRecords_condition\": 1}\u001b[0m\n",
      "Observation: \u001b[33;1m\u001b[1;3mFound 1 records:\n",
      "[{'Created time': 1686153676721, 'MAU': 331}]\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mThe latest value of APITable MAU in xukecheng's space is 331.\n",
      "Final Answer: The latest value of APITable MAU in xukecheng's space is 331.\u001b[0m\n",
      "\n",
      "\u001b[1m> Finished chain.\u001b[0m\n",
      "Total Tokens: 13399\n",
      "Prompt Tokens: 12818\n",
      "Completion Tokens: 581\n",
      "Successful Requests: 10\n",
      "Total Cost (USD): $0.026798\n"
     ]
    }
   ],
   "source": [
    "run(\"Tell me the latest value of APITable MAU in xukecheng's space\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Create Datasheets', 'Create Fields', 'Get Spaces', 'Get Nodes']\n",
      "\n",
      "\n",
      "\u001b[1m> Entering new AgentExecutor chain...\u001b[0m\n",
      "\u001b[32;1m\u001b[1;3mThought: I need to use the Create Datasheets tool to create a datasheet for Project management in xukecheng's space. I need to input the space id and the name of the datasheet.\n",
      "Action: Create Datasheets\n",
      "Action Input: space_id = xukecheng's space id, name = \"Project management\"\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Expecting value: line 1 column 1 (char 0)', you should only output Action Input in JSON format\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mI need to input the space id and the name of the datasheet in JSON format.\n",
      "Action: Create Datasheets\n",
      "Action Input: {\"space_id\": \"xukecheng's space id\", \"name\": \"Project management\"}\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Action input need effective space_id', please try another tool to get right space_id.\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mI need to use the Get Spaces tool to get the correct space_id for xukecheng's space.\n",
      "Action: Get Spaces\n",
      "Action Input: None\u001b[0m\n",
      "Observation: \u001b[38;5;200m\u001b[1;3mFound 4 spaces:\n",
      "[{'id': 'spctqtTZpssYw', 'name': \"xukecheng's Space\", 'isAdmin': True}, {'id': 'spcS0eZxZ8mSA', 'name': 'APITable Ltd.', 'isAdmin': None}, {'id': 'spcGSVizcwRYF', 'name': 'Gmail Space', 'isAdmin': None}, {'id': 'spcV5VkzU71Lf', 'name': 'test03-bug验证升级', 'isAdmin': None}]\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mThe correct space_id for xukecheng's space is 'spctqtTZpssYw'.\n",
      "Action: Create Datasheets\n",
      "Action Input: {\"space_id\": \"spctqtTZpssYw\", \"name\": \"Project management\"}\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Action input need effective 'field_data'', please generate effective 'field_data' and try again\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mI need to generate effective 'field_data' for the Project management datasheet.\n",
      "Action: Create Datasheets\n",
      "Action Input: {\"space_id\": \"spctqtTZpssYw\", \"name\": \"Project management\", \"field_data\": [{\"name\": \"Project Name\", \"type\": \"SingleText\", \"property\": {\"defaultValue\": \"\"}}, {\"name\": \"Project Description\", \"type\": \"Text\", \"property\": {}}, {\"name\": \"Project Status\", \"type\": \"SingleSelect\", \"property\": {\"options\": [{\"name\": \"In Progress\"}, {\"name\": \"Completed\"}, {\"name\": \"On Hold\"}]}}]}\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Invalid value for $fields[Project Description].property', please try to correct field_data.\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mI need to correct the field_data for the Project management datasheet. The issue is with the \"Project Description\" field, which should have a type of \"SingleText\" instead of \"Text\".\n",
      "Action: Create Datasheets\n",
      "Action Input: {\"space_id\": \"spctqtTZpssYw\", \"name\": \"Project management\", \"field_data\": [{\"name\": \"Project Name\", \"type\": \"SingleText\", \"property\": {\"defaultValue\": \"\"}}, {\"name\": \"Project Description\", \"type\": \"SingleText\", \"property\": {\"defaultValue\": \"\"}}, {\"name\": \"Project Status\", \"type\": \"SingleSelect\", \"property\": {\"options\": [{\"name\": \"In Progress\"}, {\"name\": \"Completed\"}, {\"name\": \"On Hold\"}]}}]}\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mDatasheet created! \n",
      "{\"id\": \"dstV2RaebhNsyFMEmK\", \"createdAt\": 1686647718000, \"items\": [{\"id\": \"fld2YNdo4dO0q\", \"name\": \"Project Name\"}, {\"id\": \"fldMq7aGDyz22\", \"name\": \"Project Description\"}, {\"id\": \"fld9BCEIXV5mc\", \"name\": \"Project Status\"}]}\u001b[0m\n",
      "Thought:Could not parse LLM output: `The final answer is: A datasheet for Project management has been successfully created in xukecheng's space with the following fields: Project Name, Project Description, and Project Status. The datasheet id is dstV2RaebhNsyFMEmK.`\n",
      "Total Tokens: 14208\n",
      "Prompt Tokens: 13662\n",
      "Completion Tokens: 546\n",
      "Successful Requests: 7\n",
      "Total Cost (USD): $0.028416000000000004\n"
     ]
    }
   ],
   "source": [
    "run(\"Create a datasheet for Project management in xukecheng's space\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Create Datasheets', 'Create Fields', 'Get Spaces', 'Get Nodes']\n",
      "\n",
      "\n",
      "\u001b[1m> Entering new AgentExecutor chain...\u001b[0m\n",
      "\u001b[32;1m\u001b[1;3mThought: We need to use the Create Datasheets tool to create a datasheet in xukecheng's space. We also need to determine the field types and properties for each field we want to include in the datasheet.\n",
      "\n",
      "Action: Create Datasheets\n",
      "Action Input: \n",
      "- space id: xukecheng's space id\n",
      "- name: \"Project management\"\n",
      "- field_data: \n",
      "  - name: \"name\"\n",
      "    type: \"SingleText\"\n",
      "    property: \n",
      "      defaultValue: \"\"\n",
      "  - name: \"description\"\n",
      "    type: \"Text\"\n",
      "  - name: \"start_date\"\n",
      "    type: \"DateTime\"\n",
      "    property:\n",
      "      dateFormat: \"YYYY-MM-DD\"\n",
      "      includeTime: false\n",
      "  - name: \"end_date\"\n",
      "    type: \"DateTime\"\n",
      "    property:\n",
      "      dateFormat: \"YYYY-MM-DD\"\n",
      "      includeTime: false\n",
      "  - name: \"status\"\n",
      "    type: \"SingleSelect\"\n",
      "    property:\n",
      "      options: []\n",
      "  - name: \"owner\"\n",
      "    type: \"Member\"\n",
      "    property:\n",
      "      isMulti: false\n",
      "      shouldSendMsg: false\n",
      "  - name: \"priority\"\n",
      "    type: \"SingleSelect\"\n",
      "    property:\n",
      "      options: []\n",
      "  - name: \"progress\"\n",
      "    type: \"Percent\"\n",
      "    property:\n",
      "      precision: 0\n",
      "  - name: \"comments\"\n",
      "    type: \"Text\"\n",
      "\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Expecting value: line 1 column 1 (char 0)', you should only output Action Input in JSON format\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mI need to make sure the input is in valid JSON format.\n",
      "\n",
      "Action: Create Datasheets\n",
      "Action Input: \n",
      "{\n",
      "  \"space_id\": \"xukecheng's space id\",\n",
      "  \"name\": \"Project management\",\n",
      "  \"field_data\": [\n",
      "    {\n",
      "      \"name\": \"name\",\n",
      "      \"type\": \"SingleText\",\n",
      "      \"property\": {\n",
      "        \"defaultValue\": \"\"\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"description\",\n",
      "      \"type\": \"Text\"\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"start_date\",\n",
      "      \"type\": \"DateTime\",\n",
      "      \"property\": {\n",
      "        \"dateFormat\": \"YYYY-MM-DD\",\n",
      "        \"includeTime\": false\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"end_date\",\n",
      "      \"type\": \"DateTime\",\n",
      "      \"property\": {\n",
      "        \"dateFormat\": \"YYYY-MM-DD\",\n",
      "        \"includeTime\": false\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"status\",\n",
      "      \"type\": \"SingleSelect\",\n",
      "      \"property\": {\n",
      "        \"options\": []\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"owner\",\n",
      "      \"type\": \"Member\",\n",
      "      \"property\": {\n",
      "        \"isMulti\": false,\n",
      "        \"shouldSendMsg\": false\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"priority\",\n",
      "      \"type\": \"SingleSelect\",\n",
      "      \"property\": {\n",
      "        \"options\": []\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"progress\",\n",
      "      \"type\": \"Percent\",\n",
      "      \"property\": {\n",
      "        \"precision\": 0\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"comments\",\n",
      "      \"type\": \"Text\"\n",
      "    }\n",
      "  ]\n",
      "}\n",
      "\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mFound a error 'Action input need effective space_id', please try another tool to get right space_id.\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mI need to use the Get Spaces tool to get the correct space id.\n",
      "\n",
      "Action: Get Spaces\n",
      "Action Input: None\n",
      "\u001b[0m\n",
      "Observation: \u001b[38;5;200m\u001b[1;3mFound 4 spaces:\n",
      "[{'id': 'spctqtTZpssYw', 'name': \"xukecheng's Space\", 'isAdmin': True}, {'id': 'spcS0eZxZ8mSA', 'name': 'APITable Ltd.', 'isAdmin': None}, {'id': 'spcGSVizcwRYF', 'name': 'Gmail Space', 'isAdmin': None}, {'id': 'spcV5VkzU71Lf', 'name': 'test03-bug验证升级', 'isAdmin': None}]\u001b[0m\n",
      "Thought:\u001b[32;1m\u001b[1;3mThe correct space id is 'spctqtTZpssYw', which is xukecheng's space.\n",
      "\n",
      "Action: Create Datasheets\n",
      "Action Input: \n",
      "{\n",
      "  \"space_id\": \"spctqtTZpssYw\",\n",
      "  \"name\": \"Project management\",\n",
      "  \"field_data\": [\n",
      "    {\n",
      "      \"name\": \"name\",\n",
      "      \"type\": \"SingleText\",\n",
      "      \"property\": {\n",
      "        \"defaultValue\": \"\"\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"description\",\n",
      "      \"type\": \"Text\"\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"start_date\",\n",
      "      \"type\": \"DateTime\",\n",
      "      \"property\": {\n",
      "        \"dateFormat\": \"YYYY-MM-DD\",\n",
      "        \"includeTime\": false\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"end_date\",\n",
      "      \"type\": \"DateTime\",\n",
      "      \"property\": {\n",
      "        \"dateFormat\": \"YYYY-MM-DD\",\n",
      "        \"includeTime\": false\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"status\",\n",
      "      \"type\": \"SingleSelect\",\n",
      "      \"property\": {\n",
      "        \"options\": []\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"owner\",\n",
      "      \"type\": \"Member\",\n",
      "      \"property\": {\n",
      "        \"isMulti\": false,\n",
      "        \"shouldSendMsg\": false\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"priority\",\n",
      "      \"type\": \"SingleSelect\",\n",
      "      \"property\": {\n",
      "        \"options\": []\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"progress\",\n",
      "      \"type\": \"Percent\",\n",
      "      \"property\": {\n",
      "        \"precision\": 0\n",
      "      }\n",
      "    },\n",
      "    {\n",
      "      \"name\": \"comments\",\n",
      "      \"type\": \"Text\"\n",
      "    }\n",
      "  ]\n",
      "}\n",
      "\u001b[0m\n",
      "Observation: \u001b[36;1m\u001b[1;3mDatasheet created! \n",
      "{\"id\": \"dstZTEueDaWedFWgbh\", \"createdAt\": 1686647873000, \"items\": [{\"id\": \"fldmKw4CRZf6q\", \"name\": \"name\"}, {\"id\": \"fldXLksgFXdC3\", \"name\": \"description\"}, {\"id\": \"fld6eQ3vyTNFS\", \"name\": \"start_date\"}, {\"id\": \"fldFecRVp4xLa\", \"name\": \"end_date\"}, {\"id\": \"fldkygIuIHcov\", \"name\": \"status\"}, {\"id\": \"fldMyiEi6frCr\", \"name\": \"owner\"}, {\"id\": \"fldtMNz9xtytB\", \"name\": \"priority\"}, {\"id\": \"fldBfg8fzAwVv\", \"name\": \"progress\"}, {\"id\": \"fldJV87qri0ku\", \"name\": \"comments\"}]}\u001b[0m\n",
      "Thought:Could not parse LLM output: `The final answer is that the datasheet for Project management has been successfully created in xukecheng's space, with the specified fields. The datasheet id is \"dstZTEueDaWedFWgbh\".`\n",
      "Total Tokens: 12438\n",
      "Prompt Tokens: 11395\n",
      "Completion Tokens: 1043\n",
      "Successful Requests: 5\n",
      "Total Cost (USD): $0.024876000000000002\n"
     ]
    }
   ],
   "source": [
    "run(\"Create a datasheet for Project management in xukecheng's space, need to include the following fields: name, description, start_date, end_date, status, owner, priority, progress, comments\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.10"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}