Okay
  Public Ticket #2452932
Google Sheet
Closed

Comments

  • Darin McCarthy started the conversation

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

  •  472
    Isidora replied

    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: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables