Skill Level: Intermediate
Syntax of the request and response XML for SelectRecipientData
If your database has a key other than Email, you must include all unique key columns with their corresponding name/value pairs.
If your database has no Unique Identifier defined, one or more columns must be specified in order to look up the contact.
Operation <SelectRecipientData> Elements LIST_ID ID of the database to which the contact belongs. If a Contact List is specified instead of a database, the system will determine whether the contact is in the Contact List. If the contact is found, their database columns will be returned. Â The contact email address to look up. Note: If using a regular email key database, a node must exist for the Email column. Â RETURN_CONTACT_LISTS Optional Indicates whether to return all Contact Lists which the
contact belongs to. Valid values are:
Â COLUMN Optional Required if the database has a key other than Email or no Unique Identifier. XML nodes defining the column name
and value used to look up a contact in a database. Ignored
for regular email key databases. Note: Unique key columns
must be part of the submission with column names and
values. Note: If more than one contact is found matching
the lookup columns, the oldest contact will be returned.
Â Child Elements Name Specifies the field name of the unique key for the database. Â Â Value Specifies the field value for the field name of the unique key for the database. Example
Â Â Response <RESULT> Â Â Elements SUCCESS True if successful. Â Email address for the contact. Â Email address for the contact. Note: At the time of this writing, email is included twice in the response. Â RecipientId Internal unique ID for each contact. Â EmailType
Value indicating the preferred email type for the selected contact.
- 0 â HTML
- 1 â Text
- 2 â AOL
Â LastModified Last time the contact record was modified. Â CreatedFrom
Value indicating the way in which Watson Campaign Automation added the selected contact to the system.
- 0 â Imported from a database
- 1 â Manually added
- 2 â Opted in
- 3 â Created from tracking database
Â OptedIn Contactâs optâin date, if applicable. Â OptedOut Contactâs optâout date, if applicable. Â ORGANIZATION_ID Identifies your Watson Campaign Automation Organization. Â CONTACT_LISTS If the RETURN_CONTACT_LISTS is âtrueâ in the request, this parent node will be included in the response. It will contain a child element for each Contact List the contact belongs to. Â Child Elements CONTACT_LIST_ID Id of a Contact List which the contact belongs to. Â COLUMNS XML nodes defining the userâcreated column name and value. Child Elements COLUMN Â Â Â Child Element Name Specifies the field name. Â Â Value Specifies the field value. Example
<LastModified>6/25/04 3:29 PM</LastModified>
<OptedIn>6/25/04 3:29 PM</OptedIn>