I have many tables using google sheets as their source. None of them are updating to show the new changes on the google sheets tables. I know there is a 10 minute cache on Google's end, that has nothing to do with it.
How are you "refreshing" the table? There are now 277 entries on the spreadsheet but it still only shows 233 in wordpress no matter what I try to get it to refresh. Refreshing the page does not load the additional entries. It is now missing almost 2 days worth of entries that are on the spreadsheet.
Hello, I tried re-publishing the google sheets and the plugin is stall giving me the "table in data source has no rows" error. It is even giving me the error now for tables I had successfully created yesterday, but today they are giving the error. This must be a bug in the plugin.
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.
Hello,
I have many tables using google sheets as their source. None of them are updating to show the new changes on the google sheets tables. I know there is a 10 minute cache on Google's end, that has nothing to do with it.
Thank you
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?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
How are you "refreshing" the table? There are now 277 entries on the spreadsheet but it still only shows 233 in wordpress no matter what I try to get it to refresh. Refreshing the page does not load the additional entries. It is now missing almost 2 days worth of entries that are on the spreadsheet.
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.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Well that's embarrassing. I must have misread the descriptions when choosing the table type. Thanks for figuring that out.
Hello, I tried re-publishing the google sheets and the plugin is stall giving me the "table in data source has no rows" error. It is even giving me the error now for tables I had successfully created yesterday, but today they are giving the error. This must be a bug in the plugin.
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
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
and below that add this code
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,
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
Thank you Milan. I made the edit and everything seems to be working properly now. I appreciate it!