Views:

Description

Creates a record if the record doesn't already exist. Searches for the record using its ID.

Enter the schema name of the entity and then the ID of the record that you want to update. If a record with that ID exists, nothing will happen (i.e. NoOp returned).

If no record with that ID exists, the record will be created. Following the primarykeyid parameter enter the attributes you want to set.

Signature

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

Example

CreateRecordIfNotExistsById('contact',
'323bc2c9-41db-46da-856d-7eb57df8b7a9',
SetAttribute('firstname', 'Bruce'),
SetAttribute('lastname', '
Wayne'),
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

Notes: