google spreadsheet feeds with multiple worksheets
google-feed-api, google-sheets-api
Solution
It seems worksheet IDs are numbered from 1 to n and not like od6, od7. Using below urls, I was able to get individual worksheet's data https://spreadsheets.google.com/feeds/list/1c53H0piyduOV6zRwS54A7MDZ3SooJOmj4O52Xd0dyIA/1/public/values?alt=json fetches first worksheet https://spreadsheets.google.com/feeds/list/1c53H0piyduOV6zRwS54A7MDZ3SooJOmj4O52Xd0dyIA/2/public/values?alt=json 2nd sheet https://spreadsheets.google.com/feeds/list/1c53H0piyduOV6zRwS54A7MDZ3SooJOmj4O52Xd0dyIA/3/public/values?alt=json 3rd sheet and so on
Note the `/1`, `/2` and `/3` after the key (1c53H0piyduOV6zRwS54A7MDZ3SooJOmj4O52Xd0dyIA) in the url
Problem
How to get feeds from multiple sheets using `google spreadsheet feeds` api? Below URL fetches the feeds from first sheet only. In my `spreadsheet` I have `3 work sheets` and I want to fetch remaining sheets data as well. ``` https://spreadsheets.google.com/feeds/list/XXXXMYKEYXXXX/od6/public/values?alt=json-in-script ``` How to fetch them? I tried below without success: ``` https://spreadsheets.google.com/feeds/list/XXXXMYKEYXXXX/od7/public/values?alt=json-in-script ``` Note `od7` instead of `od6` UPDATE URL for the spreadsheet feed is https://spreadsheets.google.com/feeds/list/1c53H0piyduOV6zRwS54A7MDZ3SooJOmj4O52Xd0dyIA/od6/public/values?alt=json-in-script In the spreadsheet I have `TopicA`,`TopicB`,`TopicC` sheets. Feeds response contains `TopicA` information only.