SharePoint integration

Batch Update Cells

Perform Batch Update Cells through SharePoint.

View as Markdown

sharepoint_excel_batch_update_cells

writesharepoint

Inputs

workbook_url
expressionrequired
Workbook Url
Required literal value or workflow expression.
worksheet_name
selectrequireddynamic options
Worksheet Name
Required selected identifier or value. Retrieve allowed values from the dynamic options endpoint.
header_row
number
Header Row
Optional numeric value.
Default: 1
headers
expression
Headers
Optional literal value or workflow expression.
row_updates
jsonrequired
Row Updates
Required JSON value.
fail_on_partial
boolean
Fail On Partial
Optional true-or-false value.
Default: true
write_enabled
boolean
Write Enabled
Optional true-or-false value.
Default: false

Outputs

successSuccess
submittedSubmitted
write_skippedWrite Skipped
skip_reasonSkip Reason
workbookWorkbook
row_update_countRow Update Count
updated_cellsUpdated Cells
failed_cellsFailed Cells
failure_codesFailure Codes
errorError
error_messageError Message

Output schema completeness: best_effort_declared

Safety

External effect: write
Confirmation recommended: No
Retry safe: No
Dry run supported: No

Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

Input schema

{
  "type": "object",
  "required": [
    "workbook_url",
    "worksheet_name",
    "row_updates"
  ],
  "properties": {
    "headers": {
      "description": "Optional literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "header_row": {
      "type": "number",
      "default": 1,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "row_updates": {
      "description": "Required JSON value.",
      "x-workflow-field-type": "json"
    },
    "workbook_url": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "write_enabled": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "worksheet_name": {
      "type": "string",
      "description": "Required selected identifier or value. Retrieve allowed values from the dynamic options endpoint.",
      "x-dynamic-options": true,
      "x-workflow-field-type": "select"
    },
    "fail_on_partial": {
      "type": "boolean",
      "default": true,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    }
  },
  "additionalProperties": false
}

Output schema

{
  "type": "object",
  "properties": {
    "error": {},
    "success": {},
    "workbook": {},
    "submitted": {},
    "skip_reason": {},
    "failed_cells": {},
    "error_message": {},
    "failure_codes": {},
    "updated_cells": {},
    "write_skipped": {},
    "row_update_count": {}
  },
  "additionalProperties": true
}

View all SharePoint actions