Sha256: a4abde088ee541186e0bed2990ab7e6894d9443c6a7a555a4de6c50c07383988

Contents?: true

Size: 604 Bytes

Versions: 55

Compression:

Stored size: 604 Bytes

Contents

require 'httparty'

module Caboose
  class GoogleSpreadsheetsController < Caboose::ApplicationController
    
    # GET /google-spreadsheets/:spreadsheet_id/csv
    def csv_data           
      spreadsheet_id = params[:spreadsheet_id]                                                                                                              
      url = "https://docs.google.com/spreadsheets/d/#{spreadsheet_id}/export?format=csv&id=#{spreadsheet_id}&gid=0"             
      resp = HTTParty.get(url)
      arr = CSV.parse(resp.body)                    
      render :json => arr
    end

  end
end

Version data entries

55 entries across 55 versions & 1 rubygems

Version Path
caboose-cms-0.6.17 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.16 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.15 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.14 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.13 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.12 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.11 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.10 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.9 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.8 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.7 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.6 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.5 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.4 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.3 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.2 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.6.1 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.5.238 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.5.237 app/controllers/caboose/google_spreadsheets_controller.rb
caboose-cms-0.5.236 app/controllers/caboose/google_spreadsheets_controller.rb