class Multiwoven::Integrations::Destination::MicrosoftExcel::Client

def get_file_data(token, drive_id, item_id)
  result = []
  worksheets_data = get_all_sheets(token, drive_id, item_id)
  worksheets_data.each do |sheet|
    sheet_name = sheet["name"]
    sheet_url = format(MS_EXCEL_SHEET_RANGE_API, drive_id: drive_id, item_id: item_id, sheet_name: sheet_name)
    sheet_response = Multiwoven::Integrations::Core::HttpClient.request(
      sheet_url,
      HTTP_GET,
      headers: auth_headers(token)
    )
    sheets_data = JSON.parse(sheet_response.body)
    column_names = if sheets_data.key?("error")
                     ["Column A"]
                   else
                     sheets_data["values"].first
                   end
    result << {
      sheet_name: sheet_name,
      column_names: column_names
    }
  end
  result
end