How to access specific rows in a Google sheet which is publised/public?

  • 1
  • Question
  • Updated 1 year ago
I have an established REST API connection between Skuid and Google sheets. I am able to acces sthe whole sheet using the List URL source

"/feeds/list/1-suqzYCpjr6R1OuOKGI60w7nWyk88jAu8dLWH5rmOIk/od6/public/full?alt=json"

I am having trouble to filter or just load specific rows rom this sheet.

The only google documentation I found explaining this is "https://developers.google.com/sheets/api/v3/data#retrieve_a_cell-based_feed" which has only example related to private file.

//spreadsheets.google.com/feeds/cells/key/worksheetId/private/full?min-row=2&min-col=4&max-col=4

when I replace me url with

"/feeds/cells/1-suqzYCpjr6R1OuOKGI60w7nWyk88jAu8dLWH5rmOIk/od6/public/full?alt=json?min-row=2&min-col=4&max-col=4" it is not working either.

Did anyone else had faced this issue? 

Also there is no proper documentation available to use URL merge conditions for google sheets connection based Models.

Please let me know of any workaround?
Photo of murali kb

murali kb

  • 80 Points 75 badge 2x thumb

Posted 1 year ago

  • 1

Be the first to post a reply!