ODBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

ReplyMailManagementConfiguration

Details configuration settings for the reply mail management in an account. This table does not support deletes.

Table-Specific Information

Select

The driver uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

For example, the following (but not only) queries are processed server side: 

SELECT * FROM ReplyMailManagementConfiguration

SELECT * FROM ReplyMailManagementConfiguration WHERE Id = 123

SELECT * FROM ReplyMailManagementConfiguration WHERE Id IN (123, 456)

SELECT * FROM ReplyMailManagementConfiguration WHERE CreatedDate > '2017/01/25'

Insert

You must specify the following fields when inserting to this table: EmailDisplayName and EmailReplyAddress. 

INSERT INTO ReplyMailManagementConfiguration(EmailDisplayName, EmailReplyAddress) VALUES('Test', 'buzzlightyear@mymail.com')

Update

You must set a new value for EmailReplyAddress when executing an update against this table, and also supply its Id. 

UPDATE ReplyMailManagementConfiguration SET EmailReplyAddress='newemailreply@gmail.com' WHERE Id = 123

Columns

Name Type ReadOnly Description
ID [KEY] Int False

Identifier for an object.

Client_ID Int True

The Id of the client.

EmailDisplayName String False

Specifies the From name associated with the From email address as part of reply mail management configuration.

ReplySubdomain String False

Specifies subdomain associated with a reply mail management subdomain.

EmailReplyAddress String False

Specifies forwarding address for inbound emails resulting from a send.

CreatedDate Datetime False

Indicates the date and time of the object's creation.

ModifiedDate Datetime False

Indicates the last time object information was modified.

DNSRedirectComplete Bool False

Specifies whether a reply domain's DNS has been redirected to the Marketing Cloud IP addresses.

DeleteAutoReplies Bool False

Specifies whether auto-replies to a send should be deleted instead of forwarded to the RMM-configured email address.

SupportUnsubscribes Bool False

Indicates whether a reply mail management configuration allows subscribers to unsubscribe.

SupportUnsubKeyword Bool False

Indicates whether a reply mail management configuration supports a unsubscribe keyword.

SupportUnsubscribeKeyword Bool False

Indicates whether a reply mail management configuration supports a unsubscribe keyword.

SupportRemoveKeyword Bool False

Indicates whether a reply mail management configuration supports a remove keyword.

SupportOptOutKeyword Bool False

Indicates whether a reply mail management configuration supports an opt-out keyword.

SupportLeaveKeyword Bool False

Indicates whether a reply mail management configuration supports a leave keyword.

SupportMisspelledKeywords Bool False

Indicates whether a reply mail management configuration supports misspelled keywords.

SendAutoReplies Bool False

Indicates whether automatic replies should be sent as part of a reply mail management configuration.

AutoReplySubject String False

Contains the subject of the email message sent as an automatic reply.

AutoReplyBody String False

Contains the content of the message sent as an automatic reply.

ForwardingAddress String False

Specifies forwarding address for inbound emails resulting from a send.

ConversationLifetimeDays Int False

The number of lifetime days for a conversation.

ConversationLifetimeCycles Int False

The number of lifetime cycles for a conversation.

AnonymousRuleSet_ObjectID String True

System-controlled, read-only text string identifier for object.

AnonymousRuleSet_Name Int True

Name of the object or property.

AnonymousRuleSet_CustomerKey String True

User-supplied unique identifier for an object within an object type.

AnonymousAckTriggeredSend_ObjectID String True

System-controlled, read-only text string identifier for object.

AnonymousAckTriggeredSend_CustomerKey String True

User-supplied unique identifier for an object within an object type.

AnonymousAckTriggeredSend_Name String True

Name of the object or property.

AnonymousAckTriggeredSend_TriggeredSendStatus String True

Represents status of triggered send.

AnonymousForwardTriggeredSend_ObjectID String True

System-controlled, read-only text string identifier for object.

AnonymousForwardTriggeredSend_CustomerKey String True

User-supplied unique identifier for an object within an object type.

AnonymousForwardTriggeredSend_Name String True

Name of the object or property.

AnonymousForwardTriggeredSend_TriggeredSendStatus String True

Represents status of triggered send.

ResponderConversationRuleSet_ObjectID String True

System-controlled, read-only text string identifier for object.

ResponderConversationRuleSet_Name Int True

Name of the object or property.

ResponderConversationRuleSet_CustomerKey String True

User-supplied unique identifier for an object within an object type.

ResponderConversationAckTriggeredSend_ObjectID String True

System-controlled, read-only text string identifier for object.

ResponderConversationAckTriggeredSend_CustomerKey String True

User-supplied unique identifier for an object within an object type.

ResponderConversationAckTriggeredSend_Name String True

Name of the object or property.

ResponderConversationAckTriggeredSend_TriggeredSendStatus String True

Represents status of triggered send.

ResponderConversationForwardTriggeredSend_ObjectID String True

System-controlled, read-only text string identifier for object.

ResponderConversationForwardTriggeredSend_CustomerKey String True

User-supplied unique identifier for an object within an object type.

ResponderConversationForwardTriggeredSend_Name String True

Name of the object or property.

ResponderConversationForwardTriggeredSend_TriggeredSendStatus String True

Represents status of triggered send.

InitiatorConversationRuleSet_ObjectID String True

System-controlled, read-only text string identifier for object.

InitiatorConversationRuleSet_Name Int True

Name of the object or property.

InitiatorConversationRuleSet_CustomerKey String True

User-supplied unique identifier for an object within an object type.

InitiatorConversationAckTriggeredSend_ObjectID String True

System-controlled, read-only text string identifier for object.

InitiatorConversationAckTriggeredSend_CustomerKey String True

User-supplied unique identifier for an object within an object type.

InitiatorConversationAckTriggeredSend_Name String True

Name of the object or property.

InitiatorConversationAckTriggeredSend_TriggeredSendStatus String True

Represents status of triggered send.

InitiatorConversationForwardTriggeredSend_ObjectID String True

System-controlled, read-only text string identifier for object.

InitiatorConversationForwardTriggeredSend_CustomerKey String True

User-supplied unique identifier for an object within an object type.

InitiatorConversationForwardTriggeredSend_Name String True

Name of the object or property.

InitiatorConversationForwardTriggeredSend_TriggeredSendStatus String True

Represents status of triggered send.

ConversationExpirationTriggeredSend_ObjectID String True

System-controlled, read-only text string identifier for object.

ConversationExpirationTriggeredSend_CustomerKey String True

User-supplied unique identifier for an object within an object type.

ConversationExpirationTriggeredSend_Name String True

Name of the object or property.

ConversationExpirationTriggeredSend_TriggeredSendStatus String True

Represents status of triggered send.

MultiUseViolationTriggeredSend_ObjectID String True

System-controlled, read-only text string identifier for object.

MultiUseViolationTriggeredSend_CustomerKey String True

User-supplied unique identifier for an object within an object type.

MultiUseViolationTriggeredSend_Name String True

Name of the object or property.

MultiUseViolationTriggeredSend_TriggeredSendStatus String True

Represents status of triggered send.

InboundAddressIsOneUse Bool False

Specified whether the inbound address is one use.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462