Objective: After google authentication , to get refresh_token, to send email after the access_token expires.
I am using the social authentication for google. So far, I have been able to get the the access token in Post Authentication Procedure or in an After authentication Application process using :
:APP_GMAIL_TOKEN := apex_web_service.oauth_get_last_token;
OR :APP_GMAIL_TOKEN := apex_json.get_varchar2( p_path => 'access_token' ) ;
I am using this access_token to send email. However, the access_token expires after some time.
I want to get a refresh_token. or some other way to keep the user access token to last for some time.
Even with Authentication URI Parameters:
access_type=offline&prompt=consent
It does not send the refresh token.
@"thatJeffSmith-Oracle"
How can I get the refresh token?