Hi Thulshika,
For google spreadsheet you can do something like this.
There is an api call to check whether the access token is valid or not. ("
https://www.googleapis.com/oauth2/v1/tokeninfo?access_token="; +
accessToken;).
This would avoid getting the access token each time.
Regards,
*Nadeeshaan Gunasinghe*
Software Engineer, WSO2 Inc. http://wso2.com
+94770596754 | [email protected] | Skype: nadeeshaan.gunasinghe <#>
<http://www.facebook.com/nadeeshaan.gunasinghe>
<http://lk.linkedin.com/in/nadeeshaan> <http://twitter.com/Nadeeshaan>
<http://nadeeshaan.blogspot.com/>
Get a signature like this: Click here!
<http://ws-promos.appspot.com/r?rdata=eyJydXJsIjogImh0dHA6Ly93d3cud2lzZXN0YW1wLmNvbS9lbWFpbC1pbnN0YWxsP3dzX25jaWQ9NjcyMjk0MDA4JnV0bV9zb3VyY2U9ZXh0ZW5zaW9uJnV0bV9tZWRpdW09ZW1haWwmdXRtX2NhbXBhaWduPXByb21vXzU3MzI1Njg1NDg3Njk3OTIiLCAiZSI6ICI1NzMyNTY4NTQ4NzY5NzkyIn0=>
On Sun, Dec 20, 2015 at 12:57 PM, Thulasika Vijayanathan <[email protected]
> wrote:
> Hi,
>
> Since access token for Google Spreadsheet and Salesforce expires in 1
> hour, we need to renew it after expiration time,But now we use
> getAccessTokenFromRefresToken method for every method call.To cater to this
> requirement I have added a new init method to save the access token in
> registry entry for the first time, and for every one hour,To get the access
> token from refresh token for every 1 hour I use ESB Quartz Cron Trigger
> and update the access token in registry entry.
>
> Thanks
>
> On Fri, Dec 18, 2015 at 8:15 PM, Malaka Silva <[email protected]> wrote:
>
>> Please start this discussion on public thread.
>>
>> Issues you need to start communicating on dev mail threads.
>>
>> No more private mails please.
>>
>> On Fri, Dec 18, 2015 at 4:34 PM, Thulasika Vijayanathan <
>> [email protected]> wrote:
>>
>>> I have finished the Salesforce to Google Sheets scenario.I have some
>>> issues with the registry part.I will show the demo on Monday.
>>>
>>> Thanks.
>>>
>>>
>>> On Fri, Dec 18, 2015 at 3:11 PM, Malaka Silva <[email protected]> wrote:
>>>
>>>> Thulasika why still no update? What is the status?
>>>> Please updatee the mail thread.
>>>>
>>>> On Sun, Dec 13, 2015 at 8:16 PM, Malaka Silva <[email protected]> wrote:
>>>>
>>>>> Please put regular update and we need to get moving with this..
>>>>>
>>>>> On Sat, Dec 12, 2015 at 8:31 PM, Thulasika Vijayanathan <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Noted Malaka. Still in the process,I will send update once I finished.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> On Sat, Dec 12, 2015 at 2:04 PM, Malaka Silva <[email protected]>
>>>>>> wrote:
>>>>>>
>>>>>>> Thulasika please update this thread with your findings.
>>>>>>>
>>>>>>> On Tue, Dec 8, 2015 at 11:35 AM, Malaka Silva <[email protected]>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> One of the main issues we had when automating the integration use
>>>>>>>> cases is accesstokens getting expired and need human interaction to
>>>>>>>> continue the service.
>>>>>>>>
>>>>>>>> From connector side (Since September release) we have added methods
>>>>>>>> to renew the tokens using refresh token.
>>>>>>>>
>>>>>>>> With ESB 4.10 registry persistence feature we can fully automate
>>>>>>>> this use case.
>>>>>>>>
>>>>>>>> As the first stage we are going to check how this can be done. For
>>>>>>>> this will be using the sync service from Salesforce to Google Sheets
>>>>>>>> as the
>>>>>>>> model use case.
>>>>>>>>
>>>>>>>> We will plan to do this change focusing on following points.
>>>>>>>>
>>>>>>>> 1. Connectors should make use of this ESB 4.10 new feature.
>>>>>>>> 2. Connector should be also compatible with previous versions.
>>>>>>>>
>>>>>>>> May be we can introduce a new init method for esb 4.10?
>>>>>>>>
>>>>>>>> Thulasika is currently checking this.
>>>>>>>>
>>>>>>>> @Thulasika please use this thread to update the findings.
>>>>>>>>
>>>>>>>> Best Regards,
>>>>>>>>
>>>>>>>> Malaka Silva
>>>>>>>> Senior Tech Lead
>>>>>>>> M: +94 777 219 791
>>>>>>>> Tel : 94 11 214 5345
>>>>>>>> Fax :94 11 2145300
>>>>>>>> Skype : malaka.sampath.silva
>>>>>>>> LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77
>>>>>>>> Blog : http://mrmalakasilva.blogspot.com/
>>>>>>>>
>>>>>>>> WSO2, Inc.
>>>>>>>> lean . enterprise . middleware
>>>>>>>> http://www.wso2.com/
>>>>>>>> http://www.wso2.com/about/team/malaka-silva/
>>>>>>>> <http://wso2.com/about/team/malaka-silva/>
>>>>>>>> https://store.wso2.com/store/
>>>>>>>>
>>>>>>>> Save a tree -Conserve nature & Save the world for your future.
>>>>>>>> Print this email only if it is absolutely necessary.
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> Best Regards,
>>>>>>>
>>>>>>> Malaka Silva
>>>>>>> Senior Tech Lead
>>>>>>> M: +94 777 219 791
>>>>>>> Tel : 94 11 214 5345
>>>>>>> Fax :94 11 2145300
>>>>>>> Skype : malaka.sampath.silva
>>>>>>> LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77
>>>>>>> Blog : http://mrmalakasilva.blogspot.com/
>>>>>>>
>>>>>>> WSO2, Inc.
>>>>>>> lean . enterprise . middleware
>>>>>>> http://www.wso2.com/
>>>>>>> http://www.wso2.com/about/team/malaka-silva/
>>>>>>> <http://wso2.com/about/team/malaka-silva/>
>>>>>>> https://store.wso2.com/store/
>>>>>>>
>>>>>>> Save a tree -Conserve nature & Save the world for your future. Print
>>>>>>> this email only if it is absolutely necessary.
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Thulasika
>>>>>> Associate Software Engineer
>>>>>> Mobile:0778014295
>>>>>> email: [email protected] <[email protected]>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Best Regards,
>>>>>
>>>>> Malaka Silva
>>>>> Senior Tech Lead
>>>>> M: +94 777 219 791
>>>>> Tel : 94 11 214 5345
>>>>> Fax :94 11 2145300
>>>>> Skype : malaka.sampath.silva
>>>>> LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77
>>>>> Blog : http://mrmalakasilva.blogspot.com/
>>>>>
>>>>> WSO2, Inc.
>>>>> lean . enterprise . middleware
>>>>> http://www.wso2.com/
>>>>> http://www.wso2.com/about/team/malaka-silva/
>>>>> <http://wso2.com/about/team/malaka-silva/>
>>>>> https://store.wso2.com/store/
>>>>>
>>>>> Save a tree -Conserve nature & Save the world for your future. Print
>>>>> this email only if it is absolutely necessary.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Best Regards,
>>>>
>>>> Malaka Silva
>>>> Senior Tech Lead
>>>> M: +94 777 219 791
>>>> Tel : 94 11 214 5345
>>>> Fax :94 11 2145300
>>>> Skype : malaka.sampath.silva
>>>> LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77
>>>> Blog : http://mrmalakasilva.blogspot.com/
>>>>
>>>> WSO2, Inc.
>>>> lean . enterprise . middleware
>>>> http://www.wso2.com/
>>>> http://www.wso2.com/about/team/malaka-silva/
>>>> <http://wso2.com/about/team/malaka-silva/>
>>>> https://store.wso2.com/store/
>>>>
>>>> Save a tree -Conserve nature & Save the world for your future. Print
>>>> this email only if it is absolutely necessary.
>>>>
>>>
>>>
>>>
>>> --
>>> Thulasika
>>> Associate Software Engineer
>>> Mobile:0778014295
>>> email: [email protected] <[email protected]>
>>>
>>
>>
>>
>> --
>>
>> Best Regards,
>>
>> Malaka Silva
>> Senior Tech Lead
>> M: +94 777 219 791
>> Tel : 94 11 214 5345
>> Fax :94 11 2145300
>> Skype : malaka.sampath.silva
>> LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77
>> Blog : http://mrmalakasilva.blogspot.com/
>>
>> WSO2, Inc.
>> lean . enterprise . middleware
>> http://www.wso2.com/
>> http://www.wso2.com/about/team/malaka-silva/
>> <http://wso2.com/about/team/malaka-silva/>
>> https://store.wso2.com/store/
>>
>> Save a tree -Conserve nature & Save the world for your future. Print this
>> email only if it is absolutely necessary.
>>
>
>
>
> --
> Thulasika
> Associate Software Engineer
> Mobile:0778014295
> email: [email protected] <[email protected]>
>
_______________________________________________
Architecture mailing list
[email protected]
https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
