Overview

Skill Level: Any

Prerequisites

This interface imports a .zip containing the XML file defining a Dynamic Content Ruleset and any associated HTML or images. Imported files are loaded from the user’s FTP upload directory.

If the user does not specify a MAILING_ID or RULESET_ID, Engage creates a new Ruleset in the user’s Private folder of the Asset Library. If the user does specify a RULESET_ID, Engage replaces the Ruleset.

Note: A ruleset may contain no more than 1,000 rules.

Step-by-step

  1. Syntax of the request and response SOAP for ImportDCRuleset

    Operation <ImportDCRuleset>    
    Elements FILE_NAME The name of the .zip file located in the user’s FTP upload directory.  
      LIST_ID The ID of the associated database.  
      MAILING_ID Optional Associates a Ruleset directly to a mailing. This will NOT place a
    copy of the Ruleset in the Asset Library.
      RULESET_ID Optional Specifies an existing Ruleset to use in place of imported content.
    Example <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/”
    xmlns:ses=”SilverpopApi:EngageService.SessionHeader”
    xmlns:user=”SilverpopApi:EngageService.MailManagement.UserActions”>
    <soapenv:Header>
    <ses:sessionHeader>
    <ses:sessionid>06395F3FA6D07365CBA5D01AF14F3F56</ses:sessionid>
    </ses:sessionHeader>
    </soapenv:Header>
    <soapenv:Body>
    <user:ImportDCRuleset>
    <user:FILE_NAME>Import_Ruleset.zip</user:FILE_NAME>
    <user:MAILING_ID>1866986</user:MAILING_ID>
    <user:LIST_ID>24872</user:LIST_ID>
    </user:ImportDCRuleset>
    </soapenv:Body>
    </soapenv:Envelope>    		    
    Response <RESULT>    
    Elements SUCCESS

    “True” indicates successful Data Job submission.

    “False” indicates an error occurred in which the error code displayed with a
    message reporting the issue.

    		  
      JOB_ID Contains the Data Job ID for the import.  
    Example <envelope:Envelope xmlns=”SilverpopApi:EngageService.MailManagement.UserActions”
    xmlns:envelope=”http://schemas.xmlsoap.org/soap/envelope/”>
    <envelope:Header/>
    <envelope:Body>
    <RESULT>
    <SUCCESS>TRUE</SUCCESS>
    <JOB_ID>503632</JOB_ID>
    </RESULT>
    </envelope:Body>
    </envelope:Envelope>    		    

  2. The following table describes the .zip file format

    RULESET            
    Child
    Element    		 RULESET_NAME Optional The name of the DC Ruleset if creating a new Ruleset using
    Import.    		      
      CONTENT_AREAS The content area defines default content used when a user falls outside of all
    existing rule criteria.    		        
      Child Element CONTENT_AREA Optional Included if content being defined. It is possible to create a
    Ruleset and associated rules in the Asset Library without
    related content areas.    		    
        Attribute name The name of the Content Area being defined    
          type The type of Content Area. The following values are valid:
    ‘Body‐HTML’
    ‘Body‐Text’
    ‘Body‐AOL’
    ‘Subject’
    ‘From’
    ‘From‐Name’    		    
        Child Element DEFAULT_CONTENT Content that displays if there is no matching rule. Must be set
    to CDATA for HTML content.    		    
          Attribute name The name of the Content Block being
    defined.    		  
    Child
    Element    		 RULES          
      Child Element RULE        
        Child Element RULE_NAME The name of the Dynamic Content Rule.    
          PRIORITY The priority of the rule vs. other rules. Number must be
    unique. Priority is determined in ascending order with ‘1’
    being the highest.    		    
          CRITERIA      
          Child Element EXPRESSION    
            Child Element AND_OR Used to denote ‘AND’
    or ‘OR’ when defining
    relationships between
    expressions.
              LEFT_PARENS Used to denote a left
    parenthesis character
    when defining
    relationships between
    expressions.
              TYPE The type of
    expression. Valid
    values are:
    ‘NE’ – Numeric
    ‘DE’ – Date/Time
    ‘TE’ – Text
              COLUMN_NAME The name of the
    database field being
    evaluated.
              OPERATORS The operator used for
    comparison. Valid
    values are:
    ‘!=’
    ‘<‘
    ‘>’
    ‘=’
    ‘IS NOT null’
    ‘IS null’
    ‘LIKE’
    ‘NOT like’
    ‘IN’
    ‘NOT in’
    ‘BETWEEN’
              VALUES The value being
    compared to the
    Watson Campaign Automation database
    field. Can be text,
    numeric, or date value
    OR a list of values or
    the name of a
    Column. If specifying
    a Column, surround
    with square brackets,
    for example, [My Text
    Column]. If specifying
    a list of values, use |
    (pipe character) to
    separate values in the
    list.
              RIGHT_PARENS Used to denote a right
    parenthesis character
    when defining
    relationships between
    expressions.
          CONTENTS      
          Child Element CONTENT Optional This is the content that
    will show for contacts
    matching the criteria of this rule. For HTML
    content, this must be
    CDATA.
            Attribute content_area The previously defined
    Content Area where the content will be placed in
    the mailing body.
              name The name of the Content Block being
    defined.
    Example <RULESET>
    <RULESET_NAME>Promo By Gender</RULESET_NAME>
    <CONTENT_AREAS>
    <CONTENT_AREA name=”dc_mailing_subject” type=”Subject”>
    <DEFAULT_CONTENT name=”Default.dc_mailing_subject”><![CDATA[All
    clothing on sale this week.]]></DEFAULT_CONTENT>
    </CONTENT_AREA>
    <CONTENT_AREA name=”dc_promo” type=”Body‐HTML”>
    <DEFAULT_CONTENT name=”Default.dc_promo”><![CDATA[10% Off
    Everything]]></DEFAULT_CONTENT>
    </CONTENT_AREA>
    </CONTENT_AREAS>
    <RULES>
    <RULE>
    <RULE_NAME>MalePromotion</RULE_NAME>
    <PRIORITY>1</PRIORITY>
    <CRITERIA>
    <EXPRESSION>
    <AND_OR/>
    <LEFT_PARENS>(</LEFT_PARENS>
    <TYPE>TE</TYPE>
    <COLUMN_NAME>Gender</COLUMN_NAME>
    <OPERATORS><![CDATA[=]]></OPERATORS>
    <VALUES><![CDATA[M]]></VALUES>
    <RIGHT_PARENS>)</RIGHT_PARENS>
    </EXPRESSION>
    <EXPRESSION>
    <AND_OR>AND</AND_OR>
    <LEFT_PARENS>(</LEFT_PARENS>
    <TYPE>NE</TYPE>
    <COLUMN_NAME>Salary</COLUMN_NAME>
    <OPERATORS><![CDATA[>]]></OPERATORS>
    <VALUES><![CDATA[90000]]></VALUES>
    <RIGHT_PARENS>)</RIGHT_PARENS>
    </EXPRESSION>
    </CRITERIA>
    <CONTENTS>
    <CONTENT name=”male_subject”
    content_area=”dc_mailing_subject”><![CDATA[Men’s clothing on sale this week.]]></CONTENT>
    <CONTENT name=”male_promo”
    content_area=”dc_promo”><![CDATA[20% Off All Men’s Clothing]]></CONTENT>
    </CONTENTS>
    </RULE>
    <RULE>
    <RULE_NAME>Female Promotion</RULE_NAME>
    <PRIORITY>2</PRIORITY>
    <CRITERIA>
    <EXPRESSION>
    <AND_OR/>
    <LEFT_PARENS>(</LEFT_PARENS>
    <TYPE>TE</TYPE>
    <COLUMN_NAME>Gender</COLUMN_NAME>
    <OPERATORS><![CDATA[=]]></OPERATORS>
    <VALUES><![CDATA[F]]></VALUES>
    <RIGHT_PARENS>)</RIGHT_PARENS>
    </EXPRESSION>
    <EXPRESSION>
    <AND_OR>AND</AND_OR>
    <LEFT_PARENS>(</LEFT_PARENS>
    <TYPE>NE</TYPE>
    <COLUMN_NAME>Salary</COLUMN_NAME>
    <OPERATORS><![CDATA[>]]></OPERATORS>
    <VALUES><![CDATA[90000]]></VALUES>
    <RIGHT_PARENS>)</RIGHT_PARENS>
    </EXPRESSION>
    </CRITERIA>
    <CONTENTS>
    <CONTENT name=”female_promo”
    content_area=”dc_promo”><![CDATA[20% Off All Women’s Clothing]]></CONTENT>
    <CONTENT name=”female_subject”
    content_area=”dc_mailing_subject”><![CDATA[Women’s clothing on sale this week.]]></CONTENT>
    </CONTENTS>
    </RULE>
    </RULES>
    </RULESET>    		          

Join The Discussion

Your email address will not be published. Required fields are marked *