function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
birdofpreybirdofprey 

Bulk API query batch insert into SQL

How are you guys iterating through the batch results?

 

Normally, if I want to insert it directly to SQL table using SOAP API, i can just do it directly by going through iteration of the array result and insert it each result directly (Ex. $record[0]->Id).

 

For a bulk, result is coming out like this as a single array.

 

Array
(
    [752f00000004CRH] => "Id","Name"
"003f0000001xx","First 1 Last 1"
"003f0000001xx","First 2 Last 2"
"003f0000001xx","First 3 Last 3"
}