Getting google sheet dropdown values of a cell with sheet api using javascript

Question

I am trying to get all the values from a dropdown list of a cell in google sheet google sheet dropdown screenshot

however in the json return that i am getting from the sheet api, I only get the selected value and not the list of all the values of the dropdown. How can i the whole list?

the ajax code is:

"GET", "https://sheets.googleapis.com/v4/spreadsheets/"+sheetId+"/values/Sheet1?key="+apiKey+""

json return screenshot

ReyAnthonyRenacia · Accepted Answer · 2018-05-23 09:56:31Z

0

That's the expected outcome. Sheets API only fetches values which are currently visible on the cells. There is no way to get the hidden whole list. Check Reading and Writing for more info.

answered May 23, 2018 at 9:56

ReyAnthonyRenacia

17.7k6 gold badges42 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting google sheet dropdown values of a cell with sheet api using javascript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related