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 activate and test the integration -