Use this function to update a record with the given parameters if the external ID matches, or create a record if the external ID does not match.

Syntax

Upsert Record (token, username, password, SObject_type, name, site, phone)

Parameters

To know more about token, click here.

Returns

Sample

Upsert Record (ABCDCEF, john@gmail.com, pass@123, Account, XYZ, updated_record, http:// example.com, 1234567890)

• Uses token ABCDCEF to connect to Salesforce with username updated_record and password pass@123, searches for the record with external ID XYZ.
  • If a match is found, updates the matched record of type Account with name john@gmail.com, site http:// example.com and phone number 1234567890.
  • If a match is not found, inserts a record of type Account with name john@gmail.com, site http:// example.com and phone number 1234567890.
    
• Returns Record Upserted Successfully on the updating the record.

To view all the Salesforce functions, click here.