We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello,
I have a very specific pre-purchase question. I am extremely interested in the api calls between google for instant updates from google sheets.
However, I would like to know if this affects the google request limit quota for google's api.
For instance, if I have 500 users all refreshing google api wpdatatables table at the same ... does this cause 500 requests to google drive api?
I ask because I know that google drive api limits requests of approx. 100 requests per 100 seconds, and at peak site usage this would cause an error. I don't know if this is how wpdatables works with the api though.
Thank you for your help, and I look forward to your answer so that I can proceed with purchase.
Hi Owen
Thank you for reaching out to us.
Let me forward this to our Level 2 as they will be more suitable to answer this question
We appreciate your time and patience.
Hey Owen
Thank you for your interest in wpDataTables.
Google Sheets API does have a quota limit. It's limited to 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user (as you said).
https://developers.google.com/sheets/api/limits
That quota can be increased, but that requires an additional charge in Google (increasing the quota is not free). Another way would be to use the old method without the API.
Our developers looked for a way to bypass this, but unfortunately, they did not find it (yet).
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
ok thank you for the response. to be clear the "old way" is to share public/publish, and it pulls data correct. However, I am assuming that the "old way" still has a delay issue with changes do to the google cache delay correct?
Thank you again
That is correct, Owen, the old way does take some time to pull the data from the spreadsheet due to cache.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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