In, Camel google sheet, maxResult option didn't work. And when I start my route, it continuosly do polling and do not stop after getting sheet body.
Regards, Bikash Kaushik On Wed, Jun 26, 2019 at 8:53 AM Claus Ibsen <claus.ib...@gmail.com> wrote: > Hi > > Again make sure to align and use the same Camel version. You have mixed. > And use the Fuse Camel version as suggested by Christoph. > > [INFO] | \- > org.apache.camel:camel-core-osgi:jar:2.21.0.fuse-740025:compile > [INFO] +- org.apache.camel:camel-google-sheets:jar:2.24.1:compile > > And you can ask Red Hat for help/support as its their product. Here we > only support upstream and vanilla Apache Camel. > > On Wed, Jun 26, 2019 at 3:26 AM Bikash Kaushik > <kaushikbikas...@gmail.com> wrote: > > > > Hi, > > > > Please find updated mvn dependency tree, as suggested by you to update > > version, still I'm not getting *splitResults * option in google > spreadsheet. > > > > [INFO] +- org.apache.camel:camel-core:jar:2.23.2.fuse-740002: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.23.2.fuse-740002:compile > > [INFO] | +- > org.apache.camel:camel-core-xml:jar:2.21.0.fuse-740025:compile > > [INFO] | \- > org.apache.camel:camel-core-osgi:jar:2.21.0.fuse-740025: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: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.10:compile > > [INFO] +- org.slf4j:slf4j-log4j12:jar:1.7.10:compile > > [INFO] +- log4j:log4j:jar:1.2.17: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-740025: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: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:compile > > [INFO] +- junit:junit:jar:4.12:test > > [INFO] | \- org.hamcrest:hamcrest-core:jar:1.3:test > > [INFO] \- > org.apache.felix:org.apache.felix.configadmin:jar:1.9.14:test > > > > On Tue, Jun 25, 2019 at 11:30 PM Christoph Deppisch < > cdeppi...@redhat.com> > > wrote: > > > > > 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 > > > > > > > > > > > > > -- > > > > > > *Regards,* > > *Bikash Kaushik,* > > *NIT Jamshedpur* > > > > -- > Claus Ibsen > ----------------- > http://davsclaus.com @davsclaus > Camel in Action 2: https://www.manning.com/ibsen2 > -- *Regards,* *Bikash Kaushik,* *NIT Jamshedpur*
