Views:

Description

Updates a record if the record exists. If it doesn't exist, the record will be created instead. Searches for the record using an ID.

Enter the schema name of the entity and the ID of the record that you want to update. If a record with the ID doesn't exist, a new record is created and the ID is returned.

If a record with that ID exists, the record will be updated and NoOp is returned. Following the primarykeyid parameter enter the attributes you want to set. 

Signature

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

Example

UpdateCreateRecordById('contact',
                       'db94a6ee-592d-4a0c-9d7f-b8d0ecd5395a',
                        SetAttribute('creditlimit', '5000'),
                        SetAttribute('description', '?'),
                        SetAttributeCustomer('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')

Parameters

Name Type Description Required
fromdate xxxx xxxx xxxx
todate xxxx xxxx xxxx
interval xxxx xxxx xxxx