{"id":14020281,"date":"2021-02-08T15:35:11","date_gmt":"2021-02-08T15:35:11","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/query-issues-2\/"},"modified":"2021-02-08T15:35:11","modified_gmt":"2021-02-08T15:35:11","slug":"query-issues-2","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/query-issues-2\/","title":{"rendered":"Query Issues"},"content":{"rendered":"<p>Issue:  &#8220;No data available in table&#8221; after viewing page with the following shortcode:<\/p>\n<p><code>[gdoc key=&quot;https:\/\/docs.google.com\/spreadsheets\/d\/12EU3NfQE4kiVylPiQRy6C2z_nmCc5ITBhzU0a8o18dM\/edit?usp=sharing&quot; query=&quot;select A,C,D,E,F WHERE B %3E&#039;3&#039;&quot; header_cols=&quot;5&quot; datatables_page_length=&quot;10&quot; csv_headers=&quot;1&quot; datatables_order=&#039;%5B 4, &quot;desc&quot; %5D&#039;]<\/code><\/p>\n<p>I receive no errors, but the code does not return the desired results.  In fact, I can not get ANY results.  Has anyone else run into this issue?  I have followed instructions and searched for any answer with no satisfaction.  Thus, I turn to this support page.<br \/>\nTIA!<br \/>\nGrayson<\/p>\n","protected":false},"template":"","class_list":["post-14020281","topic","type-topic","status-publish","hentry","topic-tag-query"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14020281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14020281\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14020281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}