Hello Chad

Can you please provide me the URL to one of those Google Spreadsheets (with editing rights allowed for [email protected]), so I can test that locally?

Hello Chad

I see all your tables are Manual tables:

This means that you've imported the Google Spreadsheet, and that's why you don't see any changes. You need to create a table linked to the Google Spreadsheet for this to work.

When you're importing the file, wpDataTables reads the source file to create a manual table, but after that it is no longer linked to the file.

Hi Chad,

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

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,