I developed a Express version of Salesforce Workbench:
package com.thysmichels; import java.io.IOException; import javax.servlet.http.*; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.http.*; import java.util.logging.*; import com.sforce.ws.*; import com.sforce.soap.partner.*; import com.sforce.soap.partner.sobject.SObject; @SuppressWarnings("serial") public class SalesforceGoogleAppServlet extends HttpServlet { private static final Logger log = Logger.getLogger(SalesforceGoogleAppServlet.class.getName()); private static String copytablestr; private String username = "username"; private String password = "passwordsecuritytoken"; private PartnerConnection connection; public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException { resp.setContentType("text/html"); PrintWriter t = resp.getWriter(); t.println(""); t.println(""); resp.getWriter().println("*** Welcome to Salesforce WorkBench Express ***" + "
"); getForceConnection( t, req); if ( connection == null ) { return; } QueryResult result = null; try { DescribeGlobalResult describeGlobalResult = connection.describeGlobal(); DescribeGlobalSObjectResult[] sobjectResults = describeGlobalResult.getSobjects(); //result = connection.query("Select id, name, phone from Account order by LastModifiedDate desc limit 10 "); t.println(""); t.println(""); t.println(""); for (int i = 0; i < sobjectResults.length; i++) { t.println("" + sobjectResults[i].getName() + ""); } t.println("" + "
"); t.println(""); t.println(""); //t.println("item 1item 2item 3item 4All"); } catch (ConnectionException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException { try { resp.setContentType("text/html"); PrintWriter t = resp.getWriter(); String str= req.getParameter("slt"); if (str != null) { DescribeSObjectResult describeSObjectResult = connection.describeSObject(str); if (describeSObjectResult != null) { t.println("*** Fields from Object : " + str + " ***
"); copytablestr = str; Field[] fields = describeSObjectResult.getFields(); t.println(""); t.println(""); for (int k = 0; k < fields.length; k++) { t.println("" + fields[k].getName() + ""); } t.println(""); t.println(""); } } String field[]= req.getParameterValues("fieldselect"); if (field != null) { t.println("
" + field[k] + " | "); } else { strconcat += "," + field[k]; t.println("" + field[k] + " | "); } } t.println("
" + s.getField(field[col]) + " | "); } t.print("
Access Salesforce Workbench Express Online Click Here
Pretty nice post. I simply stumbled upon your weblog and wished to mention that I’ve truly enjoyed surfing around your weblog posts. After all I’ll be subscribing on your
rss feed and I’m hoping you write again soon!