I have some tables that are created dynamically from a Google Sheets source. That have been working fine on and off, but recently I started getting essentially empty tables displaying. They show sometimes just one record in the table with field values such as "#N/A" and "#NAME?" which are Google Sheets error messages.
However, when I load the published Google Sheet (in an incognito tab), I see all of the correct values without these errors.
I am wondering if there might be a timeout configured? When a pageview tries to hit the Google Sheet for its values, does the plugin timeout if it takes too long to load? If so, is there a way to adjust this timeout?
I am implementing caching so a fresh page view to hit the Google Sheet will only actually happen once a day, so I am fine if the timeout is long to ensure that the data is captured correctly from the Google Sheet.
A few other notes. The published Google Sheet is here. I have tried creating a new data table in WordPress, and it results in the same errors. This table and sheet combo used to work, but since I have added more data to the sheet, now the table does not work (shows previously mentioned errors).
This seems to be a Google Sheets bug and not a wpDataTables bug. I have been able to see the erroneous results on my published Google Sheet directly, so I understand why wpDataTables is displaying it. Will try to debug through Google support. Thanks.
I have some tables that are created dynamically from a Google Sheets source. That have been working fine on and off, but recently I started getting essentially empty tables displaying. They show sometimes just one record in the table with field values such as "#N/A" and "#NAME?" which are Google Sheets error messages.
However, when I load the published Google Sheet (in an incognito tab), I see all of the correct values without these errors.
I am wondering if there might be a timeout configured? When a pageview tries to hit the Google Sheet for its values, does the plugin timeout if it takes too long to load? If so, is there a way to adjust this timeout?
I am implementing caching so a fresh page view to hit the Google Sheet will only actually happen once a day, so I am fine if the timeout is long to ensure that the data is captured correctly from the Google Sheet.
Thanks!
A few other notes. The published Google Sheet is here. I have tried creating a new data table in WordPress, and it results in the same errors. This table and sheet combo used to work, but since I have added more data to the sheet, now the table does not work (shows previously mentioned errors).
Thanks!
This seems to be a Google Sheets bug and not a wpDataTables bug. I have been able to see the erroneous results on my published Google Sheet directly, so I understand why wpDataTables is displaying it. Will try to debug through Google support. Thanks.