Newer Version Available

This content describes an older version of this product. View Latest

Asynchronous Examples

The following examples are asynchronous calls. These samples use callback methods to the API call.

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);