Hello! If you are setting up integration with a large (export) user database in Google Sheets, then the access token to the Google Console is issued for only 1 hour. And I need to export once a day. What should I do? Indeed, every time you pick up from the admin panel, you get a new access token.
Hello,
Edit: Support is given only for users with active subscription.
That 1 hour duration for token is the default value set by Google. That is not controlled by RO CSVI. But you can check few settings in Google console and see if the expire time can be modified. First one to check is the status of your OAuth integration at https://console.cloud.google.com/apis/credentials/consent. Here you should see your OAuth consent status and this must be set to published and not testing. See if that helps.
You can also check the document at Google about the expiration of tokens that may be useful:
https://developers.google.com/identity/protocols/oauth2#expiration
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
We just found that refresh token is not stored after the first authorization and that makes you login each time you run the export. Please check the forum topic here for patch file and steps to solve this issue. Let me know if patch file solves your issue as well.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
We just found that refresh token is not stored after the first authorization and that makes you login each time you run the export. Please check the forum topic here for patch file and steps to solve this issue. Let me know if patch file solves your issue as well.
Thanks a lot for your help, but your link is not working (404).
Hello,
You should have an active subscription with RO CSVI to login and to get access to patch file.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
what should I do if I don't have an active subscription at the moment? The site was transferred to me, but the subscription data was not transferred and there is no such possibility anymore...
Hello,
We cannot help here unless we have your subscription details. Do you have any details on the subscription data? The name of the user or email?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Unfortunately, I was given no subscription data when transferring the site. And now, there is no connection with these people... I am very sorry that I cannot fully test your extension and will have to look for an analog, as I am not ready to purchase a new subscription at the moment (the project is only under development).
Hi,
I am very sorry that I cannot fully test your extension
Do know, if you want to test the extension, we have a demo site available as well at https://demo5.rolandd.com
I understand that you cannot buy a subscription just the same that we cannot provide free support, that is why this is the pre-sale section and not the support section. Feel free to use the demo site for anything you would like to test.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.