by dev | Apr 21, 2018 | Book
UpsertMSCRMRecord This function retrieves a record from Microsoft Dynamics CRM, using the name and value pairs to filter the results. The results are then sorted using the sort field and order specified. Records are updated with the name and value pairs from the...
by dev | Apr 21, 2018 | Book
Add This function returns the sum of two numbers. Arguments Add(1,2) Ordinal Type Required Description 1 Number True First value 2 Number True Second value Example 1 %%[ var @sum, @num1, @num2 set @num1 = 5 set @num2 = 42 set @sum = Add(@num1, @num2) ]%%...
by dev | Apr 21, 2018 | Book
Overview In addition to the set of personalization strings available for MobileConnect, Marketing Cloud also includes AMPscript functions for using SMS conversations in MobileConnect. SMS conversations enable message chains to be created. In a conversation,...
by dev | Apr 21, 2018 | Book
UpsertDE This function adds or updates the Data Extension row referenced in the column and value arguments. Values updated are specified with column name and value pairs. If no record matches the values specified, a new row is added. This function does not return a...
by dev | Apr 21, 2018 | Book
EncryptSymmetric This function encrypts a string with the specified algorithm and qualifiers. Outputs a Base64 encoded value. Arguments EncryptSymmetric(1,2,3,4,5,6,7,8) Ordinal Type Required Description 1 String True String to encrypt 2 String True Algorithm used to...
by dev | Apr 21, 2018 | Book
Overview The date and time AMPscript functions are used to return, convert and adjust date and time values. For functions with date-input arguments, those arguments must take one of the following forms: Includes a date only Includes both a date and time Includes a...