For second point to work, i need to create connection "Google Authorization". I am stuck here, if i create connection by Create new connection --> Qlik Rest Connector --> URL = https://www.googleapis.com/oauth2/v4/token. It shows Remote Server returned an error:(404)Not found.
SET vClient_id = 'entered client_id';
SET vClient_secret = 'entered Client_secret';
SET vRefresh_token = 'entered Refresh_token';
IF vTokenExpires <= now() THEN // if access_token expired request a new one using the refresh_token
LET vRequestBody ='';
LET vRequestBodyvRequestBody = vRequestBody & 'grant_type=refresh_token';
LET vRequestBodyvRequestBody = vRequestBody & '&client_id=' & '$(vClient_id)';
LET vRequestBodyvRequestBody = vRequestBody & '&client_secret=' & '$(vClient_secret)';
LET vRequestBodyvRequestBody = vRequestBody & '&refresh_token=' & '$(vRefresh_token)';