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.

productivityOAuth1 credits

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