Tool to retrieve a specific column from a workbook table. Use when you need to fetch column properties and data by its ID or name.
item_idThe ID of the Excel file (drive item) containing the table.
site_idstringOptional SharePoint site ID. Required when using application permissions (s2s_oauth). Format: 'hostname,spSiteId,spWebId'
drive_idstringOptional drive ID. Required for application-level permissions (s2s_oauth) with OneDrive files. If not provided, falls back to site_id or /me/drive endpoint. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
table_idRequiredstringThe ID or name of the table containing the column.
column_idRequiredstringThe ID or name of the column to retrieve.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.