访问单元格历史记录(python、smartsheets)

import smartsheets
from smartsheets.models import CellHistoryResponse

# 初始化客户端
smartsheets_client = smartsheets.Smartsheets()

# 获取单元格历史记录
sheet_id = 'your_sheet_id'
row_id = 'your_row_id'
column_id = 'your_column_id'

try:
    response: CellHistoryResponse = smartsheets_client.CellsApi().get_cell_history(sheet_id, row_id, column_id)
    for entry in response.entries:
        print(f"Timestamp: {entry.modified_at}, Value: {entry.value}")
except smartsheets.exceptions.ApiError as e:
    print(f"Error: {e}")

import time

def fetch_cell_histories(sheet_id, cell_ids):
    histories = {}
    for cell_id in cell_ids:
        try:
            response = smartsheets_client.CellsApi().get_cell_history(sheet_id, cell_id['row_id'], cell_id['column_id'])
            histories[cell_id] = response.entries
        except smartsheets.exceptions.ApiError as e:
            print(f"Error fetching history for cell {cell_id}: {e}")
        time.sleep(1)  # 增加调用间隔
    return histories

# 示例调用
sheet_id = 'your_sheet_id'
cell_ids = [
    {'row_id': 'row1', 'column_id': 'col1'},
    {'row_id': 'row2', 'column_id': 'col2'},
    # ...更多单元格ID
]
histories = fetch_cell_histories(sheet_id, cell_ids)