Harry_Rashid

Thanks Sanford, I was thinking that might be the case - any chance you can help update the code to achieve this? ... View more

As you can see the from the eventid: 2862094 so the date should be  17 February 2021 3:00 PM   ... View more

  That did work but the wrong date came up:   19 April 2021 03:00 PM for that eventid number it should be   17 February 2021 3:00 PM   See screen grab which shows what I am trying to do. Latest code: ## get the size of the list of Custom object ## remove one from the size of the list to reference the right object in the array (arrays start at zero, not 1) #set( $lastIndex = $math.sub($listlength,1) ) ## convert the Service Start Date string to a date #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd hh:mm", "userout" : "dd MMMM yyyy hh:mm a" }, "timezones" : { "userin" : "America/Chicago", "userout" : "Europe/London" }, "locale" : $date.getLocale() } ) #set( $eventdatetimelike = $oN24Attendee_cList.get($lastIndex).eventdatetime ) #set( $eventdatetime = $convert.parseDate( $eventdatetimelike, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) ## convert the date to a different format #set( $eventdatetime_formatted = $date.format( $dateOptions.formats.userout, $eventdatetime, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) #foreach( $event in $oN24Attendee_cList ) #if( $event.eventid.equals(2862094) ) $eventdatetime_formatted #end #end   ... View more

