NSOA.wsapi.upsert(attributes,objects)

Use this function to add or modify data in SuiteProjects Pro based on lookup attributes. The function returns an error if more than 1000 objects are passed in.

You can use an externalid field as a foreign key and add a record without querying first for an internal ID.

See also Making SOAP Calls.

Parameters

• attributes {var} [required] — Array of Attribute objects.

• objects {var} [required] — Array of SuiteProjects Pro Complex Type objects, see NSOA.record.<complex type>( [id] ).

Returns

Array of UpdateResult objects.

Units Limit

40 units

+20 for each additional object passed

For more information, see Scripting Governance.

Since

November 16, 2013

Example

This sample creates a new category in SuiteProjects Pro.

              //Define a category object to create/update
    var category = new NSOA.record.oaCategory();
    category.name = "Updated Category";
    category.externalid = "555";

    // Specify that the lookup is done by external_id and not by (default) internal ID
    var attribute = {
        name  : "lookup",
        value : "externalid"
    };

    // Invoke the upsert call
    var results = NSOA.wsapi.upsert( [attribute], [category] ); 

        

See Code Samples for more examples.