SLAM_load_bulkv2

Note: For Bulk v2 operations, the @externalId is mandatory and must be a real Salesforce field. This is essential to correlate the Salesforce result with the original input table.

Parameters:

Name	Type	Default	Description
@sObject	NVARCHAR	Required	Salesforce object name to load data into
@table	NVARCHAR	Required	Source SQL table containing data to load
@operation	NVARCHAR	Required	Operation type ('insert', 'update', 'upsert', 'delete', 'hardDelete')
@externalId	NVARCHAR	Required	External ID field name (must be a real Salesforce field for result correlation). In the case of delete and hardDelete operations, use Id
@failure_threshold	DECIMAL(5,2)	100	Allowable failure rate (0-100) before raising an error

Usage Examples:

Upsert Account records using external ID:

EXEC dbo.SLAM_load_bulkv2
    @sObject = 'Account',
    @table = 'Account_upsert',
    @operation = 'upsert',
    @externalId = 'Account_External_Id__c'

Delete Opportunity records:

EXEC dbo.SLAM_load_bulkv2
    @sObject = 'Opportunity',
    @table = 'Opportunity_delete',
    @operation = 'delete',
    @externalId = 'Id'