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
- CreateSalesforceObject
- LongSFID
- RetrieveSalesforceJobSources
- RetrieveSalesforceObjects
- UpdateSingleSalesforceObject
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