Comments (2)
serialhex
commented on June 7, 2024
Found URI package, tried it, and reading works fine. Writing breaks:
16:39:15.649 [debug] Event [:removed] at d:/programmin/Projects/l3ibot/data/20170915114612.txt unhandled
iex(17)>
16:39:17.937 [info] I got some data: %{"csv" => %{"col" => "H"}, "serial-col" => "D", "sheet" => "Sheet 1", "stl" => %{"col" => "F"}, "url" => "~~redacted~~"} options:
%{op: "STL", part: "GA120327", serial: "XK17S05", time: "09/15/2017"}
iex(17)>
16:39:17.937 [info] Looking at column: 3
iex(17)>
16:39:17.969 [debug] Limiter Handle events: [{:request, {#PID<0.448.0>, #Reference<0.677853108.2316828674.94696>}, %GSS.Client.RequestParams{body: "", headers: %{"Authorization" => "Bearer ya29.ElrHBO
p4kCg6AElbEx5mhcsRF7bg7Sc1gbn-VyELos5tZS_xtAPwqVeWFwwzX6sLGyrRreuxABcsLeCxxcD0im-GIMdJzSUze0lAAHR_4v8GhuXPmZMWcHaJcdo"}, method: :get, options: [ssl: [versions: [:"tlsv1.2"]]], url: "https://sheets.go
ogleapis.com/v4/spreadsheets/~~redacted~~/values:batchGet?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dateTimeRenderOption=FORMATTED_STRING&ranges=Sheet 1!A1:
E1&ranges=Sheet 1!A2:E2&ranges=Sheet 1!A3:E3&ranges=Sheet 1!A4:E4&ranges=Sheet 1!A5:E5&ranges=Sheet 1!A6:E6&ranges=Sheet 1!A7:E7&ranges=Sheet 1!A8:E8&ranges=Sheet 1!A9:E9&ranges=Sheet 1!A10:E10&ranges
=Sheet 1!A11:E11&ranges=Sheet 1!A12:E12&ranges=Sheet 1!A13:E13&ranges=Sheet 1!A14:E14&ranges=Sheet 1!A15:E15&ranges=Sheet 1!A16:E16&ranges=Sheet 1!A17:E17&ranges=Sheet 1!A18:E18&ranges=Sheet 1!A19:E19
&ranges=Sheet 1!A20:E20&ranges=Sheet 1!A21:E21"}}]
iex(17)>
16:39:17.969 [debug] Request handle events: %GSS.Client.RequestParams{body: "", headers: %{"Authorization" => "Bearer ya29.ElrHBOp4kCg6AElbEx5mhcsRF7bg7Sc1gbn-VyELos5tZS_xtAPwqVeWFwwzX6sLGyrRreuxABcsL
eCxxcD0im-GIMdJzSUze0lAAHR_4v8GhuXPmZMWcHaJcdo"}, method: :get, options: [ssl: [versions: [:"tlsv1.2"]]], url: "https://sheets.googleapis.com/v4/spreadsheets/1h06kOZ2fG-a3uh0KbTi7nxQ0XR8fHIc9701j9Tbva
Z0/values:batchGet?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dateTimeRenderOption=FORMATTED_STRING&ranges=Sheet 1!A1:E1&ranges=Sheet 1!A2:E2&ranges=Sheet 1!A3:E3&ranges=Sheet 1!A4:E4&range
s=Sheet 1!A5:E5&ranges=Sheet 1!A6:E6&ranges=Sheet 1!A7:E7&ranges=Sheet 1!A8:E8&ranges=Sheet 1!A9:E9&ranges=Sheet 1!A10:E10&ranges=Sheet 1!A11:E11&ranges=Sheet 1!A12:E12&ranges=Sheet 1!A13:E13&ranges=S
heet 1!A14:E14&ranges=Sheet 1!A15:E15&ranges=Sheet 1!A16:E16&ranges=Sheet 1!A17:E17&ranges=Sheet 1!A18:E18&ranges=Sheet 1!A19:E19&ranges=Sheet 1!A20:E20&ranges=Sheet 1!A21:E21"}
iex(17)>
16:39:17.969 [debug] send_request https://sheets.googleapis.com/v4/spreadsheets/~~redacted~~/values:batchGet?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dateT
imeRenderOption=FORMATTED_STRING&ranges=Sheet 1!A1:E1&ranges=Sheet 1!A2:E2&ranges=Sheet 1!A3:E3&ranges=Sheet 1!A4:E4&ranges=Sheet 1!A5:E5&ranges=Sheet 1!A6:E6&ranges=Sheet 1!A7:E7&ranges=Sheet 1!A8:E8
&ranges=Sheet 1!A9:E9&ranges=Sheet 1!A10:E10&ranges=Sheet 1!A11:E11&ranges=Sheet 1!A12:E12&ranges=Sheet 1!A13:E13&ranges=Sheet 1!A14:E14&ranges=Sheet 1!A15:E15&ranges=Sheet 1!A16:E16&ranges=Sheet 1!A1
7:E17&ranges=Sheet 1!A18:E18&ranges=Sheet 1!A19:E19&ranges=Sheet 1!A20:E20&ranges=Sheet 1!A21:E21
iex(17)>
16:39:17.969 [info] Response {:ok, %HTTPoison.Response{body: "<!DOCTYPE html>\n<html lang=en>\n <meta charset=utf-8>\n <meta name=viewport content=\"initial-scale=1, minimum-scale=1, width=device-w
idth\">\n <title>Error 400 (Bad Request)!!1</title>\n <style>\n *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;m
ax-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{co
lor:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding
/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_c
olor_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-rat
io:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px
}\n </style>\n <a href=//www.google.com/><span id=logo aria-label=Google></span></a>\n <p><b>400.</b> <ins>ThatΓÇÖs an error.</ins>\n <p>Your client has issued a malformed or illegal request. <in
s>ThatΓÇÖs all we know.</ins>\n", headers: [{"Content-Type", "text/html; charset=UTF-8"}, {"Referrer-Policy", "no-referrer"}, {"Content-Length", "1555"}, {"Date", "Fri, 15 Sep 2017 20:39:11 GMT"}], re
quest_url: "https://sheets.googleapis.com/v4/spreadsheets/~~redacted~~/values:batchGet?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dateTimeRenderOption=FORMAT
TED_STRING&ranges=Sheet 1!A1:E1&ranges=Sheet 1!A2:E2&ranges=Sheet 1!A3:E3&ranges=Sheet 1!A4:E4&ranges=Sheet 1!A5:E5&ranges=Sheet 1!A6:E6&ranges=Sheet 1!A7:E7&ranges=Sheet 1!A8:E8&ranges=Sheet 1!A9:E9&
ranges=Sheet 1!A10:E10&ranges=Sheet 1!A11:E11&ranges=Sheet 1!A12:E12&ranges=Sheet 1!A13:E13&ranges=Sheet 1!A14:E14&ranges=Sheet 1!A15:E15&ranges=Sheet 1!A16:E16&ranges=Sheet 1!A17:E17&ranges=Sheet 1!A
18:E18&ranges=Sheet 1!A19:E19&ranges=Sheet 1!A20:E20&ranges=Sheet 1!A21:E21", status_code: 400}}
iex(17)>
16:39:17.979 [error] GenServer #PID<0.448.0> terminating
** (WithClauseError) no with clause matching: {:ok, %HTTPoison.Response{body: "<!DOCTYPE html>\n<html lang=en>\n <meta charset=utf-8>\n <meta name=viewport content=\"initial-scale=1, minimum-scale=1
, width=device-width\">\n <title>Error 400 (Bad Request)!!1</title>\n <style>\n *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{ma
rgin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overfl
ow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com
/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo
/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-
device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:
54px;width:150px}\n </style>\n <a href=//www.google.com/><span id=logo aria-label=Google></span></a>\n <p><b>400.</b> <ins>ThatΓÇÖs an error.</ins>\n <p>Your client has issued a malformed or illeg
al request. <ins>ThatΓÇÖs all we know.</ins>\n", headers: [{"Content-Type", "text/html; charset=UTF-8"}, {"Referrer-Policy", "no-referrer"}, {"Content-Length", "1555"}, {"Date", "Fri, 15 Sep 2017 20:
39:11 GMT"}], request_url: "https://sheets.googleapis.com/v4/spreadsheets/~~redacted~~/values:batchGet?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dateTimeRen
derOption=FORMATTED_STRING&ranges=Sheet 1!A1:E1&ranges=Sheet 1!A2:E2&ranges=Sheet 1!A3:E3&ranges=Sheet 1!A4:E4&ranges=Sheet 1!A5:E5&ranges=Sheet 1!A6:E6&ranges=Sheet 1!A7:E7&ranges=Sheet 1!A8:E8&range
s=Sheet 1!A9:E9&ranges=Sheet 1!A10:E10&ranges=Sheet 1!A11:E11&ranges=Sheet 1!A12:E12&ranges=Sheet 1!A13:E13&ranges=Sheet 1!A14:E14&ranges=Sheet 1!A15:E15&ranges=Sheet 1!A16:E16&ranges=Sheet 1!A17:E17&
ranges=Sheet 1!A18:E18&ranges=Sheet 1!A19:E19&ranges=Sheet 1!A20:E20&ranges=Sheet 1!A21:E21", status_code: 400}}
(elixir_google_spreadsheets) lib/elixir_google_spreadsheets/spreadsheet.ex:465: GSS.Spreadsheet.spreadsheet_query_response/1
(elixir_google_spreadsheets) lib/elixir_google_spreadsheets/spreadsheet.ex:352: GSS.Spreadsheet.handle_call/3
(stdlib) gen_server.erl:636: :gen_server.try_handle_call/4
(stdlib) gen_server.erl:665: :gen_server.handle_msg/6
(stdlib) proc_lib.erl:247: :proc_lib.init_p_do_apply/3
Last message (from #PID<0.413.0>): {:read_rows, 1, 21, [pad_empty: true, column_to: 5]}
State: %{list_name: "Sheet 1", spreadsheet_id: "~~redacted~~"}
Client #PID<0.413.0> is alive
(stdlib) gen.erl:169: :gen.do_call/4
(elixir) lib/gen_server.ex:771: GenServer.call/3
(l3ibot) lib/l3ibot/sheets.ex:138: L3ibot.Sheets.find_serial/4
(l3ibot) lib/l3ibot/sheets.ex:108: L3ibot.Sheets.update_serial_data/5
(l3ibot) lib/l3ibot/sheets.ex:75: L3ibot.Sheets.update_job/2
(l3ibot) lib/l3ibot/watchfiles.ex:53: L3ibot.Watchfiles.file_created/1
(l3ibot) lib/l3ibot/watchfiles.ex:76: L3ibot.Watchfiles.handle_info/2
(stdlib) gen_server.erl:616: :gen_server.try_dispatch/4
iex(17)>
16:39:17.979 [error] GenServer #PID<0.413.0> terminating
** (stop) exited in: GenServer.call(#PID<0.448.0>, {:read_rows, 1, 21, [pad_empty: true, column_to: 5]}, 5000)
** (EXIT) an exception was raised:
** (WithClauseError) no with clause matching: {:ok, %HTTPoison.Response{body: "<!DOCTYPE html>\n<html lang=en>\n <meta charset=utf-8>\n <meta name=viewport content=\"initial-scale=1, minimum
-scale=1, width=device-width\">\n <title>Error 400 (Bad Request)!!1</title>\n <style>\n *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px
}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22p
x;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.go
ogle.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/go
oglelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-web
kit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block
;height:54px;width:150px}\n </style>\n <a href=//www.google.com/><span id=logo aria-label=Google></span></a>\n <p><b>400.</b> <ins>ThatΓÇÖs an error.</ins>\n <p>Your client has issued a malformed
or illegal request. <ins>ThatΓÇÖs all we know.</ins>\n", headers: [{"Content-Type", "text/html; charset=UTF-8"}, {"Referrer-Policy", "no-referrer"}, {"Content-Length", "1555"}, {"Date", "Fri, 15 Sep
2017 20:39:11 GMT"}], request_url: "https://sheets.googleapis.com/v4/spreadsheets/~~redacted~~/values:batchGet?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dat
eTimeRenderOption=FORMATTED_STRING&ranges=Sheet 1!A1:E1&ranges=Sheet 1!A2:E2&ranges=Sheet 1!A3:E3&ranges=Sheet 1!A4:E4&ranges=Sheet 1!A5:E5&ranges=Sheet 1!A6:E6&ranges=Sheet 1!A7:E7&ranges=Sheet 1!A8:
E8&ranges=Sheet 1!A9:E9&ranges=Sheet 1!A10:E10&ranges=Sheet 1!A11:E11&ranges=Sheet 1!A12:E12&ranges=Sheet 1!A13:E13&ranges=Sheet 1!A14:E14&ranges=Sheet 1!A15:E15&ranges=Sheet 1!A16:E16&ranges=Sheet 1!
A17:E17&ranges=Sheet 1!A18:E18&ranges=Sheet 1!A19:E19&ranges=Sheet 1!A20:E20&ranges=Sheet 1!A21:E21", status_code: 400}}
(elixir_google_spreadsheets) lib/elixir_google_spreadsheets/spreadsheet.ex:465: GSS.Spreadsheet.spreadsheet_query_response/1
(elixir_google_spreadsheets) lib/elixir_google_spreadsheets/spreadsheet.ex:352: GSS.Spreadsheet.handle_call/3
(stdlib) gen_server.erl:636: :gen_server.try_handle_call/4
(stdlib) gen_server.erl:665: :gen_server.handle_msg/6
(stdlib) proc_lib.erl:247: :proc_lib.init_p_do_apply/3
(elixir) lib/gen_server.ex:774: GenServer.call/3
(l3ibot) lib/l3ibot/sheets.ex:138: L3ibot.Sheets.find_serial/4
(l3ibot) lib/l3ibot/sheets.ex:108: L3ibot.Sheets.update_serial_data/5
(l3ibot) lib/l3ibot/sheets.ex:75: L3ibot.Sheets.update_job/2
(l3ibot) lib/l3ibot/watchfiles.ex:53: L3ibot.Watchfiles.file_created/1
(l3ibot) lib/l3ibot/watchfiles.ex:76: L3ibot.Watchfiles.handle_info/2
(stdlib) gen_server.erl:616: :gen_server.try_dispatch/4
(stdlib) gen_server.erl:686: :gen_server.handle_msg/6
Last message: {:file_event, #PID<0.414.0>, {"d:/programmin/Projects/l3ibot/data/20170915114612.txt", [:created]}}
State: %{watcher_pid: #PID<0.414.0>}
iex(17)>
16:39:17.979 [error] GenServer #PID<0.415.0> terminating
** (stop) exited in: GenServer.call(#PID<0.448.0>, {:read_rows, 1, 21, [pad_empty: true, column_to: 5]}, 5000)
** (EXIT) an exception was raised:
** (WithClauseError) no with clause matching: {:ok, %HTTPoison.Response{body: "<!DOCTYPE html>\n<html lang=en>\n <meta charset=utf-8>\n <meta name=viewport content=\"initial-scale=1, minimum
-scale=1, width=device-width\">\n <title>Error 400 (Bad Request)!!1</title>\n <style>\n *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px
}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22p
x;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.go
ogle.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/go
oglelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-web
kit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block
;height:54px;width:150px}\n </style>\n <a href=//www.google.com/><span id=logo aria-label=Google></span></a>\n <p><b>400.</b> <ins>ThatΓÇÖs an error.</ins>\n <p>Your client has issued a malformed
or illegal request. <ins>ThatΓÇÖs all we know.</ins>\n", headers: [{"Content-Type", "text/html; charset=UTF-8"}, {"Referrer-Policy", "no-referrer"}, {"Content-Length", "1555"}, {"Date", "Fri, 15 Sep
2017 20:39:11 GMT"}], request_url: "https://sheets.googleapis.com/v4/spreadsheets/~~redacted~~/values:batchGet?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dat
eTimeRenderOption=FORMATTED_STRING&ranges=Sheet 1!A1:E1&ranges=Sheet 1!A2:E2&ranges=Sheet 1!A3:E3&ranges=Sheet 1!A4:E4&ranges=Sheet 1!A5:E5&ranges=Sheet 1!A6:E6&ranges=Sheet 1!A7:E7&ranges=Sheet 1!A8:
E8&ranges=Sheet 1!A9:E9&ranges=Sheet 1!A10:E10&ranges=Sheet 1!A11:E11&ranges=Sheet 1!A12:E12&ranges=Sheet 1!A13:E13&ranges=Sheet 1!A14:E14&ranges=Sheet 1!A15:E15&ranges=Sheet 1!A16:E16&ranges=Sheet 1!
A17:E17&ranges=Sheet 1!A18:E18&ranges=Sheet 1!A19:E19&ranges=Sheet 1!A20:E20&ranges=Sheet 1!A21:E21", status_code: 400}}
(elixir_google_spreadsheets) lib/elixir_google_spreadsheets/spreadsheet.ex:465: GSS.Spreadsheet.spreadsheet_query_response/1
(elixir_google_spreadsheets) lib/elixir_google_spreadsheets/spreadsheet.ex:352: GSS.Spreadsheet.handle_call/3
(stdlib) gen_server.erl:636: :gen_server.try_handle_call/4
(stdlib) gen_server.erl:665: :gen_server.handle_msg/6
(stdlib) proc_lib.erl:247: :proc_lib.init_p_do_apply/3
Last message: {:EXIT, #PID<0.414.0>, {{{:with_clause, {:ok, %HTTPoison.Response{body: "<!DOCTYPE html>\n<html lang=en>\n <meta charset=utf-8>\n <meta name=viewport content=\"initial-scale=1, minimum
-scale=1, width=device-width\">\n <title>Error 400 (Bad Request)!!1</title>\n <style>\n *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px
}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22p
x;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.go
ogle.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/go
oglelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-web
kit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block
;height:54px;width:150px}\n </style>\n <a href=//www.google.com/><span id=logo aria-label=Google></span></a>\n <p><b>400.</b> <ins>ThatΓÇÖs an error.</ins>\n <p>Your client has issued a malformed
or illegal request. <ins>ThatΓÇÖs all we know.</ins>\n", headers: [{"Content-Type", "text/html; charset=UTF-8"}, {"Referrer-Policy", "no-referrer"}, {"Content-Length", "1555"}, {"Date", "Fri, 15 Sep
2017 20:39:11 GMT"}], request_url: "https://sheets.googleapis.com/v4/spreadsheets/~~redacted~~/values:batchGet?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dat
eTimeRenderOption=FORMATTED_STRING&ranges=Sheet 1!A1:E1&ranges=Sheet 1!A2:E2&ranges=Sheet 1!A3:E3&ranges=Sheet 1!A4:E4&ranges=Sheet 1!A5:E5&ranges=Sheet 1!A6:E6&ranges=Sheet 1!A7:E7&ranges=Sheet 1!A8:
E8&ranges=Sheet 1!A9:E9&ranges=Sheet 1!A10:E10&ranges=Sheet 1!A11:E11&ranges=Sheet 1!A12:E12&ranges=Sheet 1!A13:E13&ranges=Sheet 1!A14:E14&ranges=Sheet 1!A15:E15&ranges=Sheet 1!A16:E16&ranges=Sheet 1!
A17:E17&ranges=Sheet 1!A18:E18&ranges=Sheet 1!A19:E19&ranges=Sheet 1!A20:E20&ranges=Sheet 1!A21:E21", status_code: 400}}}, [{GSS.Spreadsheet, :spreadsheet_query_response, 1, [file: 'lib/elixir_google_
spreadsheets/spreadsheet.ex', line: 465]}, {GSS.Spreadsheet, :handle_call, 3, [file: 'lib/elixir_google_spreadsheets/spreadsheet.ex', line: 352]}, {:gen_server, :try_handle_call, 4, [file: 'gen_server
.erl', line: 636]}, {:gen_server, :handle_msg, 6, [file: 'gen_server.erl', line: 665]}, {:proc_lib, :init_p_do_apply, 3, [file: 'proc_lib.erl', line: 247]}]}, {GenServer, :call, [#PID<0.448.0>, {:read
_rows, 1, 21, [pad_empty: true, column_to: 5]}, 5000]}}}
State: %{port: #Port<0.10235>, worker_pid: #PID<0.414.0>}
iex(17)>
16:39:18.019 [debug] Watching: D:/programmin/Projects/l3ibot/data
thats some output for ya... This lib has made my life a lot easier, hopefully this can be fixed and made much nicer!! 😸
from elixir_google_spreadsheets.
Voronchuk
commented on June 7, 2024
Should be fine in #ba695f0, update to 0.1.8
from elixir_google_spreadsheets.
Related Issues (20)
- Timeout HOT 23
- Separate API layer from Server
- Split GSS.Registry into authorization and process management layers
- Max rows HOT 2
- Question - Check if a specific sheet exists and fallback to a default one HOT 3
- Should error tuples return exception atoms or structs?
- Tests aren't consistently passing HOT 5
- Conflicting httpoison versions HOT 4
- Read/Write from different sheets HOT 1
- Append multiple rows at once? HOT 5
- Support to Delete Rows HOT 1
- ** (File.Error) could not read file "./google/service_account.json": no such file or directory HOT 4
- Not been able to save data into spreadsheet, google API connection problem HOT 1
- dynamically save data to spreadsheet HOT 5
- Question about release version HOT 3
- Avoiding process leakage in web request. HOT 2
- Can I use the library to access Google Spreadsheets of users who sign in with Google OAuth? HOT 1
- SSL certificate issue HOT 1
- Make the test spreadsheet public to read and copy
- Get_request_params function can't merge config HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from elixir_google_spreadsheets.