Sunday, June 6, 2021

#859 OIC - SFDC -Bulk api

Simple example here - I use the bulk api to load data from an Oracle DB into an SFDC custom object.

Here is my DB table - 

Here is my SFDC custom object -

The integration is simple - 

The SFDC invoke is configured as follows - 

Here is the content of the DB table - 

Activate and test - review in SFDC - 

The job stays here - remaining in progress.

I need to revisit the integration and add the following invoke to SFDC - 


Activate and Test - 

Now let's look at the response from CompleteBulkLoad shown above - 

2 records failed - now this is because I have already done a successful import for these 2 rows - 

I check in SFDC - 

The job is completed, but failed for the aforementioned reason.

I update the DB rows and re-test - 

Naturally, I can also model the integration as follows, i.e. without the loop -


The Map to BulkLoadCustomObject is then as follows - 

I update the DB rows to ensure no duplicates on load - 


I activate and test the integration - 

Leveraging UPSERT option

Ensure the SFDC custom object has a field with the following box checked - External Id

I need to map an extra field, apart from my 4 fields - 

I set this to the external id field name, concatenated with an empty string e.g.
concat ("field1Required__c", "" )

Activate, test -

No comments: