Dingtalk Node icon

Dingtalk Node

Interact with the Dingtalk API

表格 → 插入数据行

AI-generated

Summary

Insert a new data row into a specified sheet within a DingTalk AI表格 workbook, mapping the input data to columns based on a defined header range and setting the operator identity if specified.

Inputs

  • workbookId (required) — The AI表格 workbook identifier, obtained from DingTalk knowledge base's nodeId (dentryUuid), used to select the target spreadsheet file.
  • sheetId (required) — The target sheet within the workbook identified by its ID or name, selectable from list or by explicitly providing ID.
  • headerRange (required) — The cell range defining the header row (e.g. 'A1:C1'), which determines the columns where data will be inserted.
  • columns (required) — Mapping of column names to values to insert as the new data row, matched according to the header range columns.
  • overrideOperator — Boolean flag to choose whether to override the operator identity from the credentials; if true, operator unionId must be specified manually.
  • operatorId (required) — The unionId of the user performing the operation, required if overrideOperator is true; can be retrieved via user management APIs.

Output shape

a single record with details of the inserted row.

The operation returns the data of the inserted row as confirmation. Inputs must be precise, especially the header range and columns mapping, to properly append data consistent with the target sheet's structure.

Links

Discussion