Escape double quote in query to Google sheet

  • Resolved pirf

    (@pirf)


    4 years, 10 months ago

    Hey,
    I have this query working in google sheet: =QUERY(A1:E; "select A,C,E limit 6 offset 3"; 1)

    I need to put it in the query attribute query="A1:E; "select A,C,E limit 6 offset 3"; 1".

    I tried to escape the double quotes, encode them ;quot&, replace them with single quote but I always get an INVALID_QUERY expecting one select where group etc response.

    How can I get =QUERY(A1:E; "select A,C,E limit 6 offset 3"; 1) to work with the plugin?

    I check the support forum, your FAQ and documentation but didn’t find anything related.

    It might not be a double quote issue so I’ll happily update the topic title for future reference.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Escape double quote in query to Google sheet’ is closed to new replies.