googleapis / googleapis/google-api-ruby-client

spreadsheet hyperlink value returning nil

Open
#10,777 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Ruby
Stars
2.9k
Forks
888
Avg merge
6m
Merged PRs (30d)
218

Description

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`
```ruby
p cell_data
#=> #, @formatted_value=" FOOLS HOLLOW LAKE", @user_entered_value=#>

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](http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=fool+hollow+lake+az&aq=&sll=37.0625,-95.677068&sspn=50.157795,73.476563&vpsrc=0&ie=UTF8&hq=&hnear=Fools+Hollow+Lake&t=m&z=15)

- OS: MacOS
- Ruby version: 3.1.2

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.