AgileApps Support Wiki Pre Release

Difference between revisions of "AddRecord"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 53: Line 53:
This example add a record to an object that contains a [[Multi Object Lookup]], where:
This example add a record to an object that contains a [[Multi Object Lookup]], where:
:* <tt>Books</tt> is an object that contains a MultiObject Lookup field
:* <tt>Books</tt> is an object that contains a MultiObject Lookup field
:* <tt>libraryBook</tt> is a Multi Object Lookup field that points to a particular library and the book it came from
:* <tt>libraryBook</tt> is a Multi Object Lookup field that points to a particular book and the library it came from
:* <tt>9978946545</tt> is the ID the <tt>library</tt> object that contains the book.<br>Object ID must be specified. Object name will not work.)
:* <tt>MyLibrary</tt> is the object that contains the book.
:* <tt>767645492</tt> is the record ID of the book in that library
:* <tt>767645492</tt> is the record ID of the book in that library


Line 60: Line 60:
Parameters params = Functions.getParametersInstance();
Parameters params = Functions.getParametersInstance();
params.add("title", "A Good Book");  
params.add("title", "A Good Book");  
params.add("libraryBook", 9978946545:767645492");  
params.add("libraryBook", MyLibrary:767645492");  
                    //  {object_id}:{record_id}
                  //  {object_name}:{record_id}
Result result = Functions.addRecord("Books", params);  
Result result = Functions.addRecord("Books", params);  
int resultCode = result.getCode();
int resultCode = result.getCode();

Revision as of 16:23, 27 September 2011

Add a new record to an object.

Syntax

Result result = Functions.addRecord(String objectID, Parameters params);

Parameters

objectID
The Object to add the record to.
params
  • The field-value pairs for the object you are adding.
  • Turn off data policies that might otherwise fire as a result of this action:
params.add(PLATFORM.PARAMS.RECORD.DO_NOT_EXEC_DATA_POLICY,"1");
  • Pass file parameters in the current request to any subsequent API calls made in a data policy defined on this object:
params.add(PLATFORM.PARAMS.RECORD.ENABLE_MULTIPART,"1");
Return
Result object

Notepad.png

Note: The Result object contains the record ID for the new record. Use Result.getID() to retrieve it.

Example #1: Add a Record to the Account Class

This example creates an instance of Parameters and adds name-value pairs to it. The code then calls addRecord, assigning the returned value to an instance of Result and calling Result.getCode() to assign the error code to a variable which is then conditionally checked to determine the code to execute. If the call was not successful, the code calls throwError to display an error dialog.

Parameters params = Functions.getParametersInstance();
params.add("name", "Acme Solutions");
params.add("number", "GRG2323339");
Result result = Functions.addRecord("ACCOUNT", params);
int resultCode = result.getCode();
if(resultCode < 0)
{
    // Some error happened. 
    String msg = "Account could not be added";
    Functions.debug(msg + ":\n" + result.getMessage());  // Log details
    Functions.throwError(msg + ".");                     // Error dialog
}
else 
{
    // Take other actions on successful addition
    // of the account
}

Example #2: Add a Record with a Multi Object Lookup field

This example add a record to an object that contains a Multi Object Lookup, where:

  • Books is an object that contains a MultiObject Lookup field
  • libraryBook is a Multi Object Lookup field that points to a particular book and the library it came from
  • MyLibrary is the object that contains the book.
  • 767645492 is the record ID of the book in that library
Parameters params = Functions.getParametersInstance();
params.add("title", "A Good Book"); 
params.add("libraryBook", MyLibrary:767645492"); 
                  //  {object_name}:{record_id}
Result result = Functions.addRecord("Books", params); 
int resultCode = result.getCode();
if(resultCode < 0)
{
    // Some error happened. 
    String msg = "Book record could not be added";
    Functions.debug(msg + ":\n" + result.getMessage());  // Log details
    Functions.throwError(msg + ".");                     // Error dialog
}
else
{
    // Successful add. Take other actions, as needed.
}