spreadsheet hyperlink value returning nil
alilland opened this issue · 2 comments
alilland commented
The state of Arizona publishes a fishing report via Google Spreadsheets, each cell in column A contains hyperlinks to google maps which im trying to obtain
https://docs.google.com/spreadsheets/d/1m4X4I-fhhPL26jeLw4IlB4zG5dM5NgdN_6eewpbCgNM/edit#gid=1253509900
I am able to successfully read the text value, but unable to read the hyperlink value - its returning nil
p cell_data
#=> #<Google::Apis::SheetsV4::CellData:0x000000010d3a9040 @effective_value=#<Google::Apis::SheetsV4::ExtendedValue:0x000000010d3a1700 @string_value=" FOOLS HOLLOW LAKE">, @formatted_value=" FOOLS HOLLOW LAKE", @user_entered_value=#<Google::Apis::SheetsV4::ExtendedValue:0x000000010d4192f0 @string_value=" FOOLS HOLLOW LAKE">>
p cell_data.formatted_value
#=> " FOOLS HOLLOW LAKE"
p cell_data.hyperlink
#=> nil
is there a way to get the hyperlink value? the clicked value is this
- OS: MacOS
- Ruby version: 3.1.2
alilland commented
Is this a limitation of the underlying REST API?