<dataitem version="2">
  <m project_type="project" version="9.4.7.2991">
    <l k="annotations">
      <m annotation_id="12" section_id="0" type="text">
        <m k="layout" alignment="TopLeft" bold="0" color="-16777216" face_name="Consolas" font_size="18" group_id="0" height="31.1488" italic="1" last_modified="1703002503282" layer="very_back" rotation_angle="0" text="Send" width="69.2992" wrapping="0" x="328" y="0">
          <m k="fill_properties" back_color="-16777216" fore_color="-1" hatch="0" transparent="0"/>
          <m k="line_properties" color="-16777216" style="Solid" transparent="0" width="1"/>
        </m>
      </m>
    </l>
    <l k="connections">
      <m connection_id="15" consumer_id="3" consumer_kind="Input" consumer_order="0" producer_id="2" producer_kind="root" producer_order="0">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="16" consumer_id="4" consumer_kind="Input" consumer_order="0" producer_id="2" producer_kind="events" producer_order="0">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="17" consumer_id="5" consumer_kind="Input" consumer_order="0" producer_id="2" producer_kind="events" producer_order="1">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="18" consumer_id="6" consumer_kind="Input" consumer_order="0" producer_id="5" producer_kind="Output" producer_order="0">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="19" consumer_id="7" consumer_kind="Input" consumer_order="0" producer_id="6" producer_kind="Output" producer_order="0">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="30" consumer_id="22" consumer_kind="Input" consumer_order="0" producer_id="6" producer_kind="Output" producer_order="1">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="25" consumer_id="24" consumer_kind="Input" consumer_order="0" producer_id="22" producer_kind="Output" producer_order="0">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="27" consumer_id="26" consumer_kind="Input" consumer_order="0" producer_id="22" producer_kind="Output" producer_order="1">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="29" consumer_id="28" consumer_kind="Input" consumer_order="0" producer_id="26" producer_kind="Output" producer_order="0">
        <m k="layout" group_id="0"/>
      </m>
      <m connection_id="32" consumer_id="31" consumer_kind="Input" consumer_order="0" producer_id="26" producer_kind="Output" producer_order="1">
        <m k="layout" group_id="0"/>
      </m>
    </l>
    
    <b k="icon"></b>
    <m k="layout" orientation="VERT" wire_mode="RoundedElbow"/>
    
    
    
    <l k="process_nodes">
      <m disabled="N" name="JSONInput3" process_node_id="2" section_id="0" type="JSONInput">
        <m k="config" conversion_errors="warn" data_file="file:///C:/Temp/DM/FLD/Campaign And Response Event Braze/braze_event_send.json" disabled="0" enableTriggerInput="0" enableTriggerOutput="0" error_report="0" extra_field_errors="ignore" flatten_value_arrays="0" include_input_fields="0" input_field="" input_from="file" last_modified="1702675575197" message_viewer="1" multi_doc_mode="none" name="JSONInput3" notes="" null_field_errors="ignore" parsing_errors="abort" record_limit="0" sample="" schema_name="" truncation_errors="warn" use_record_limit="0" use_schema="0" version="9.4.7.2991">
          <m k="filename_output" column_name="FILENAME" column_size="255" full_path="0" output_filename="0" uri_path="1"/>
          <l k="records">
            <m kind="root" path="/">
              <l k="fields">
                <m name="root_ID" path="#">
                  <m k="datatype" signed="Y" size="4" type="Integer"/>
                </m>
                <m>
                  <m k="datatype" size="64" type="Unicode"/>
                </m>
              </l>
            </m>
            <m kind="events" path="/events/[]">
              <l k="fields">
                <m name="events_ID" path="#">
                  <m k="datatype" signed="Y" size="4" type="Integer"/>
                </m>
                <m name="root_ID" path="##">
                  <m k="datatype" signed="Y" size="4" type="Integer"/>
                </m>
                <m name="event_type" path="event_type">
                  <m k="datatype" size="32" type="Unicode"/>
                </m>
                <m name="id" path="id">
                  <m k="datatype" size="36" type="Unicode"/>
                </m>
                <m name="properties_campaign_id" path="properties/campaign_id">
                  <m k="datatype" size="36" type="Unicode"/>
                </m>
                <m name="properties_campaign_name" path="properties/campaign_name">
                  <m k="datatype" size="32" type="Unicode"/>
                </m>
                <m name="properties_dispatch_id" path="properties/dispatch_id">
                  <m k="datatype" size="32" type="Unicode"/>
                </m>
                <m name="properties_email_address" path="properties/email_address">
                  <m k="datatype" size="35" type="Unicode"/>
                </m>
                <m name="properties_ip_pool" path="properties/ip_pool">
                  <m k="datatype" size="32" type="Unicode"/>
                </m>
                <m name="properties_message_extras" path="properties/message_extras">
                  <m k="datatype" size="32" type="Unicode"/>
                </m>
                <m name="properties_message_variation_id" path="properties/message_variation_id">
                  <m k="datatype" size="36" type="Unicode"/>
                </m>
                <m name="properties_message_variation_name" path="properties/message_variation_name">
                  <m k="datatype" size="32" type="Unicode"/>
                </m>
                <m name="time" path="time">
                  <m k="datatype" signed="Y" size="4" type="Integer"/>
                </m>
                <m name="user_external_user_id" path="user/external_user_id">
                  <m k="datatype" signed="Y" size="4" type="Integer"/>
                </m>
                <m name="user_user_id" path="user/user_id">
                  <m k="datatype" size="32" type="Unicode"/>
                </m>
              </l>
            </m>
          </l>
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1703002449033" orientation="VERT" width="70" x="323" y="40"/>
      </m>
      <m disabled="N" name="DataViewer15" process_node_id="3" section_id="0" type="DataViewer">
        <m k="config" name="DataViewer15" notes="" RECORD_LIMIT="0" USE_RECORD_LIMIT="0" version="9.4.7.2991">
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1703002449033" orientation="VERT" width="70" x="272" y="182"/>
      </m>
      <m disabled="N" name="DataViewer16" process_node_id="4" section_id="0" type="DataViewer">
        <m k="config" name="DataViewer16" notes="" RECORD_LIMIT="0" USE_RECORD_LIMIT="0" version="9.4.7.2991">
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1703002449033" orientation="VERT" width="70" x="365" y="187"/>
      </m>
      <m disabled="N" name="Select3" process_node_id="5" section_id="0" type="Select">
        <m k="config" disabled="0" enableTriggerInput="0" enableTriggerOutput="0" last_modified="1704923917926" match_counts="0" name="Select3" notes="" SELECT_UNSPECIFIED="1" version="9.4.7.2991">
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
          <l k="select_fields">
            <m input_field="events_ID" input_source="0" select="0"/>
            <m input_field="root_ID" input_source="0" select="0"/>
            <m input_field="event_type" input_source="0" select="1"/>
            <m input_field="id" input_source="0" output_field="client_campaign_event_id" select="1"/>
            <m input_field="properties_campaign_id" input_source="0" output_field="campaign_code" select="1"/>
            <m input_field="properties_campaign_name" input_source="0" output_field="campaign_name" select="1"/>
            <m input_field="properties_dispatch_id" input_source="0" select="0"/>
            <m input_field="properties_email_address" input_source="0" output_field="email_address" select="1"/>
            <m input_field="properties_ip_pool" input_source="0" select="0"/>
            <m input_field="properties_message_extras" input_source="0" select="1"/>
            <m input_field="properties_message_variation_id" input_source="0" output_field="cell_code" select="1"/>
            <m input_field="properties_message_variation_name" input_source="0" output_field="cell_name" select="1"/>
            <m input_field="time" input_source="0" output_field="time_epoch" select="1"/>
            <m input_field="user_external_user_id" input_source="0" select="1"/>
            <m input_field="user_user_id" input_source="0" output_field="" select="1"/>
          </l>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1703002449033" orientation="VERT" width="70" x="454" y="187"/>
      </m>
      <m disabled="N" name="Calculate3" process_node_id="6" section_id="0" type="Calculate">
        <m k="config" disabled="0" enableTriggerInput="0" enableTriggerOutput="0" eval_cache_size="64" last_modified="1706912590178" name="Calculate3" notes="" override_eval_cache_size="0" version="9.4.7.2991">
          <l k="assignments">
            <m enabled="1" expression="&quot;Braze Sample&quot;" field="sor_name">
              <m k="datatype" size="64" type="Unicode"/>
            </m>
            <m enabled="1" expression="&quot;Braze_&quot; + user_user_id" field="source_party_profile_id">
              <m k="datatype" size="64" type="Unicode"/>
            </m>
            <m enabled="1" expression="&quot;email&quot;" field="channel_code">
              <m k="datatype" size="64" type="Unicode"/>
            </m>
            <m enabled="1" field="campaign_event_datetime">
              <m k="datatype" flat_options="" format="YYYY-MM-DD HH:mm:ss" scan="" signed="Y" size="4" type="datetime"/>
              <v k="expression">UnixEpochMillisToDateTime( time_epoch*1000  , &apos;Etc/UTC&apos; )&#13;&#10;&#13;&#10;</v>
            </m>
            <m enabled="1" expression="user_external_user_id + &apos;_&apos; + email_address  + &apos;_&apos; + user_external_user_id" field="audience_id">
              <m k="datatype" flat_options="" format="" scan="" size="300" type="unicode"/>
            </m>
          </l>
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1703002449033" orientation="VERT" width="70" x="454" y="336"/>
      </m>
      <m disabled="N" name="DataViewer17" process_node_id="7" section_id="0" type="DataViewer">
        <m k="config" name="DataViewer17" notes="" RECORD_LIMIT="0" USE_RECORD_LIMIT="0" version="9.4.7.2991">
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1706912714897" orientation="VERT" width="70" x="375" y="479"/>
      </m>
      <m disabled="N" name="Select6" process_node_id="22" section_id="0" type="Select">
        <m k="config" disabled="0" enableTriggerInput="0" enableTriggerOutput="0" last_modified="1706914066425" match_counts="0" name="Select6" notes="" SELECT_UNSPECIFIED="1" version="9.4.7.2991">
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
          <l k="select_fields">
            <m input_field="event_type" input_source="0" select="0"/>
            <m input_field="client_campaign_event_id" input_source="0" select="1"/>
            <m input_field="campaign_code" input_source="0" select="1"/>
            <m input_field="campaign_name" input_source="0" select="1"/>
            <m input_field="email_address" input_source="0" select="1"/>
            <m input_field="properties_message_extras" input_source="0" select="0"/>
            <m input_field="cell_code" input_source="0" select="1"/>
            <m input_field="cell_name" input_source="0" select="1"/>
            <m input_field="time_epoch" input_source="0" select="0"/>
            <m input_field="user_external_user_id" input_source="0" select="0"/>
            <m input_field="user_user_id" input_source="0" output_field="" select="0"/>
            <m input_field="sor_name" input_source="0" select="1"/>
            <m input_field="source_party_profile_id" input_source="0" select="0"/>
            <m input_field="channel_code" input_source="0" select="1"/>
            <m input_field="campaign_event_datetime" input_source="0" select="1"/>
            <m input_field="audience_id" input_source="0" select="1"/>
          </l>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1706912714897" orientation="VERT" width="70" x="531.9456" y="479"/>
      </m>
      <m disabled="N" name="DataViewer" process_node_id="24" section_id="0" type="DataViewer">
        <m k="config" name="DataViewer" notes="" RECORD_LIMIT="0" USE_RECORD_LIMIT="0" version="9.4.7.2991">
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1706912722482" orientation="VERT" width="70" x="445" y="657.10592"/>
      </m>
      <m disabled="N" name="Reorder" process_node_id="26" section_id="0" type="Reorder">
        <m k="config" disabled="0" enableTriggerInput="0" enableTriggerOutput="0" last_modified="1706912775250" name="Reorder" notes="" version="9.4.7.2991">
          <l k="FIELDS" v="sor_name|client_campaign_event_id|campaign_event_datetime|campaign_code|campaign_name|cell_code|cell_name|channel_code|audience_id|email_address|*"/>
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1706912720950" orientation="VERT" width="70" x="601.9456" y="662.10592"/>
      </m>
      <m disabled="N" name="DataViewer1" process_node_id="28" section_id="0" type="DataViewer">
        <m k="config" name="DataViewer1" notes="" RECORD_LIMIT="0" USE_RECORD_LIMIT="0" version="9.4.7.2991">
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" last_modified="1706912727022" orientation="VERT" width="70" x="601.9456" y="800"/>
      </m>
      <m disabled="N" name="CsvOutput" process_node_id="31" section_id="0" type="CsvOutput">
        <m k="config" append_existing="0" code_page="8859-1" compression_type="NONE" DATA_FILE="file:///C:/Temp/DM/FLD/Campaign And Response Event Braze Converted/Braze_Campaign_Event_Converted.csv" dfs_block_size_mb="64" dfs_replication="3" disabled="0" enableTriggerInput="0" enableTriggerOutput="0" EOL_KIND="CRLF" FIELD_NAME_HEADER="1" last_modified="1706913792082" MULTI_FILE_HEADER="0" name="CsvOutput" notes="" open_file_time="DEFAULT" output_bom="0" output_file_as_folder="0" override_dfs_settings="0" QUOTE="&quot;" QUOTE_EMPTY="0" QUOTE_RULE="AUTOMATIC" separator_code="0" separator_string="," separator_type="string" split_count="1000000" SPLIT_FIELD="" SPLIT_FILE="NONE" SPLIT_SIZE="1024" SUPPRESS_SPLIT_FIELD="0" version="9.4.7.2991" write_empty_file="1">
          <m k="report_options" errors_as_warnings="1" priority_type="NORMAL" priority_value="0" realtime_init="0" realtime_noinit="0" summary="1" warnings="1"/>
        </m>
        <m k="layout" group_id="0" height="70" orientation="VERT" width="70" x="709.8544" y="803.14912"/>
      </m>
    </l>
    
    
  </m>
</dataitem>