Output for ${oN24Attendee_cList} [{email=cstanton@xxxx.com, eventid=2923321, eventuserid=396136339, personid=85610818, createdAt=2020-12-14 12:14:30, updatedAt=2020-12-16 10:24:27, marketoGUID=6e1d4db5-f994-402f-8f8c-226e5df5fb1d, answeredsurveys=1, archiveminutes=0, askedquestions=1, attendedarchive=N, attendedlive=Y, engagementscore=1.28, eventtitle=Dev Testing - Marketo Integration Webinar: Live Video and Audio with Screen Share, liveminutes=0, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/2923321/8E5C6E8A24121312C6E9ECEEDC0797A0, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=null}, {email=cstanton@xxxx.com, eventid=2971146, eventuserid=403064471, personid=85610818, createdAt=2021-01-15 10:59:18, updatedAt=2021-01-15 13:02:15, marketoGUID=eca41fd8-ce1b-40ad-878f-4bc7125bb57a, answeredsurveys=0, archiveminutes=0, askedquestions=0, attendedarchive=N, attendedlive=Y, engagementscore=0.9, eventtitle=Dev Testing - Marketo Integration Webinar: Live Video and Audio with Screen Share - 5, liveminutes=12, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/2971146/D8337458BB173CD29D78A2207CEA83ED, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=null, eventdatetime=null}, {email=cstanton@xxxx.com, eventid=2862094, eventuserid=412031846, personid=85610818, createdAt=2021-02-11 10:17:22, updatedAt=2021-02-11 10:17:22, marketoGUID=5defefde-ba8a-44e1-a441-56870c46eb9a, answeredsurveys=null, archiveminutes=null, askedquestions=null, attendedarchive=null, attendedlive=null, engagementscore=null, eventtitle=How Will Industry 4.0 and IIoT Change Manufacturing?, liveminutes=null, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/2862094/E6DF1C914D7E0531E26C4F20D1CFCBAB, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=2021-02-17 09:00:00}, {email=cstanton@xxxx.com, eventid=3009982, eventuserid=412753872, personid=85610818, createdAt=2021-02-15 09:00:38, updatedAt=2021-02-15 09:00:38, marketoGUID=f006766f-6df6-48f6-941d-99d38b431cdc, answeredsurveys=null, archiveminutes=null, askedquestions=null, attendedarchive=null, attendedlive=null, engagementscore=null, eventtitle=Thunderboard Workshop: Industrial-Grade TinyML Applications with Silicon Labs and Edge Impulse!, liveminutes=null, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/3009982/25A49F43B8E20571B91468811F6A85F9, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=2021-02-25 11:00:00}, {email=cstanton@xxxx.com, eventid=2989768, eventuserid=412753739, personid=85610818, createdAt=2021-02-15 09:00:38, updatedAt=2021-02-15 09:00:38, marketoGUID=5bffb342-c397-4cfd-ab75-ef155009b489, answeredsurveys=null, archiveminutes=null, askedquestions=null, attendedarchive=null, attendedlive=null, engagementscore=null, eventtitle=LPDDR4 Trends and Tech (Register to Win a Raspberry Pi 4!), liveminutes=null, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/2989768/D3EE09A3DDCF112CBAC4E98F98302286, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=2021-02-24 11:00:00}, {email=cstanton@xxxx.com, eventid=3053359, eventuserid=421641290, personid=85610818, createdAt=2021-03-15 12:21:51, updatedAt=2021-03-15 12:21:51, marketoGUID=f41528de-8591-4087-b02c-78e6f3f2d20c, answeredsurveys=null, archiveminutes=null, askedquestions=null, attendedarchive=null, attendedlive=null, engagementscore=null, eventtitle=IoT MythBusters: Tomorrow's Future Today, liveminutes=null, userprofileurl=null, country=null, eventurl=https://event.on24.com/wcc/r/3053359/17BCF76DEE585B7D8BEADC685766177E, firstname=Christopher, lastname=Stanton, mktpermissions=null, partner_ref=element14, eventdatetime=2021-04-19 09:00:00}] $eventdatetime_formatted ... View more

I think its to do with the IF loop, seems to go blank when adding that within the FOR loop. ... View more

This is the field I am trying use to filter correct data into the email, what needs to show after data format complete: this is what is showing at moment, but is from another record in custom object for that customer 19 April 2021 03:00 PM fields that are used: ${oN24Attendee_cList.get(0).eventdatetime} ${oN24Attendee_cList.get(0).eventid} ${oN24Attendee_cList.get(0).eventtitle} ... View more

Hi Sanford, Thanks for the help but when I add in the formatted field $eventdatetime_formatted within that loop nothing shows up(only blank space). The field I am targeting is eventid ${oN24Attendee_cList.get(0).eventid}.   I used your code but it still shows blank. ... View more

Is there an example I can follow or maybe help update the above code? ... View more

Sorry Sanford, maybe I not explained correctly - the code already splits them to individual lines. I want to amend the code so I can separate each line where they maybe a comma:    Say this is one line: Part - 7984219, P2220 Oscilloscope Probe, Passive, 300 V Qty. - 11   Is it possible to use comma delimiter to spilt the above line? ie field 1 will only show "Part - 7984219" field 2 "P2220 Oscilloscope Probe, Passive, 300 V" and field 3 "Qty. - 11"   Thanks, ... View more

Hi Sanford, Thanks that did work but is there a way to split field $lead.First_5_Lines_in_Basket__c into 3 separate fields i.e. field 1, field 2 and field 3 which will allow me to place anywhere in an HTML table?   Something like below for each field   Field 1 = Part - 7984219, Field 2 = P2220 Oscilloscope Probe, Passive, 300 V Field 3 = Qty. - 11   At moment it pulls in as below:   Part - 7984219, P2220 Oscilloscope Probe, Passive, 300 V Qty. - 11   Thanks ... View more

Thanks Sanford, that has helped. ... View more

Hi Sanford, This is what conversant has come back to me with -  The main purpose of email tagging is to help conversant identify Farnell customers and be able to reach (Display ads) them online within different devices. The reason for SHA256 is because the customer file we receive from your company is hashed out with SHA256. Having SHA256 on the email tagging, we can then map the hashed email address to a User in conversant since those are in the customer file as well. Also, just to clarify, we don’t reverse the hashes to its normal email address as those become PII information. Not sure what to make of this. ... View more

I'm lost in all this process, not sure which way to go. Do you have example how to use Unique codes or will best option be coding some velocity using Base64. Thanks ... View more

Hi Sanford, Not sure answer to on any of those, I was told that the email address needs to encrypted as it is personal data, below is what they mentioned -  Yes, encryption is required as that is personal data and we would want to make sure CNVR does not ingest those due to legal reasons. Hope you still can help. Thanks again. ... View more

Thanks Tony! but not sure I have the knowledge to this. ... View more

Hi Sanford, it will not be one time load - all customers in our database will be affected at some point. Basically we are working with Conversant(part of Commission Junction), they have provided those parameters which will allow them to track our customer behaviour but we need the email address encrypted. We add the following to our email head: Email Tag Code: <img src="http://login.dotomi.com/ucm/UCMController?dtm_com=2&dtm_cid=61538&dtm_cmagic=a0ad3c&dtm_fid=<Form ID>&dtm_format=6&cli_promo_id=99& dtm_email_hash={{lead.Email Address}} & dtm_user_id={{lead.ID}} & dtmc_drop_id={{program.id}} " width="1" height="1" border="0"> <!-- End Conversant Tag --> and links will have the following parameter: dtm_email_hash parameter ( dtm_email_hash={{lead.Email Address}} ) should be encrypted using SHA256 hashing as that is personal information...which will look something as follows: https://www.domain.com?dtm_email_hash={{hashed_lead.Email}} If you can help with the coding, would be gratefully appreciated  - as you said using base64 now. Thanks for all your help!  ... View more

Sorry, we are targeting existing LEADS within Marketo and was told these email addresses will not change for now. ... View more

The leads are existing Leads we send these emails to, so email address will never change and no new is being created. Sanford that would be great help if you could create the SHA-256 code  I am sure it will come in handy for a lot of of others using Marketo. Trying to have this up and running within 5 to 7 days, is that duable? Thanks for all your help.  ... View more

Sorry, will the link still be: https://mydomain.com/dtm_email_hash={{lead.Email Address}}, Plus why do we need the Data Value Changes in smart flow? Not sure how I would test it as this makes it triggered and cannot Run Once ... View more

Thanks Jay! Will try this, hopefully it will do the job for me. Quick one, the endpoint.php in your screen grab is that the file with the php code you provided me? Thanks again! ... View more

Hi Jay, Thanks for that, not sure how to go about with PHP with Marketo, new to this. Will it be possible to give some more guidance? Thanks! ... View more

Cool, is this the code? https://nation.marketo.com/community/product_and_support/blog/2019/10/13/base64-ing-a-string-in-velocity-without-using-reflection  I'll see if I can manage to do something. ... View more

Thanks again Any chance you can provide an example or velocity code I can look at to build this? ... View more

Thanks Sanford! Is there any webhook-compatible service you know of? Would help me look into it a little more. ... View more

# set ( $currentURLNoProto = $co_record . URL_1 ) # foreach ( $link in [ 1 . . 3 ] ) # evaluate ( "${esc.h}set( ${esc.d}URL_${foreach.parent.count}_${foreach.count} = ${esc.d}currentURLNoProto )" ) #end #set($daysRemaining = $math.abs($daysRemaining)) ##set($co_record.URL_1 = $DynamicCustomObjectList.URL_1) ##set($co_record.URL_2 = $DynamicCustomObjectList.URL_2) ##set($co_record.URL_3 = $DynamicCustomObjectList.URL_3) ##set($co_record.URL_4 = $DynamicCustomObjectList.URL_4) ##set($co_record.URL_5 = $DynamicCustomObjectList.URL_5) ##set($co_record.URL_6 = $DynamicCustomObjectList.URL_6) #if($convert.toInteger($daysRemaining) < 5 && $co_record.SendID == "Pattern Breakers Engineer") <table id="bodyContent" class="innertable2" align="center" width="600" cellpadding="0" cellspacing="0" style="background-color:#ffffff;"> <tr> <td valign="top"><table width="100%" style="font-size: 3px;"> <tbody> <tr> <td> </td> </tr> </tbody> </table></td> <td rowspan="6"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="2" height="10" class="spacer"/></td> <td rowspan="6" style="background-color:#e4e4e4;"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="4" height="1"/></td> <td rowspan="6"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="2" height="10" class="spacer"/></td> <td valign="top"><table width="100%" style="font-size: 3px;"> <tbody> <tr> <td> </td> </tr> </tbody> </table></td> </tr> <tr> <td valign="top"><table width="289" border="0" cellspacing="5" cellpadding="5" class="innertable3"> <tr> <td > <table width="100%" border="0" cellspacing="0" cellpadding="0" align="left"> <tr > <td> <table width="15%" border="0" cellspacing="0" cellpadding="0" align="right" class="w100"> <tr> <td> <a href="https://${URL_1_1}" target="_blank"> <img src="$co_record.Image_1" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> </td> </tr> </table> <table width="15%" border="0" cellspacing="0" cellpadding="0" align="right" class="w100"> <tr> <td> <a href="https://$co_record.URL_2" target="_blank"> <img src="$co_record.Image_2" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> </td> </tr> </table> Some sample code above utilizing code you provided, but link only pulling from $URL_1 CO field, I need to pull from   $URL_2, $URL_3 etc.. ... View more

Sorry, new to using the discussion. I have 6 links within the CO which need pulling in, the example you gave seems to pull only URL_1 - is there a way to use the code you had provided and pull all 6 links? Below is how I had set it up but links broke.    #set($co_record.URL_1 = $DynamicCustomObjectList.URL_1)    #set($co_record.URL_2 = $DynamicCustomObjectList.URL_2)    #set($co_record.URL_3 = $DynamicCustomObjectList.URL_3)    #set($co_record.URL_4 = $DynamicCustomObjectList.URL_4)    #set($co_record.URL_5 = $DynamicCustomObjectList.URL_5)    #set($co_record.URL_6 = $DynamicCustomObjectList.URL_6)   For example each link was added as -       <a href="https://$co_record.URL_1&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_1" width="100" style="border-collapse:collapse; padding:0px; margin:0px;    border-spacing:0; display:block;"/></a>    <a href="https://$co_record.URL_2&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_2" width="100" style="border-collapse:collapse; padding:0px; margin:0px;    border-spacing:0; display:block;"/></a>    <a href="https://$co_record.URL_3&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_3" width="100" style="border-collapse:collapse; padding:0px; margin:0px;    border-spacing:0; display:block;"/></a> Hope you can help. Thanks, Haroon ... View more