Hi Shakila, Is upsert in Salesforce bulkapi jobs are available in SalesforceBulkApi connector? Is insert job also acts as an upsert? As an example I need to upload new records as well as update existing records in same batch? So can you suggest me a way...?
Regards, Prasan De Alwis On 21 Mar 2018 1:42 p.m., "Shakila Sasikaran" <[email protected]> wrote: > 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 <+94%2077%20526%206848> > [email protected] > WSO2, Inc. > lean . enterprise . middleware > http://www.wso2.com/ >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
