Hello

Feel free to improve it and then share it with everybody

Please replace [ and ] where you normally should have < and > (that is on html or xml tags

Code guys

[!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"]
[html]
[head]

[title][/title]
[script language="JavaScript"]
[!--
var sessionid = "{!API_Session_ID}";
var apiServer = "{!API_Enterprise_Server_URL_50}";
var SoapHeader = "[?xml version=\"1.0\" encoding=\"UTF-8\"?]";
SoapHeader += "[soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"]";
SoapHeader += "[soapenv:Header]";
SoapHeader += "[ns1:SessionHeader soapenv:mustUnderstand=\"0\" xmlns:ns1=\"urn:enterprise.soap.sforce.com\"]";
SoapHeader += "[ns2:sessionId xmlns:ns2=\"urn:enterprise.soap.sforce.com\"]" + sessionid + "[/ns2:sessionId]";
SoapHeader += "[/ns1:SessionHeader]";
SoapHeader += "[/soapenv:Header]";
SoapHeader += "[soapenv:Body]";

var SoapFooter = "[/soapenv:Body]";
SoapFooter += "[/soapenv:Envelope]";

var agt = navigator.userAgent.toLowerCase();
var is_gecko = (agt.indexOf('gecko') != -1);
var is_ie = (agt.indexOf("msie") != -1);
// This will be a double dimension array of objects called Record (Record could be seen has a salesforce object)
var Results = new Array();

//here I create the XML Http Request
if (is_ie){
var xmlReq = new ActiveXObject("Microsoft.XMLHTTP");}
else { var xmlReq = new XMLHttpRequest(); }

//here I create the salesforce object with only id as property for the moment
function Record()
{
this.Id = '';
}

//You have to send an array of Ids to this function and the objects are deleted provided you have the right to do so
function deleteId(ids)
{

var delCommand = SoapHeader;
delCommand += "[delete xmlns=\"urn:enterprise.soap.sforce.com\"]";
for (var j=0;j {
delCommand += "[ids]" + ids[j] + "[/ids]";
}

delCommand += "[/delete]";
delCommand += SoapFooter;
xmlReq.open("POST", apiServer, false);
xmlReq.setRequestHeader("Content-Type","text/xml");
xmlReq.setRequestHeader("SOAPaction","delete");
xmlReq.send(delCommand);
}

/*Here you have a standard query in javascript
you have to pass the queryname as a String
fields as an Array of the field you want in your Select
sfoject as a String representing the Salesforce Object
whereclause as a string with your clause already built (without the where)*/
function query(qryname, fields,sfobject,whereclause)
{
var fieldstring = "";
for (var j=0;j if (fieldstring == "") {fieldstring = fields[j] ;}
else {fieldstring += "," + fields[j];};
}
var queryCommand = SoapHeader;
queryCommand += "[query xmlns=\"urn:enterprise.soap.sforce.com\"]";
if (whereclause=="") {
queryCommand += "[queryString]Select " + fieldstring + " from " + sfobject + "[/queryString]";
}
else {
queryCommand += "[queryString]Select " + fieldstring + " from " + sfobject + " where " + whereclause + "[/queryString]";
}
queryCommand += "[/query]";
queryCommand += SoapFooter;
xmlReq.open("POST", apiServer, false);
xmlReq.setRequestHeader("Content-Type","text/xml");
xmlReq.setRequestHeader("SOAPaction","query");
xmlReq.send(queryCommand);
// here I am going to the root element
var xmlDoc = xmlReq.responseXML.documentElement;
// I am going to the parent of the results
var objNodeList = xmlDoc.getElementsByTagName("records");
var sfid = "";
for (var j=0;j for (var k =0;k if (is_ie) {
var field = objNodeList.item(j).childNodes.item(k).text;}
else {
if (objNodeList.item(j).childNodes.item(k).childNodes.length>0)
{var field = objNodeList.item(j).childNodes.item(k).firstChild.nodeValue;}
}
switch(objNodeList.item(j).childNodes.item(k).nodeName)
{
case "sf:Id":
// Here I create a new object and the array Results[qryname] get a new entry each time an id is discovered
Results[qryname][field] = new Record;
for (var x=1;x Results[qryname][field][fields[x]]=''; //here I extend the properties of the ojbect record with all the fields
}
Results[qryname][field].Id = field;
sfid = field;
break;
default :
if (objNodeList.item(j).childNodes.item(k).nodeName.substring(0,3) == 'sf:') {
node = objNodeList.item(j).childNodes.item(k).nodeName.substring(3,objNodeList.item(j).childNodes.item(k).nodeName.length);
Results[qryname][sfid][node]= field; //here I fill the properties with the matching values coming from salesforce.com
}
break;

}
}
}
}

var fld = new Array();
// exemple for Account object: I create an array Results['Account'] to store the results send by my query on Account
Results['Account'] = new Array();
// here I create the field list
//IMPORTANT: Please always include the Id Field
fld = ['Id','Name','Site'];
//Here I am constructing my clause (AccountId here is a variable)
clause = "Id = '" + AccountId + "'";
//here I am making my query
query('Account',fld,'Account', clause);
var AcctInfo = "";
//I browse through my results
for (var x in Results['Account'])
{
AcctInfo += Results['Account'][x].Name + " " + Results['Account'][x].Site;
}
/*
In fact with this snippet and the construction of the multidimensionnal array Results you can store all the results of you query so that you can retrieve them later on in th code.

*/
// here an example of the combined use of delete and query function
var deleteids = new Array();
Results['Task'] = new Array;
clause = "WhoId='00320000002Ece0'";
fld = ['Id'];
query('Task',fld,'Task',clause);
var j=0;
for (var x in Results['Task'])
{
deleteids [j] = Results['Task'][x].Id;
j++;
}
deleteId(deleteids);
[/script]
[/body]
[/html]