Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Meitar

    (@meitar)

    Try using the full URL:

    [gdoc key="https://docs.google.com/spreadsheets/d/1abZ-k9LP0m9kzA0UPGQU65ua2tC4SgVRyCUgZkx2Lyg/htmlview" query="select A"]
    Thread Starter smollern

    (@smollern)

    thank you 🙂

    Plugin Author Meitar

    (@meitar)

    🙂 You’re welcome.

    Hi there,

    I tried the “trick” with the full url but as soon I use it, Google can’t access the spreadsheet.

    Note: I fixed this already!!!

    Quote from “Google:

    Sorry, the file you have requested does not exist.
    Make sure that you have the correct URL and that the owner of the file hasn’t deleted it.

    This is the code I am using:
    [gdoc key=”…” query=”select A,B,C,D” use_cache=”no” datatables_paging=”false” class=”FixedHeader” datatables_page_length=”100″]
    When I only use the document id, all columns are shown.

    Does work (except query) when I use only the id and does not work at all when I use the full url to the document.

    What am I doing wrong?

    I found it out already!!!
    I missed to paste the correct url and so the part in the end was missing:

    https://docs.google.com/spreadsheets/d/1Lf75ZahXc …. _X7REYlIdDbs-n6CeZdQYU/pubhtml

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘query not working (ignored)’ is closed to new replies.