Hi Manoj,

I have given this proxy configuration just for testing purposes. But you
can use our iPAAS recipe app to fetch the access tokens and refresh tokens.
Here we are using refresh tokens for offline access to a protected
resource. If the Access token is expired, we may use the refresh token to
obtain a new one. User should have access and refresh tokens obtained
beforehand to use this. The connector uses those tokens to access
resources. For an example read set of Tweets from a tweeter account and
write them back to a Google spreadsheet. You may parametrize this and
trigger an ESB task to get the work done.


Thanks & Regards,

On Fri, Oct 17, 2014 at 8:20 AM, Manoj Gunawardena <[email protected]> wrote:

> Hi Ravindra,
>
> proxy contains oauth acess token and refresh token, How those tokens
> fetch? Is there a service to fetch those token. Once the tokens expires,
> how new tokens add to the proxy? This proxy creates dynamically?
>
>
> Thanks
>
> On Thu, Oct 16, 2014 at 8:33 AM, Ravindra Ranwala <[email protected]>
> wrote:
>
>> Hi All,
>>
>> I have added OAuth 2 Authorization support for Google spreadsheet
>> connector. Using that now we can create a proxy/recipe which filters out
>> set of tweets from the twitter connector and writes back to a Google
>> spreadsheet via Google spreadsheet OAuth 2 connector support. I have given
>> the git repo location here.
>>
>>
>> https://github.com/ravindraranwala/esb-connectors/tree/googlespreadsheet-OAuth2
>>
>> When you create the proxy/recipe please build the above project and use
>> the Google spreadsheet connector created under the target directory and
>> upload it to the ESB.Make sure to explicitly enable the connector once
>> uploaded since it is disabled by default.
>>
>> A sample Proxy Configuration to read set of Tweets and write it back to a
>> Google spread sheet is given below. The changes compared to the Google
>> spreadsheet OAuth 1.0 configuration is highlighted here.
>>
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <proxy xmlns="http://ws.apache.org/ns/synapse";
>>        name="
>> twitterToGoogleSpreadsheetProxy"
>>        transports="https,http"
>>        statistics="disable"
>>        trace="disable"
>>        startOnLoad="true">
>>    <target>
>>       <inSequence>
>>          <twitter.init>
>>             <consumerKey>TWITTER_CONSUMER_KEY</consumerKey>
>>             <consumerSecret>TWITTER_CONSUMER_SECRET</consumerSecret>
>>             <accessToken>TWITTER_ACCESS_TOKEN</accessToken>
>>
>> <accessTokenSecret>TWITTER_ACCESS_TOKEN_SECRET</accessTokenSecret>
>>          </twitter.init>
>>          <twitter.search>
>>             <search>tuesday</search>
>>             <lang>en</lang>
>>          </twitter.search>
>>          <xslt key="twitterTransform"/>
>>          <log level="full"/>
>>          *<googlespreadsheet.oAuth2init>*
>>             <oauthConsumerKey>GOOGLE_CONSUMER_KEY
>> <http://212972391932-3thmh0maoodoin7t116vb0adpjjvckv0.apps.googleusercontent.com>
>> </oauthConsumerKey>
>>
>> <oauthConsumerSecret>GOOGLE_CONSUMER_SECRET</oauthConsumerSecret>
>>
>> *
>> <oauthAccessToken>GOOGLE_ACCESS_TOKEN</oauthAccessToken>
>> <oauthRefreshToken>GOOGLE_REFRESH_TOKEN</oauthRefreshToken>*
>>          *</googlespreadsheet.oAuth2init>*
>>          <googlespreadsheet.importCSV>
>>             <spreadsheetName>Tweets</spreadsheetName>
>>             <worksheetName>Sheet1</worksheetName>
>>             <batchEnable>true</batchEnable>
>>             <batchSize>100</batchSize>
>>          </googlespreadsheet.importCSV>
>>          <respond/>
>>       </inSequence>
>>    </target>
>>    <description/>
>> </proxy>
>>
>>
>> Thanks & Regards,
>>
>>
>> --
>> Ravindra Ranwala
>> Software Engineer
>> WSO2, Inc: http://wso2.com
>> <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg>
>> Mobile: +94714198770
>>
>>
>> _______________________________________________
>> Dev mailing list
>> [email protected]
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
>
> --
> Manoj Gunawardena
> Tech Lead
> WSO2, Inc.: http://wso2.com
> lean.enterprise.middleware
> Mobile : +94 77 2291643
>



-- 
Ravindra Ranwala
Software Engineer
WSO2, Inc: http://wso2.com
<http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg>
Mobile: +94714198770
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to