Which is a field in a sendable data extension?

Which is a field in a sendable data extension?

Indicates the field within a sendable data extension to use as an address as part of a send. Possible values include SubscriberID, CustomerKey, or EmailAddress. The application uses this field to establish a data relationship between a value specified by theSendableSubscriberFieldproperty and a value within a sendable data extension.

Which is an example of a SQL query?

Here is a query example that pulls data from the complaint data view for the last 6 months and provides SubscriberKey, JobIDs, and Bounce Reasons. Beyond data views, SQL queries can also be customized to solve for a variety of business needs.

When do I need to update my dataextension?

To create or update a DataExtension, and if your account has the data extension retention policies business rule and any data retention fields are populated, you need the Data Extension | Manage Data Extension Retention permission.

Where do I query a shared data extension?

You can query data extensions in the Shared Data Extension folder from the parent account by adding the prefix ent. to the data extension name in the query. Sometimes you want everything.

Where does authentication go in a soap call?

Authentication is inside of the envelope header of the call, not in the Headers section like REST. SOAP has Methods (declared inside of payload/body) as well as Objects that are to be utilized to determine action and result. This should then return a SOAP envelope with the requested fields shown above inside of it.

How can I clear data from a dataextension?

To clear data from a DataExtension using the perform method, you need the Email | Subscribers | Data Extension | Clear Data permission. Also, your AccountType must be E2.0 or BU, or you need the role based access control business rule. If you don’t own the data extension, you can’t clear its data.

What are the data retention fields in dataextension?

Data retention fields are: DataRetentionPeriod, DataRetentionPeriodLength, DataRetentionPeriodUnitOfMeasure, RowBasedRetention, ResetRetentionPeriodOnImport, DeleteAtEndOfRetentionPeriod, and RetainUntil. To clear data from a DataExtension using the perform method, you need the Email | Subscribers | Data Extension | Clear Data permission.

How to get a data extension in Salesforce?

For example, in this case I’m retrieving the First Name and Last name from a Contacts Data Extension based on a couple of criteria (from the Email address and a different Data Extension): Thanks for contributing an answer to Salesforce Stack Exchange!