Hi Amal, We have implemented the google spreadsheet connector with OAuth2 support. You can find the connector here[1].
[1] - https://github.com/wso2/esb-connectors/tree/master/googlespreadsheet/2.0.0 Regards, -- *Naasheer Ali* | Associate Software Engineer WSO2, Inc |#20, Palm Grove, Colombo 03, Sri Lanka Email: [email protected] On Mon, Jun 1, 2015 at 4:32 PM, Rajith Vitharana <[email protected]> wrote: > Hi, > > Similar issue occurred in DSS as well. It seems google may have changed > there authentication mechanism. According to [2],[3],[4] google stopped > supporting Oauth 1.0 and that may be the case for this issue. Public jira > for DSS is in [1] > > [1] - https://wso2.org/jira/browse/DS-1049 > [2] - https://developers.google.com/identity/protocols/OAuthForWebApps > [3] - https://bugs.launchpad.net/ubuntu/+source/googlecl/+bug/1408503 > [4] - https://developers.google.com/identity/protocols/OAuth_ref > > Thanks, > > On Mon, Jun 1, 2015 at 4:20 PM, Amal Gunatilake <[email protected]> wrote: > >> +chanaka >> >> On Mon, Jun 1, 2015 at 3:48 PM, Amal Gunatilake <[email protected]> wrote: >> >>> Hi Vanji, >>> >>> I was trying to connect to a google spreadsheet using the ESB connector >>> and I get the following error when the proxy is invoked. >>> >>> *<soapenv:Envelope >>> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ >>> <http://schemas.xmlsoap.org/soap/envelope/>">* >>> * <soapenv:Header/>* >>> * <soapenv:Body>* >>> * <ns:ErrorResponse >>> xmlns:ns="http://org.wso2.esbconnectors.googlespreadsheet >>> <http://org.wso2.esbconnectors.googlespreadsheet>">* >>> * <ns:ErrorMessage>Error authenticating (check service >>> name)</ns:ErrorMessage>* >>> * </ns:ErrorResponse>* >>> * </soapenv:Body>* >>> *</soapenv:Envelope>* >>> >>> I downloaded the googleSpreadsheet connector from [1], deployed it in >>> the ESB 4.8.1 server and have enabled it according to documentation[2]. >>> >>> Could you please help me to identify the issue? >>> >>> Following is my synapse configurations >>> >>> *<definitions xmlns="http://ws.apache.org/ns/synapse >>> <http://ws.apache.org/ns/synapse>">* >>> * <registry >>> provider="org.wso2.carbon.mediation.registry.WSO2Registry">* >>> * <parameter name="cachableDuration">15000</parameter>* >>> * </registry>* >>> * <import name="googlespreadsheet"* >>> * package="org.wso2.carbon.connectors"* >>> * status="enabled"/>* >>> * <proxy name="testCon"* >>> * transports="https http"* >>> * startOnLoad="true"* >>> * trace="disable">* >>> * <description/>* >>> * <target>* >>> * <inSequence>* >>> * <googlespreadsheet.usernameLogin>* >>> * <username>[email protected] >>> <[email protected]></username>* >>> * <password>wso2carbon</password>* >>> * </googlespreadsheet.usernameLogin>* >>> * <googlespreadsheet.getAllSpreadsheets >>> configKey="MyGSConfig"/>* >>> * <respond/>* >>> * </inSequence>* >>> * </target>* >>> * </proxy>* >>> * <localEntry key="MyGSConfig">* >>> * <googlespreadsheet.usernameLogin>* >>> * <username>[email protected] <[email protected]></username>* >>> * <password>wso2carbon</password>* >>> * </googlespreadsheet.usernameLogin>* >>> * <description>Authentication config</description>* >>> * </localEntry>* >>> * <sequence name="fault">* >>> * <log level="full">* >>> * <property name="MESSAGE" value="Executing default 'fault' >>> sequence"/>* >>> * <property name="ERROR_CODE" >>> expression="get-property('ERROR_CODE')"/>* >>> * <property name="ERROR_MESSAGE" >>> expression="get-property('ERROR_MESSAGE')"/>* >>> * </log>* >>> * <drop/>* >>> * </sequence>* >>> * <sequence name="main">* >>> * <in>* >>> * <log level="full"/>* >>> * <filter source="get-property('To')" >>> regex="http://localhost:9000.*";>* >>> * <send/>* >>> * </filter>* >>> * </in>* >>> * <out>* >>> * <send/>* >>> * </out>* >>> * <description>The main sequence for the message >>> mediation</description>* >>> * </sequence>* >>> *</definitions>* >>> >>> [1] >>> https://github.com/wso2/esb-connectors/tree/master/distribution/google-spreadsheet >>> [2] https://docs.wso2.com/display/ESB480/Google+Spreadsheet+Connector >>> >>> Best regards, >>> Amal. >>> -- >>> *Amal Gunatilake* >>> Software Engineer >>> WSO2 Inc.; http://wso2.com >>> lean.enterprise.middleware >>> >> >> >> >> -- >> *Amal Gunatilake* >> Software Engineer >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Rajith Vitharana > > Software Engineer, > WSO2 Inc. : wso2.com > Mobile : +94715883223 > Blog : http://lankavitharana.blogspot.com/ > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
