Newer Version Available
Examples of Asynchronous Calls
query Example:
1var result = sforce.connection.query("Select Name,Id from User", {
2 onSuccess : success,
3 onFailure : failure
4 });
5
6 function success(result) {
7 var records = result.getArray("records");
8
9 for (var i=0; i<records.length; i++) {
10 var record = records[i];
11 log(record.Name + " -- " + record.Id);
12 }
13 }
14
15 function failure(error) {
16 log("An error has occurred " + error);
17 }query Inline Function Example:
1var result = sforce.connection.query("Select Name,Id from User", {
2 onSuccess : function(result) {
3 var records = result.getArray("records");
4
5 for (var i=0; i<records.length; i++) {
6 var record = records[i];
7 log(record.Name + " -- " + record.Id);
8 }
9 },
10 onFailure : function(error) {
11 log("An error has occurred " + error);
12 }
13 });query With LIMIT Example:
1var result = sforce.connection.query("Select Name, Id from Account
2 order by Name limit 10", {
3 onSuccess : success, onFailure : failure});
4
5 function success(result) {
6 var it = new sforce.QueryResultIterator(result);
7 while(it.hasNext()){
8 var record = it.next();
9 log(record.Name + " -- " + record.Id);
10 }
11 }
12
13 function failure(error) {
14 log("An error has occurred " + error);
15 }queryResultIterator Example:
1var result = sforce.connection.query("Select Name,Id from User", {
2 onSuccess : success, onFailure : failure});
3
4 function success(result) {
5 var it = new sforce.QueryResultIterator(result);
6 while(it.hasNext()){
7 var record = it.next();
8 log(record.Name + " -- " + record.Id);
9 }
10 }
11
12 function failure(error) {
13 log("An error has occurred " + error);
14 }queryMore Example:
1sforce.connection.query("Select Name,Id from Account", {
2 onSuccess : success, onFailure : log });
3
4 function success(result) {
5 var records = result.getArray("records");
6
7 var sb = new sforce.StringBuffer();
8 for (var i=0; i<records.length; i++) {
9 var record = records[i];
10 sb.append(record.Name).append(",");
11 }
12
13 log(records.length);
14 log(sb.toString());
15
16 if (result.queryLocator) {
17 sforce.connection.queryMore(result.queryLocator, {
18 onSuccess : success, onFailure : log});
19 }
20 }create Example:
1var account = new sforce.SObject("Account");
2 account.Name = "my new account";
3
4 sforce.connection.create([account],
5 {onSuccess : success, onFailure : failed});
6
7 function success(result) {
8 if (result[0].getBoolean("success")) {
9 log("new account created with id " + result[0].id);
10 } else {
11 log("failed to create account " + result[0]);
12 }
13 }
14
15 function failed(error) {
16 log("An error has occurred " + error);
17 }create Other Objects Example:
1var campaign = new sforce.SObject("Campaign");
2 campaign.Name = "new campaign";
3 campaign.ActualCost = 12938.23;
4 campaign.EndDate = new Date();
5 campaign.IsActive = true;
6
7 sforce.connection.create([campaign ],
8 {onSuccess : success, onFailure : log});
9
10 function success(result) {
11 if (result[0].getBoolean("success")) {
12 log("new campaign created with id " + result[0].id);
13 } else {
14 log("failed to create campaign " + result[0]);
15 }
16 }retrieve Account Example:
1var account = new sforce.SObject("Account");
2 account.Name = "retrieve update test";
3 account.Phone = "2837484894";
4 var result = sforce.connection.create([account]);
5 if (result[0].getBoolean("success") == false) throw "create failed";
6 log("account created " + result[0]);
7
8 var callback = {
9 onSuccess: function(result) {
10 if (result[0] == null) throw "retrive failed";
11 log("account retrieved: " + result[0]);
12 },
13 onFailure: function(error) {
14 log("failed due to " + error);
15 }
16 };
17
18 result = sforce.connection.retrieve("Name,Phone", "Account",
19 [result[0].id], callback);