query issues with SalesForce connector

[luca_del_bon]

I'm tring to use the Salesforce connector in order to integrate it with a legacy application,

but I'm experiencing issues with "query" and "upsert" topics.

When I execute a query with a route like this :

<!--  TEST ROUTE -->

<camelContext xmlns="http://camel.apache.org/schema/spring">

    <route>

        <from uri="timer:foo?period=2000&amp;repeatCount=1" id="Timer"/>

        <to uri="salesforce:query?sObjectQuery=SELECT Id,Name FROM Account"/>

    </route>

</camelContext>

Fuse responds with an exception (statusCode: 0) message :

[mel-1) thread #0 - timer://foo] TimerConsumer                  WARN  Error processing exchange. Exchange[Message: [Body is null]]. Caused by: [org.apache.camel.component.salesforce.api.SalesforceException - { statusCode: 0}]

{ { statusCode: 0}, statusCode: 0}

        at org.apache.camel.component.salesforce.internal.processor.AbstractRestProcessor.process(AbstractRestProcessor.java:135)

        at org.apache.camel.component.salesforce.SalesforceProducer.process(SalesforceProducer.java:82)

        at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:120)

        at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:72)

        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:416)

        at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)

        at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)

        at org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:166)

        at org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:74)

        at java.util.TimerThread.mainLoop(Timer.java:555)

        at java.util.TimerThread.run(Timer.java:505)

any help would be appreciated.

Luca

[simondelfab]

I had the same problem. Try:

<to uri="salesforce:query?sObjectQuery=SELECT Id,Name FROM Account&amp;sObjectClass=org.apache.camel.salesforce.dto.QueryRecordsAccount"/>

I also had a problem where I didn't copy the DTOs generated to the src folder (see ~ Maggie's JBoss ~: JBoss Fuse - Connecting to Salesforce (Part 1))

[luca_del_bon]

Thank you Simon,

It works as expected !

[kaleem.ahmed]

Thank you this one helped me big time. I have had been searching for past 3 days with no clue. The issue was most tutorial/examples wrongly instruct to use

<to uri="salesforce:query?sObjectQuery=SELECT id,name from Account&amp;sObjectClass=org.apache.camel.salesforce.dto.Account.class" />

where as the correct way (as pointer by Simon) is

<to uri="salesforce:query?sObjectQuery=SELECT Id,Name FROM Account&amp;sObjectClass=org.apache.camel.salesforce.dto.QueryRecordsAccount"/>

[brajeshbharti]

Hi Luca,

You can use below code before "<to uri="salesforce:query?sObjectQuery=SELECT Id,Name FROM Account"/>" it should work.

<setBody>

  <constant>jobInfo</constant>

</setBody>

like:

<camelContext xmlns="http://camel.apache.org/schema/spring">

    <route>

        <from uri="timer:foo?period=2000&amp;repeatCount=1" id="Timer"/>

       <setBody>

           <constant>jobInfo</constant>

       </setBody>

        <to uri="salesforce:query?sObjectQuery=SELECT Id,Name FROM Account"/>

    </route>

</camelContext>

Thanks,

Brajesh