UpdateCreateRecord

Description

If the supplied record guid exists then the system will update the record else it will create it.

You enter the name of the entity and then the record guid that you want to update. If a Create occurs the guid of the new record is returned otherwise if an update occurs a NoOp returns.

Signature

UpdateCreateRecord('entityname', 
                   'primarykeyid',
                   SetAttribute('attributename', 'attributevalue' ))

Example

UpdateCreateRecord('contact',
                   [account.primaryaccountid],
                   SetAttribute('firstname', 'Bill'),
                   SetAttribute('lastname', 'gates'),
                   SetAttribute('creditlimit', '5000'),
                   SetAttribute('description', '?'),
                   SetAttribute('parentcustomerid', 
                                'account.450dd379c-ee2f-11db-8314-0800200c777', 
                                'Microsoft'),
                   SetAttributeLookup('preferredsystemuserid', 
                                      'systemuser', 
                                      '670dd379c-ee2f-11db-8314-0800200c888'))

Note 1: Fields of type lookup need SetAttributeLookup('fieldname', 'entityname.recordguid')
Note 2: Fields of type PartyList need SetAttributePartyList('fieldname', 'entityname', 'partyguid' , 'partyguid')