You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by Bikash Kaushik <ka...@gmail.com> on 2019/06/25 14:27:45 UTC
splitResults option shows unknown in google-sheets-stream component
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*
Re: splitResults option shows unknown in google-sheets-stream component
Posted by Bikash Kaushik <ka...@gmail.com>.
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 <cl...@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
> <ka...@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 <
> cdeppisch@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 <cl...@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
> > > > <ka...@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 <
> > > cdeppisch@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 <
> > > > kaushikbikash28@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*
Re: splitResults option shows unknown in google-sheets-stream component
Posted by Claus Ibsen <cl...@gmail.com>.
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
<ka...@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 <cd...@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 <cl...@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
> > > <ka...@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 <
> > cdeppisch@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 <
> > > kaushikbikash28@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
Re: splitResults option shows unknown in google-sheets-stream component
Posted by Bikash Kaushik <ka...@gmail.com>.
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 <cd...@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 <cl...@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
> > <ka...@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 <
> cdeppisch@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 <
> > kaushikbikash28@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*
Re: splitResults option shows unknown in google-sheets-stream component
Posted by Christoph Deppisch <cd...@redhat.com>.
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 <cl...@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
> <ka...@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 <cdeppisch@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 <
> kaushikbikash28@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
>
Re: splitResults option shows unknown in google-sheets-stream component
Posted by Claus Ibsen <cl...@gmail.com>.
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
<ka...@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 <cd...@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 <ka...@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
Re: splitResults option shows unknown in google-sheets-stream component
Posted by Bikash Kaushik <ka...@gmail.com>.
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 <cd...@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 <ka...@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*
Re: splitResults option shows unknown in google-sheets-stream component
Posted by Christoph Deppisch <cd...@redhat.com>.
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 <ka...@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*
>