Below are all AMPscript functions available. Click the name of the AMPscript function to be taken to the overview of the function along with a use case and useable code snippet as an example. AMPscript functions are organized by category: (1) API, (2) Contacts, (3) Content, (4) Data Extension, (5) Date/Time, (6) Encryption, (7) HTTP, (8) Math, (9) Microsoft Dynamics CRM, (10) Salesforce, (11) Sites, (12) Social, (13) String, (14) Utilities.

API

  • AddObjectArrayItem
  • CreateObject
  • InvokeCreate
  • InvokeDelete
  • InvokeExecute
  • InvokePerform
  • InvokeRetrieve
  • InvokeUpdate
  • RaiseError
  • SetObjectProperty

Contacts

  • UpsertContact

Content

  • AttachFile
  • BarCodeURL
  • BeginImpressionRegion
  • BuildOptionList
  • BuildRowSetFromString
  • BuildRowSetFromXML
  • ContentArea
  • ContentAreaByName
  • ContentBlockbyId
  • ContentBlockbyKey
  • ContentBlockbyName
  • ContentImagebyID
  • ContentImagebyKey
  • CreateSmsConversation
  • EndImpressionRegion
  • EndSmsConversation
  • GetPortfolioItem
  • Image
  • _messageContext
  • SetSmsConversationNextKeyword
  • TransformXML
  • TreatAsContent
  • TreatAsContentArea
  • WAT
  • WATP

Data Extension

  • ClaimRow
  • ClaimRowValue
  • DataExtensionRowCount
  • DeleteData
  • DeleteDE
  • ExecuteFilter
  • ExecuteFilterOrderedRows
  • Field
  • InsertData
  • InsertDE
  • Lookup
  • LookupOrderedRows
  • LookupOrderedRowsCS
  • LookupRows
  • LookupRowsCS
  • Row
  • RowCount
  • UpdateData
  • UpdateDE
  • UpsertData
  • UpsertDE

Date Time

  • DateAdd
  • DateDiff
  • DateParse
  • DatePart
  • GetSendTime
  • LocalDateToSystemDate
  • Now
  • SystemDateToLocalDate

Encryption

  • Base64Decode
  • Base64Encode
  • DecryptSymmetric
  • EncryptSymmetric
  • GUID
  • MD5
  • SHA1
  • SHA256

HTTP

  • HTTPGet
  • HTTPPost
  • HTTPPost2
  • HTTPRequestHeader
  • IsCHTMLBrowser
  • RedirectTo
  • URLEncode
  • WrapLongURL

Math

  • Add
  • Divide
  • FormatCurrency
  • FormatNumber
  • Mod
  • Multiply
  • Random
  • Subtract

Microsoft Dynamics CRM

  • AddMscrmListMember
  • CreateMscrmRecord
  • DescribeMscrmEntities
  • DescribeMscrmEntityAttributes
  • RetrieveMscrmRecords
  • RetrieveMscrmRecordsFetchXML
  • SetStateMscrmRecord
  • UpdateMscrmRecords
  • UpsertMscrmRecord

Salesforce

Sites

  • AuthenticatedEmployeeID
  • AuthenticatedEmployeeNotificationAddress
  • AuthenticatedEmployeeUserName
  • AuthenticatedEnterpriseID
  • AuthenticatedMemberID
  • AuthenticatedMemberName
  • CloudPagesURL
  • IsNullDefault
  • LiveContentMicrositeURL
  • MicrositeURL
  • QueryParameter
  • Redirect
  • RequestParameter

Social

  • GetPublishedSocialContent
  • GetSocialPublishURL
  • GetSocialPublishURLByName

String

  • Char
  • Concat
  • Format
  • IndexOf
  • Length
  • Lowercase
  • ProperCase
  • RegExMatch
  • Replace
  • ReplaceList
  • StringToDate
  • StringToHex
  • Substring
  • Trim
  • Uppercase

Utilities