The Spring '11 release introduced bulk queries as a pilot* feature of the Force.com Bulk API 21.0. With this feature, you can submit SOQL queries to Salesforce, run them asynchronously, and then download all your results once the query is completed. This is a huge win for any developers working with long-running queries or queries with large result sets. You no longer have to leave a connection open while the query is being executed or call queryMore() a zillion times to retrieve the full result set! You can even monitor the progress of the query in Salesforce and download the… Continue reading
Visit Ryan Brainard's personal blog on Developer Force
Bulk API Queries
In Blog: engineering | Tagged api, Bulk, Database, Integration, PHP, Query, SOQL, Tools, Workbench Leave a comment
Workbench for Winter ’11 Now Available
With Salesforce Winter ’11 now live on all instances, Workbench 20.0.0, Workbench Tools for Firefox 1.2.0, and the standalone PHP Bulk API Client 20.0.0 are now available for download.
Workbench is a powerful, web-based suite of tools designed for administrators and developers to interact with Salesforce.com organizations via the Force.com APIs, including robust support for the Force.com Partner, Bulk, Metadata, and Apex APIs to describe, query, manipulate, and migrate both data and metadata in Salesforce.com organizations directly in a web browser with a simple and intuitive user interface. Here are the highlights in the new version:
SOQL Matrix View
SOQL Matrix View is… Continue reading
In Blog: engineering | Tagged apex, api, Bulk, Database, force.com, Integration, Metadata, rest, salesforce, SOAP, Tools 3 Comments
Workbench 3.0 with Metadata API Support and More!
The next generation of Workbench 3.0 for Summer '10 is now available for download. Workbench is a powerful, web-based suite of tools designed for
adminstrators and developers to interact with Salesforce.com
organizations via the Force.com APIs, including the latest API 19.0. Workbench includes robust support
for the Force.com Partner, Bulk, Apex, and now Metadata APIs to describe, query, manipulate, and migrate both data and metadata
in Salesforce.com organizations directly in a web browser with a
simple and intuitive user interface. Workbench also provides many
advanced features for testing and troubleshooting,
such as customizable SOAP headers, debug logs for API traffic, backward
compatibility testing with previous API versions, and… Continue reading
PHP Client for Force.com Bulk API
With the Winter '10 release, Salesforce introduced the Force.com Bulk API to rapidly insert, update, and upsert data. To give administrators on-demand access to load data using this powerful new API, it was seemlessly integrated with the existing data loading capibilities of Workbench, a web-based suite of API tools for Salesforce. Now, to allow developers to incorporate Bulk API support into their own PHP applications, the same PHP Bulk API client in Workbench has been released as a standalone library and is available for download. This client takes care of all the REST-based interactions with Salesforce, error handling, and logging… Continue reading
Workbench: From Idea to 2.0
About a year ago, I started learning PHP and was just getting my feet wet with the Force.com API, and I soon realized what I would need to do to really learn both – build a web-based version of Apex Data Loader.
I had used the Data Loader to import and extract data, and it did this
pretty well, but thinking how cool it would be if this could all be
done directly in a web browser like the rest of the Salesforce on-demand applications, I was very excited to start this project.
It started with downloading the open source PHP Toolkit
and understanding how… Continue reading
