Method: Caboose::GoogleSpreadsheetsController#csv_data

Defined in:
app/controllers/caboose/google_spreadsheets_controller.rb

#csv_data ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
19
 
# File 'app/controllers/caboose/google_spreadsheets_controller.rb', line 7

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"
  url = "https://docs.google.com/spreadsheets/d/#{spreadsheet_id}/pub?output=csv&single=true&gid=0"            
  resp = HTTParty.get(url)
  arr = nil
  begin 
    arr = CSV.parse(resp.body)
  rescue
    Caboose.log("Error parsing CSV in spreadsheet #{spreadsheet_id}:\n\n#{resp.body}")    
  end
  render :json => arr
end