try to use 2.21.0.fuse-740028 or a later version. This should work as it has the google-sheets component with splitResults support.
On Tue, Jun 25, 2019 at 6:39 PM Claus Ibsen <claus.ib...@gmail.com> wrote: > Hi > > Okay you are using Camel 2.21, so you should look at the docs for that > version. > > Also you are using Red Hat Fuse, and they also have docs for the > components that matches the Camel version they ship in their product. > > On Tue, Jun 25, 2019 at 5:30 PM Bikash Kaushik > <kaushikbikas...@gmail.com> wrote: > > > > Hi, > > > > Thanks for reply , > > > > *Please find gooogle-sheets-stream endpoint URI :* > > > > <from > > > uri="google-sheets-stream://spreadsheets?accessToken=ya29.GlsxB7BpSyCqPcOJnINvy_MzbD4_zn_wVzc8Ndtpxj1-q_0tO3RfFNOO4y9-HWt4qiHY2X_Py2hmpmwjQFKEe7JbPkE-p&clientId= > > 36618-stgf0ekhams3ln4fo3.apps.googleusercontent.com > &clientSecret=mMMgCHhbyBeBI&applicationName=CamelGoogleApp&refreshToken=1/zwgy73W-pcNoCtbOxs_t4b0&spreadsheetId=1hkw_0oOaQDIRZVX_19LpywE&range=Form > > Responses 1"/> > > > > *Please find mvn dependency:tree output ,* > > > > [INFO] +- > > org.apache.camel:camel-core:jar:2.21.0.fuse-730078-redhat-00001:compile > > [INFO] | +- com.sun.xml.bind:jaxb-core:jar:2.3.0:compile > > [INFO] | \- com.sun.xml.bind:jaxb-impl:jar:2.3.0:compile > > [INFO] +- > > > org.apache.camel:camel-blueprint:jar:2.21.0.fuse-730078-redhat-00001:compile > > [INFO] | +- > > > org.apache.camel:camel-core-xml:jar:2.21.0.fuse-730078-redhat-00001:compile > > [INFO] | \- > > > org.apache.camel:camel-core-osgi:jar:2.21.0.fuse-730078-redhat-00001:compile > > [INFO] +- org.apache.camel:camel-google-sheets:jar:2.24.1:compile > > [INFO] | +- com.google.api-client:google-api-client:jar:1.22.0:compile > > [INFO] | | \- com.google.guava:guava-jdk5:jar:17.0:compile > > [INFO] | +- > com.google.oauth-client:google-oauth-client:jar:1.22.0:compile > > [INFO] | | +- > com.google.http-client:google-http-client:jar:1.22.0:compile > > [INFO] | | | \- org.apache.httpcomponents:httpclient:jar:4.5.5:compile > > [INFO] | | | +- > org.apache.httpcomponents:httpcore:jar:4.4.9:compile > > [INFO] | | | \- > > commons-codec:commons-codec:jar:1.11.0.redhat-00001:compile > > [INFO] | | \- com.google.code.findbugs:jsr305:jar:1.3.9:compile > > [INFO] | +- > > com.google.http-client:google-http-client-jackson2:jar:1.22.0:compile > > [INFO] | | \- > com.fasterxml.jackson.core:jackson-core:jar:2.8.11:compile > > [INFO] | \- > > com.google.apis:google-api-services-sheets:jar:v4-rev551-1.22.0:compile > > [INFO] +- org.slf4j:slf4j-api:jar:1.7.22.redhat-2:compile > > [INFO] +- org.slf4j:slf4j-log4j12:jar:1.7.22.redhat-2:compile > > [INFO] +- log4j:log4j:jar:1.2.17.redhat-3:compile > > [INFO] \- > > > org.apache.camel:camel-test-blueprint:jar:2.21.0.fuse-730078-redhat-00001:test > > [INFO] +- > > org.apache.camel:camel-test:jar:2.21.0.fuse-730078-redhat-00001:test > > [INFO] +- > > org.apache.aries.proxy:org.apache.aries.proxy.api:jar:1.1.0:test > > [INFO] +- org.apache.aries.proxy:org.apache.aries.proxy:jar:1.1.4:test > > [INFO] +- > > > org.apache.aries.blueprint:org.apache.aries.blueprint.api:jar:1.0.1.redhat-611412:test > > [INFO] +- > > > org.apache.aries.blueprint:org.apache.aries.blueprint.core:jar:1.10.1:test > > [INFO] | \- > > org.apache.aries.quiesce:org.apache.aries.quiesce.api:jar:1.0.0:test > > [INFO] +- org.apache.aries.blueprint:org.apache.aries.blueprint.cm: > > jar:1.3.1:test > > [INFO] +- org.apache.aries:org.apache.aries.util:jar:1.1.3:test > > [INFO] +- org.apache.felix:org.apache.felix.connect:jar:0.2.0:test > > [INFO] +- > org.ops4j.pax.swissbox:pax-swissbox-tinybundles:jar:1.3.2:test > > [INFO] | +- org.ops4j.base:ops4j-base-lang:jar:1.5.0:test > > [INFO] | +- org.ops4j.base:ops4j-base-io:jar:1.5.0:test > > [INFO] | | \- org.ops4j.base:ops4j-base-monitors:jar:1.5.0:test > > [INFO] | +- org.ops4j.base:ops4j-base-store:jar:1.5.0:test > > [INFO] | \- org.ops4j.pax.swissbox:pax-swissbox-bnd:jar:1.8.3:test > > [INFO] | \- biz.aQute.bnd:bndlib:jar:2.4.0:test > > [INFO] +- commons-logging:commons-logging:jar:1.2.0.redhat-3:compile > > [INFO] +- junit:junit:jar:4.12.0.redhat-003:test > > [INFO] | \- org.hamcrest:hamcrest-core:jar:1.3-redhat-1:test > > [INFO] \- > org.apache.felix:org.apache.felix.configadmin:jar:1.9.14:test > > > > > > > > > > > > > > On Tue, Jun 25, 2019 at 8:36 PM Christoph Deppisch <cdeppi...@redhat.com > > > > wrote: > > > > > Hi, > > > > > > I think we have to make sure that your project is using Camel 2.24.x > and no > > > other version like 2.23.x is there in the line of dependencies. Are you > > > using Maven? If so could you please try a 'mvn dependency:tree' and > make > > > sure that there is only 2.24.x in that tree? > > > > > > Also it would be good to see the gooogle-sheets-stream endpoint URI > that > > > you are using in your route. Could you please provide that, too? Many > > > thanks! > > > > > > Regards, > > > Christoph > > > > > > On Tue, Jun 25, 2019 at 4:28 PM Bikash Kaushik < > kaushikbikas...@gmail.com> > > > wrote: > > > > > > > Hi, > > > > > > > > I'm using google-sheets-stream component to read google sheet and it > is > > > > working fine, but I want to split the body into rows and columns, > there > > > is > > > > an option called "splitResults" given in camel doc, but when I'm > using > > > that > > > > option it throws "unknown parameters" error. > > > > > > > > *Anybody have any idea about this?* > > > > > > > > *Camel Doc :* > > > > > > > > > > > > https://github.com/apache/camel/blob/master/components/camel-google-sheets/src/main/docs/google-sheets-stream-component.adoc > > > > > > > > *Camel Version: 2.24.1* > > > > > > > > *Log :* > > > > There are 1 parameters that couldn't be set on the endpoint. Check > the > > > uri > > > > if the parameters are spelt correctly and that they are properties > of the > > > > endpoint. Unknown parameters=[{splitResults=true}] > > > > at > > > > > > > > org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:209) > > > > at > > > > > > > > > > > > org.apache.camel.impl.DefaultCamelContext.startRoute(DefaultCamelContext.java:1143) > > > > at > > > > > > > > > > > > org.apache.camel.impl.DefaultCamelContext.startRouteDefinitions(DefaultCamelContext.java:3729) > > > > at > > > > > > > > > > > > org.apache.camel.impl.DefaultCamelContext.doStartCamel(DefaultCamelContext.java:3443) > > > > at > > > > > > > > > > > > org.apache.camel.impl.DefaultCamelContext.access$000(DefaultCamelContext.java:209) > > > > at > > > > > > > > > > > > org.apache.camel.impl.DefaultCamelContext$2.call(DefaultCamelContext.java:3251) > > > > at > > > > > > > > > > > > org.apache.camel.impl.DefaultCamelContext$2.call(DefaultCamelContext.java:3247) > > > > > > > > -- > > > > > > > > > > > > *Regards,* > > > > *Bikash Kaushik,* > > > > *NIT Jamshedpur* > > > > > > > > > > > > > -- > > > > > > *Regards,* > > *Bikash Kaushik,* > > *NIT Jamshedpur* > > > > -- > Claus Ibsen > ----------------- > http://davsclaus.com @davsclaus > Camel in Action 2: https://www.manning.com/ibsen2 >