Malay_Chakrabo1

Hola Marketo community  👋   I had some questions on addition using velocity scripting. We're trying to send out invoices via the Marketo emails and are pushing the invoicing data in Marketo custom objects through our Datawarehouse.    Thus, I wanted to understand if any accounts have multiple invoices they will be created as multiple custom object records in Marketo. So I am trying to see if we can make additions on multiple MKTO custom object records if the records match certain criteria.    Please see below the script we have come up with:    #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/Denver") ) #set( $defaultLocale = $date.getLocale() ) #set( $calNow = $date.getCalendar() ) #set( $ret = $calNow.setTimeZone($defaultTimeZone) ) #set( $calConst = $field.in($calNow) ) ##Set Subscription Details via the MKTO Custom Object #set( $renewDate = $convert.parseDate(${renewalObject_cList.get(0).subscriptionEndDate},'yyyy-MM-dd') ) #set( $renewSubDate = $convert.toCalendar($renewDate) ) #set( $ISO8601DateOnly = "yyyy-MM-dd" ) #set( $ISO8601DateTime = "yyyy-MM-dd'T'HH:mm:ss" ) #set( $ISO8601DateTimeWithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $ISO8601DateTimeWithMillisUTC = "yyyy-MM-dd'T'HH:mm:ss.SSSZ" ) ##Set Subscription Name, Status, AutoRenew via the Renewal Custom Object #set( $Subscription = ${renewalObject_cList.get(0).subscriptionName} ) #set( $Status = ${renewalObject_cList.get(0).subscriptionStatus}) #set( $AutoRenew = ${renewalObject_cList.get(0).autoRenew}) ##Set Invoice MRR via the Renewal INVOICE Object #set( $InvoiceMRR = ${renewalInvoice_cList.get(0).cALCULATEDMRR} ) #set( $ItemID = ${renewalInvoice_cList.get(0).Item_iD}) #set( $AutoRenew = ${renewalObject_cList.get(0).autoRenew}) #set( $interestingItems = [] ) #foreach( $item in $renewalInvoice_cList ) #if( $item.cALCULATEDMRR.ne("") ) #if( $item.autoRenew.equals("1") ) #set( $void = $interestingItems.add($item) ) #set( $nextRenewDate = $convert.parseDate($item.subscriptionEndDate,'yyyy-MM-dd') ) #set( $nextRenewSubDate = $convert.toCalendar($nextRenewDate) ) #if( $date.difference($calNow,$nextRenewSubDate).getDays() <= xx ) #set( $DisplayInvoiceMRR = $interestingItems.add($item.cALCULATEDMRR) ) $DisplayInvoiceMRR## #elseif( $date.difference($calNow,$nextRenewSubDate).getDays() <= yy ) #set( $DisplayInvoiceMRR = $interestingItems.add($item.cALCULATEDMRR) ) $DisplayInvoiceMRR## #end #end #end #end ... View more

Hi there,    I am looking for some help from the community in regards to Marketo Custom objects.    Description:  Recently, we have moved our subscription renewal reminder emails from Zuora to Marketo and we are passing the renewal-related data from Zuora to Marketo custom object 'Renewal ReminderObject'. Then using velocity scripts we are translating the data from the renewal reminder object and reference them in the emails.    Now I am trying to also include invoice details in the emails and in order to house the invoice data I have to create another Marketo custom object ' Renewal Invoice Object'.  Thus, the goal is to pull in certain fields from the Renewal reminder Object and a few invoicing fields from the Renewal Invoice Object.    Issue:  One of the major issues with doing so is duplicate records. Our SFDC instance has a lot of duplicate personas of the same email addresses. Thus, how do I make sure when our data warehouse is pushing data to these custom objects, both are associated with the same person object?    For eg. there are 2 person records with the same email address as below:    A - test1@test.com B - test1@test.com   How do I make sure that if the Datawarehouse is pushing data to the Renewal Reminder object for record A then DW also pushed the data for renewal invoice object for record A(not B)?    I am very keen on your input and your help is deeply appreciated.    Thanks, ... View more

Hi there,    I am trying to get various Velocity script to fetch data from a Subscription SFDC Custom Object and I wanted to ask help in understanding how do I make sure that I am selecting the relevant Subscription record. I am trying to only select the records whose subscription is ending in the next 3 months.    Thus, I wanted to check if there is a way in VTL to filter/constraint certain conditions? So the script always picks up the relevant data. ?   Example Script:    ##Fetch Subscription Data from SFDC Custom object #set($SubscriptionName = ${Subscription__cList.get(0).Name}) #set($SubscriptionStatus = ${Subscription__cList.get(0).Subscription_Status__c}) #set($AutoRenew = ${Subscription__cList.get(0).AutoRenew__c}) #set($NextRenewalDate = ${Subscription__cList.get(0).NextRenewalDate__c}) ##Conditions #if (($SubscriptionStatus == "Active") && ($AutoRenew == "true")) ${SubscriptionName} #else Test Fallback Name #end   With this script where there are multiple subscription records, the script is picking up the oldest record always and the fallback sentence is displayed.    Please let me know if you know how I can select the right record to fetch data from?    Thanks ... View more

Hi there,    I wanted to check if anyone has experience with reading data from the user object in Salesforce?  I'm trying to create a global lead assignment, routing rules, and task creation within Marketo. Thus, I'm looking to create a Smart campaign to listen to our form-fillups and assign leads based on the below criteria:    1. Person fills a form or comes through Web-service APIs.  2. If it is an existing Lead/Contact check if the current Sales Owner is active or inactive.  3. If the Sales Owner is active then re-open the lead. If the Sales owner is inactive then assign the lead to a sales queue.    Thus, I wanted to check if there is a way to read user objects from Salesforce to determine which lead assignment rules need to be activated.   Thanks,  ... View more