### View Table Fields Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Get the field details for a specific table within a base. This command requires both baseId and tableId and is used to identify fieldIds. ```bash mcporter call "$DINGTALK_MCP_URL" .get_tables \ --args '{"baseId":"base_xxx","tableIds":["tbl_xxx"]}' ``` -------------------------------- ### Search Bases by Name Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Search for bases by a specific query string. This is useful for finding a particular base when you know part of its name. ```bash mcporter call "$DINGTALK_MCP_URL" .search_bases query='销售' ``` -------------------------------- ### List Accessible Bases Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Use this command to list all bases accessible by mcporter. Remember to replace DINGTALK_MCP_URL with your actual URL. ```bash mcporter call "$DINGTALK_MCP_URL" .list_bases limit=10 ``` -------------------------------- ### View Tables within a Base Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Retrieve a list of all tables within a specified base. You will need the baseId obtained from previous steps. ```bash mcporter call "$DINGTALK_MCP_URL" .get_base baseId='base_xxx' ``` -------------------------------- ### Batch Import Records Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Import records from a CSV file into a table. Ensure the CSV headers match the field names or fieldIds. ```csv fld_name,fld_age,fld_status 张三,25,进行中 李四,30,已完成 ``` ```bash python3 scripts/import_records.py base_xxx tbl_xxx data.csv ``` -------------------------------- ### Create New Records Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Create new records in a specified table. The 'records' argument takes an array of objects, each containing 'cells' with field-value pairs. ```bash mcporter call "$DINGTALK_MCP_URL" .create_records \ --args '{ "baseId":"base_xxx", "tableId":"tbl_xxx", "records":[ {"cells":{"fld_name":"张三","fld_age":25}}, {"cells":{"fld_name":"李四","fld_age":30}} ] }' ``` -------------------------------- ### Batch Add Fields Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Add multiple fields to a table in a single operation. Define fields in a JSON file with their names, types, and configurations. ```json [ {"fieldName":"任务名","type":"text"}, {"fieldName":"优先级","type":"singleSelect","config":{"options":[{"name":"高"},{"name":"中"},{"name":"低"}]}} ] ``` ```bash python3 scripts/bulk_add_fields.py base_xxx tbl_xxx fields.json ``` -------------------------------- ### Query Records Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Query records from a specific table within a base. This command allows you to retrieve data, with options to limit the number of results. ```bash mcporter call "$DINGTALK_MCP_URL" .query_records \ --args '{"baseId":"base_xxx","tableId":"tbl_xxx","limit":100}' ``` -------------------------------- ### Update Existing Records Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Update existing records in a table. Provide the recordId and the new cell values to be updated. ```bash mcporter call "$DINGTALK_MCP_URL" .update_records \ --args '{ "baseId":"base_xxx", "tableId":"tbl_xxx", "records":[ {"recordId":"rec_xxx","cells":{"fld_name":"王五"}} ] }' ``` -------------------------------- ### Delete Records Source: https://github.com/aliramw/dingtalk-ai-table/blob/main/GETTING_STARTED.md Delete one or more records from a table by providing their recordIds. Ensure you have the correct recordIds before proceeding. ```bash mcporter call "$DINGTALK_MCP_URL" .delete_records \ --args '{ "baseId":"base_xxx", "tableId":"tbl_xxx", "recordIds":["rec_xxx","rec_yyy"] }' ``` === COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.