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
