googleapis/google-api-ruby-client

spreadsheet hyperlink value returning nil

alilland opened this issue · 2 comments

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

Is this a limitation of the underlying REST API?