Hi Team,
Im using SalesforceBulkApi connector(1.0.3) in WSO2 ESB(4.9.0) to upload
bulk object(Account) data to salesforce. I have created a test proxy
service to upload Account data to Salesforce..
Im having trouble to create the job using Upsert. Could you please go
through below xml of proxy service.
<salesforcebulk.createJob>
<operation>upsert</operation>
<contentType>XML</contentType>
<externalIdFieldName>External_ID__c</externalIdFieldName>
<object>Account</object>
</salesforcebulk.createJob>
Im getting below error when calling from ESB.
<error xmlns="http://www.force.com/2009/06/asyncapi/dataload";>
<exceptionCode>InvalidJob</exceptionCode>
<exceptionMessage>External ID was blank for Account. An External ID must
be specified for upsert.</exceptionMessage>
</error>
I have setup External_ID__c as external Id field in Salesforce Account
object.
I have send a REST API request successfully using postman and get response
successfully.
Below is the postman request and the response.
<?xml version="1.0" encoding="UTF-8"?>
<jobInfo xmlns="http://www.force.com/2009/06/asyncapi/dataload";>
<operation>*upsert*</operation>
<object>Account</object>
<externalIdFieldName>External_ID__c</externalIdFieldName>
<contentType>XML</contentType>
</jobInfo>
Response
<?xml version="1.0" encoding="UTF-8"?>
<jobInfo
xmlns="http://www.force.com/2009/06/asyncapi/dataload";>
<id>7509E000003PD6EQAW</id>
<operation>upsert</operation>
<object>Account</object>
<createdById>0059E000003TrvLQAS</createdById>
<createdDate>2018-03-21T06:39:37.000Z</createdDate>
<systemModstamp>2018-03-21T06:39:37.000Z</systemModstamp>
<state>Open</state>
<externalIdFieldName>External_ID__c</externalIdFieldName>
<concurrencyMode>Parallel</concurrencyMode>
<contentType>XML</contentType>
<numberBatchesQueued>0</numberBatchesQueued>
<numberBatchesInProgress>0</numberBatchesInProgress>
<numberBatchesCompleted>0</numberBatchesCompleted>
<numberBatchesFailed>0</numberBatchesFailed>
<numberBatchesTotal>0</numberBatchesTotal>
<numberRecordsProcessed>0</numberRecordsProcessed>
<numberRetries>0</numberRetries>
<apiVersion>42.0</apiVersion>
<numberRecordsFailed>0</numberRecordsFailed>
<totalProcessingTime>0</totalProcessingTime>
<apiActiveProcessingTime>0</apiActiveProcessingTime>
<apexProcessingTime>0</apexProcessingTime>
</jobInfo>
So could you tell me what is the issue from WSO2 ESB bulk API upsert?
Regards,
Prasan De Alwis
077-4747163
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
