Hi Lochana, We don't support the custom fields in creating the job.
[1] https://docs.wso2.com/display/ESBCONNECTORS/Working+with+Jobs+in+SalesforceBulk#WorkingwithJobsinSalesforceBulk-createJob Thanks On Wed, Mar 21, 2018 at 12:50 PM, Lochana De Alwis <[email protected]> wrote: > 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 > > -- Shakila Sasikaran Software Engineer Mobile :+94 (0) 77 526 6848 [email protected] WSO2, Inc. lean . enterprise . middleware http://www.wso2.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
