Class: Caboose::GoogleSpreadsheetsController

Inherits:
ApplicationController show all
Defined in:
app/controllers/caboose/google_spreadsheets_controller.rb

Instance Method Summary collapse

Methods inherited from ApplicationController

#add_ga_event, #admin_add, #admin_bulk_add, #admin_bulk_delete, #admin_bulk_update, #admin_delete, #admin_edit, #admin_index, #admin_json, #admin_json_single, #admin_update, #before_action, #before_before_action, #hashify_query_string, #init_cart, #logged_in?, #logged_in_user, #login_user, #logout_user, #parse_url_params, #reject_param, #under_construction_or_forwarding_domain?, #user_is_allowed, #user_is_allowed_to, #validate_cookie, #validate_token, #var, #verify_logged_in

Instance Method Details

#csv_dataObject


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