Data 'Access Denied' - Private Google Sheet

92 views
Skip to first unread message

HB

unread,
Jan 3, 2017, 9:42:15 AM1/3/17
to Google Visualization API
Hi,

I'm using the Visualization API and i can get it working fine when its all public and my web-app shows fine with no problems.

However, the data i'm trying to make available within an organisation is private so i thought maybe change the to 'My Organisation Only - Can Edit'

This is not working hence the message that i require 'OAuth' credentials. I have followed multiple guidance with no avail. 

Can someone confirm whether this is the only option to query the data through a web app if i want to keep it private. 

If so does anyone have any further helpful information.

Any help appreciated, thanks

var query = new google.visualization.Query(https://docs.google.com/spreadsheets/d/SHEETKEY/gviz/tq?tq='SELECT *'&range=A1:B5&headers=1');
query.send(handleQueryResponse);

Daniel LaLiberte

unread,
Jan 3, 2017, 9:57:08 AM1/3/17
to Google Visualization API
At this time, the only option to avoid use of OAuth credentials is to make the spreadsheet public.  It would be convenient if there were more options, such as 'My Organization Only', and I would not be surprised if the docs folks are working on that, but I don't really know.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/66440dcf-a8e2-44fa-9960-5b0691a1d7c0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Reply all
Reply to author
Forward
0 new messages