Use this function to update a record 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

Returns

Sample

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

• Uses the token ABCDCEF to connect to the salesforce with username updated_record and password pass@123, searches for the record with external ID XYZ.
  • Updates the record of type manager with name john@gmail.com, site http:// example.com and phone number 1234567890 if a match is found.
  • If a match is not found, inserts a record of type manager 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.