In this example, I am getting body as null, but before there is a log which prints body. Please help, thank you in advance.
I tried this answer too. From workbench I got name, id and description__c to be used as an external id for that SObject
I want to know there is any approach to send XML to Salesforce. After R&D I got a new error:
[{"errorCode":"JSON_PARSER_ERROR","message":"Unexpected character ('<' (code 60)): expected a valid value
If anyone has any other approach to that can be used to upsert external data into Salesforce, please make suggestions.
- Camel- 2.15.1.redhat-621084
- fuse-6.2.1
- IDE-codeready studio
salesforce.xml
<?xml version="1.0" encoding="UTF-8"?>
<blueprint xmlns="http://www.osgi.org/xmlns/blueprint/v1.0.0"
xmlns:cm="http://aries.apache.org/blueprint/xmlns/blueprint-cm/v1.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://aries.apache.org/blueprint/xmlns/blueprint-cm/v1.0.0 https://aries.apache.org/schemas/blueprint-cm/blueprint-cm-1.0.0.xsd http://www.osgi.org/xmlns/blueprint/v1.0.0 https://www.osgi.org/xmlns/blueprint/v1.0.0/blueprint.xsd http://camel.apache.org/schema/blueprint https://camel.apache.org/schema/blueprint/camel-blueprint.xsd">
<!-- OSGi blueprint property placeholder -->
<cm:property-placeholder id="placeholder" persistent-id="org.jboss.quickstarts.fuse.salesforce"/>
<bean
class="org.apache.camel.component.salesforce.SalesforceComponent" id="salesforce">
<property name="loginConfig">
<bean class="org.apache.camel.component.salesforce.SalesforceLoginConfig">
<property name="loginUrl" value="${loginUrl}"/>
<property name="clientId" value="${clientId}"/>
<property name="clientSecret" value="${clientSecret}"/>
<property name="userName" value="${userName}"/>
<property name="password" value="${password}"/>
</bean>
</property>
<property name="packages">
<array>
<value>com.cg.Pojos</value>
</array>
</property>
</bean>
<bean class="org.jboss.quickstarts.fuse.salesforce.RouteXml" id="data"/>
<camelContext id="salesforce-example-context" xmlns="http://camel.apache.org/schema/blueprint">
<routeBuilder ref="data"/>
</camelContext>
</blueprint>
Route
from("direct:sale").log("============Received Request from User To get XML===========")
.pollEnrich("file:C:/jboss-fuse-6.2.1.redhat-084/work/camel-salesforce/input")
.doTry()
.unmarshal(xmlDataFormat).log("${body}")
.bean(JobCardBean.class,"WriteFile") // just for make json
.bean(JobCardBean.class,"readFile") // just for json to object
.log("${body}") // till here i got object in body
.to("salesforce:upsertSObject?sObjectIdName=Name")
choice()
.when().simple("${body} != null")
.log("Created job with result success=${body.success} and errors=${body.errors}")
.otherwise()
.log("Updated job in salesforce")
.end();
logs
[route56 ] [to63 ] [direct:sale ] [ 1842]
[route58 ] [log162 ] [log ] [ 0]
[route58 ] [pollEnrich23 ] [pollEnrich[file:C:/jboss-fuse-6.2.1.redhat-084/work/camel-salesforce/input] ] [ 1011]
[route58 ] [doTry20 ] [doTry ] [ 830]
[route58 ] [unmarshal20 ] [unmarshal[org.apache.camel.model.DataFormatDefinition@1b5fd83] ] [ 3]
[route58 ] [log163 ] [log ] [ 30]
[route58 ] [bean35 ] [bean[com.capgemini.beans.JobCardBean@461fb6bd] ] [ 8]
[route58 ] [bean36 ] [bean[com.capgemini.beans.JobCardBean@5afe909b] ] [ 4]
[route58 ] [setHeader33 ] [setHeader[CamelHttpQuery] ] [ 0]
[route58 ] [setHeader34 ] [setHeader[CamelHttpMethod] ] [ 0]
[route58 ] [log164 ] [log ] [ 1]
[route58 ] [to66 ] [salesforce:upsertSObject?sObjectIdName=Name ] [ 783]
Exchange
---------------------------------------------------------------------------------------------------------------------------------------
Exchange[
Id ID-DIN17000356-51667-1583407046067-12-2
ExchangePattern InOut
Headers {
CamelFileAbsolute=true,
CamelFileAbsolutePath=C:\jboss-fuse-6.2.1.redhat-084\work\camel-salesforce\input\job.xml,
CamelFileContentType=text/xml,
CamelFileLastModified=1583322179800,
CamelFileLength=330,
CamelFileName=job.xml,
CamelFileNameConsumed=job.xml,
CamelFileNameOnly=job.xml,
CamelFileParent=C:\jboss-fuse-6.2.1.redhat-084\work\camel-salesforce\input,
CamelFilePath=C:\jboss-fuse-6.2.1.redhat-084\work\camel-salesforce\input\job.xml,
CamelFileRelativePath=job.xml,
CamelHttpMethod=POST,
CamelHttpQuery=_HTTPMethod=PATCH,
CamelRedelivered=false,
CamelRedeliveryCounter=0,
CamelToEndpoint=file://C:/jboss-fuse-6.2.1.redhat-084/work/camel-salesforce/input
}
BodyType null
Body [Body is null]
]
Stacktrace
---------------------------------------------------------------------------------------------------------------------------------------
{ message:'Error {400:Bad Request} executing {PATCH:/services/data/v33.0/sobjects/PSA_Job_Master__c/Name/temp}',statusCode:400}
at org.apache.camel.component.salesforce.internal.client.AbstractClientBase$1.onResponseComplete(AbstractClientBase.java:140)
[314:org.apache.camel.camel-salesforce:2.15.1.redhat-621084]