[SalesForce] How to perform upsert in SalesForce Bulk API with Multiple Update Key

I finally found the answer, it looks like the salesforce_bulk_api gem is not very well documented, fortunately the salesforcebulk gem is. The way to solve this is to:

1. Authenticate

    client = SalesforceBulk::Client.new(username: 'MyUsername', password: 'MyPasswordWithSecurtyToken')

    client.authenticate

1. Add the job

    job = client.add_job(:query, :Account)

1. Add the batch to the job

    batch = client.add_batch(job.id, "SELECT Id, Name FROM Account")

1. Close the job

    job = client.close_job(job.id)

1. Check the job status

    batch = client.batch_info(job.id, batch.id)

1. Get results from the batch

    results = client.batch_result(jobId, batchId)

1. Query over the results

    results.each do |result|
      puts result[:Name]
    end

Hi Tom for your question we need to divide this requirement into two parts:-

1) Retrieving the data from BulkApi queries, I hope no problem for you in that.

The data will get recieved in the form of files with the max. size per file is 1GB.

So as soon as u will get a CSV file out there the second task is to parse this first CSV file(considerring 2-3 more files are in quue) into the salesforce in batches.

So your second requirement will get fulfilled with the help of the function available here:- http://boards.developerforce.com/t5/Apex-Code-Development/Batch-Insert-of-Records-in-CSV-file/td-p/131413

This function will parallely start your procedure. and combination of two fulfill your task completly