Hi, I already posted about my problem on google docs support forum, but there som "expert" suggested me to post on stack overflow, but this now seems to me a more suited place, as it seems more specific and focused.
I am learning to use Jboss Teiid (a middleware that can also be configured to access google spreadsheets as datasources) to access my google spreadsheets.(see https://teiid.gitbooks.io/documents/content/admin/Google_Spreadsheet_Data_Sources.html). I'm not a Teiid developer, I'm a user. In Teiid I created a datasource that authenticates through Oauth2, and it works well. Until today, though, I thought in this way it could fetch all worksheet rows (the ultimate target is to use this datasource to build a web app for my LAN that joins google spreadsheet data with other datasources). Instead,* it seems* that if regular users (my colleagues) activate * filters *on a column (not using a custom predefined "data view") through the google docs web interface, interactively, Jboss Teiid datasource * retrieves only the filtered rows*... if the filter is removed (or deactivated), all rows are retrieved. In the screenshot below, you see the situation: squirrelsql query to Teiid, which retrieves only filtered rows from google spreadsheet <https://lh3.googleusercontent.com/-_-1-PtB8luA/VyNcg44raKI/AAAAAAAAAVg/zALmWIlqg3cFLJNjtaLmApXMSD4XLMpXgCLcB/s1600/WpiF1.jpg> If interactive users leave the base worksheet not filtered, but use a custom predefined "data view" (as in "data" menu), the Teiid query retrieves all rows. So, it seems that the result of the query depends on what column filters the interactive user sets (and activates) using the google spreadsheet through its default web interface, while my Teiid datasource should get always all rows, not just those filtered. *Is this expected, and is there any way to get all rows when accessing with apps/tokens*? Or there is some special way/setting that can allow this? I asked help on Jboss Teiid support forum (see https://developer.jboss.org/thread/269486) but for what is known, they issue no special command to the google docs site (I traced the logs and it seems to be something like "https ://docs.google.com/spreadsheets/d/<worksheet key>/gviz/tq", btw). I'm currently using Teiid 9.0.0 Beta1 (latest, atm) Thanks for any help, Marco -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
