Programmatic Marketing Content

Introduction to Programmatic Marketing Content
AMPscript
AMPscript Syntax Guide
AMPscript Function Reference
API: Add Object Array Item
API: Create Object
API: Invoke Create
API: Invoke Delete
API: Invoke Execute
API: Invoke Perform
API: Invoke Retrieve
API: Invoke Update
API: Raise Error
API: Set Object Property
Contacts: Upsert Contact
Content: Attach File
Content: Barcode URL
Content: Begin Impression Region
Content: Build Option List
Content: Build Row Set From String
Content: Build Row Set From XML
Content: Content Area
Content: Content Area by Name
Content: Content Block by ID
Content: Content Block by Key
Content: Content Block by Name
Content: Content Image by ID
Content: Content Image by Key
Content: Create SMS Conversation
Content: End Impression Region
Content: End SMS Conversation
Content: Get Portfolio Item
Content: Image
Content: Set SMS Conversation Next Keyword
Content: Transform XML
Content: Treat as Content
Content: Treat as Content Area
Content: Wat
Data Extension: Claim Row
Data Extension: Claim Row Value
Data Extension: Data Extension Row Count
Data Extension: Delete Data
Data Extension: Delete DE
Data Extension: Execute Filter
Data Extension: Execute Filter Ordered Rows
Data Extension: Field
Data Extension: Insert Data
Data Extension: Insert DE
Data Extension: Lookup
Data Extension: Lookup Ordered Rows
Data Extension: Lookup Ordered Rows CS
Data Extension: Lookup Rows
Data Extension: Lookup Rows CS
Data Extension: Row
Data Extension: Row Count
Data Extension: Update Data
Data Extension: Update DE
Data Extension: Upsert Data
Data Extension: Upsert DE
Date Time: Date Add
Date Time: Date Diff
Date Time: Date Parse
Date Time: Date Part
Date Time: Format Date
Date Time: Get Send Time
Date Time: Local Date to System Date
Date Time: Now
Date Time: System Date to Local Date
Encryption: Base 64 Decode
Encryption: Base 64 Encode
Encryption: Decrypt Symmetic
Encryption: Encrypt Symmetric
Encryption: GUID
Encryption: MD5
Encryption: SHA1
Encryption: SHA256
Encryption: SHA512
HTTP Get
HTTP Post
HTTP Post 2
HTTP Request Header
HTTP: Is CHTML Browser
HTTP: Redirect To
HTTP: URL Encode
HTTP: Wrap Long URL
Math: Add
Math: Divide
Math: Format Currency
Math: Format Number
Math: Mod
Math: Multiply
Math: Random
Math: Subtract
Microsoft Dynamics CRM: Add MSCRM List Member
Microsoft Dynamics CRM: Create MSCRM Record
Microsoft Dynamics CRM: Describe MSCRM Entities
Microsoft Dynamics CRM: Describe MSCRM Entity Attributes
Microsoft Dynamics CRM: Retrieve MSCRM Records
Microsoft Dynamics CRM: Retrieve MSCRM Records Fetch XML
Microsoft Dynamics CRM: Set State MSCRM Record
Microsoft Dynamics CRM: Update MSCRM Records
Microsoft Dynamics CRM: Upsert MSCRM Record
Salesforce: Create Salesforce Object
Salesforce: Long SFID
Salesforce: Retrieve Salesforce Job Sources
Salesforce: Retrieve Salesforce Objects
Salesforce: Update Single Salesforce Object
Sites: Authenticated Employee ID
Sites: Authenticated Employee Notification Address
Sites: Authenticated Employee Username
Sites: Authenticated Enterprise ID
Sites: Authenticated Member ID
Sites: Authenticated Member Name
Sites: Cloud Pages URL
Sites: Is Null Default
Sites: Live Content Microsite URL
Sites: Microsite URL
Sites: Query Parameters
Sites: Redirect
Sites: Request Parameter
Social: Get Published Social Content
Social: Get Social Publish URL
Social: Get Social Publish URL By Name
String: Char
String: Concat
String: Format
String: Index Of
String: Length
String: Lowercase
String: Propercase
String: Reg Ex Match
String: Replace
String: Replace List
String: String To Date
String: String To Hex
String: Substring
String: Trim
String: Uppercase
Utilities: Attribute Value
Utilities: Domain
Utilities: Empty
Utilities: IIF
Utilities: Is Email Address
Utilities: Is Null
Utilities: Is Phone Number
Utilities: Output
Utilities: Output Line
Utilities: V
AMPscript Examples
Personalization Strings and AMPscript
Get Started with AMPscript
AMPscript Update, Insert, and Delete Calls Processing During Sending
Impression Tracking
AMPscript and the SOAP Web Service API
Guide Template Language
Server-Side JavaScript

LookupRows

Overview

Returns a rowset from a data extension where the field matches the specified value. Specify additional field value pairs as part of an AND clause. This function returns a maximum of 2000 rows. To better control the number or the order of returned rows, use the LookupOrderedRows() function. This limitation enhances script performance.

Syntax

LookupRows(1, 2, 3)

Function Properties
Ordinal Type Description
1 string Required Name of data extension from which to return specified rows
2 string Required Column name used to identify rows to return
3 string Required Value used to match rows to return

Usage

LookupRows('ZipCode','City',HomeCity)

Returns the ZipCode rows where the City field matches for HomeCity value.

Last Updated: Jun 8, 2021