As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2452932
Google Sheet
Closed

Comments

  • Darin McCarthy started the conversation
    June 25, 2020 at 2:27pm

    Getting error say rows have no data.  Does not work like you directions say.

  •  472
    Isidora replied
    June 25, 2020 at 3:22pm

    Hi there,

    Thank you for reporting this.

    After investigation, we found out that your link in converted in this after CURL call

    Temporary RedirectTemporary Redirect The document has moved here https://doc-10-60-sheets.googleusercontent.com/pub/.....

    The described behavior is a feature:

    https://developers.google.com/apps-script/guides/content#redirects

    • RedirectsFor security reasons, content returned by the Content service isn't served from script.google.com, but instead redirected to a one-time URL at script.googleusercontent.com. This means that if you use the Content service to return data to another application, you must ensure that the HTTP client is configured to follow redirects.

    What you can try is to add this code in file wp-content/plugins/wpdatatables/source/class.wdttools.php around line 205 you will find this

    curl_setopt($ch, CURLOPT_REFERER, site_url());

    and below that add this code

    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);

    so your code will look like this

    7921269120.png

    We need to test more but for now it is working in all test cases and it will be included in next update.

    Sorry for inconvenience,

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables