TOOL API
smartsheet. add_ records
Adds multiple records to a Tencent Docs smart sheet in one call. Record placement is controlled by each record's before_record_id (inserted before that record; omitted means append to the end), not a numeric index, so call list_records first to get the target record_id; records sharing the same before_record_id are inserted consecutively in array order. Format field_values by field type: text fields use {"items":[{"text":"content","type":"text"}]} with type required and fixed to "text" (missing it returns error 22015); option fields only need {"items":[{"text":"option text"}]} with the id resolved server-side; number, progress, currency and percent fields take a plain number in number_value such as 60; date fields take a millisecond timestamp string in string_value such as "1785686400000"; auto-number fields need no value. If both tencent-docs (personal) and tencent-docs-oa (enterprise) are connected, use AskUserQuestion to let the user pick the target account before invoking this tool.
Call information
- Tool slug
- tencent-docs.smartsheet.add_records
- Provider
- Tencent Docs
- Average response
- 0 ms
- Calls in 7 days
- 0
Input parameters
file_idrequired智能表格文档的唯一标识符
recordsrequired需要添加的记录的具体内容组成的数组
sheet_idrequired工作表ID