Jayant_Singh

Jayant_Singh · ‎12-12-2021

I am asking for Account name update only.

Jayant_Singh · ‎12-10-2021

Marketing team logged an interesting moment for a lead A in Salesforce MSI tab with company name as X after few week the company name get updated in Marketo to Y but in salesforce MSI tab still the company name shows as X . Does, the changes happen at contact or lead level not in MSI tab when user company name updated?

Jayant_Singh · ‎12-29-2020

Marketo developer has designed dynamic landing page based on language and country segmentation. While testing using segmentation prefix to test dynamic landing page and this is working fine. But, when using the same landing page without prefix in email and testing for multiple languages then data is sync to previous lead. Only, If user delete the cookie then do test again then data sync is happening correctly. Is there any Marketo JS available that helps clearing cookies in this case so that data sync happen to correct lead without doing this clear cookie manually? I read few available reference link in community but did not find exact same thing.

Jayant_Singh · ‎12-22-2020

In my case, when Marketo calculate Person Timezone automatically it is affecting the datetime field like Marketo acquisition date and optin date field details. How can this be sure it does not adjust the person timezone. is there any alternate approach for this?

Jayant_Singh · ‎12-22-2020

I have checked the hyperlink of smart campaign and it is not found in any of the active workspace and this link redirect to same activity log again. Through API sending correct datetime but it is not updating that one and at the same time calculate timezone campaign is running to adjust the person timezone based on country and city but no such campaign is configured in our workspace. I believe this is Marketo backend activity but not sure how to get it correct.

Jayant_Singh · ‎12-22-2020

I am facing datetime zone being adjusted this is the main pain point. For different country the person timezone is being adjusted when we are doing lead import via API. how can this be fixed in this case?

Jayant_Singh · ‎12-18-2020

Marketo custom field opt-in date is sent to internal system database as "optinDate" :"2020-11-28 00:24:20", and while exporting lead from Marketo. Next day, same date is sent to Marketo again via internal system DB "optinDate" :"2020-11-28 00:24:20", via API in this format YYYY-MM-DD hh:mm:ss.0000000 this format but due to that opt-in date is changed with below reason mentioned in Marketo. Our Marketo account timezone is in CEST. Hence, what should be exact format so that optinDate should not change while lead import through API. Can anyone suggest on this issue?

Jayant_Singh · ‎12-01-2020

Hi @SanfordWhiteman In this community thread https://nation.marketo.com/t5/Product-Discussions/Picklist-value-to-store-in-Marketo-Form/m-p/305745#M172397 you suggested a good piece of JS which really helped in setting up picklist value based on proxy field. Now, business use case is to update the rich text content of Marketo Form along with picklist value. i.e. In current, picklist value have either Yes or No only these two value. If proxy field setup the picklist value as Yes in that case rich text content of Marketo Form should also be change through JS and vice-versa. is this scenario is feasible in Marketo Form?

Jayant_Singh · ‎11-29-2020

Firstly, I have modified the code as I see scope of global variable is not needed. #set( $default_Name_Recipe_1 = "#" ) #set( $arrCounter = 0 ) #set( $prodRecoArr = [""] ) #set( $recoURL = [""] ) #set($one = 1) #if( $CO_cList.isEmpty() ) #set( $defaultNameRec1 = $default_Name_Recipe_1 ) #else #foreach( $CO_c in $sorter.sort($CO_cList, "recommendationDateStart:desc") ) #if( !$display.alt($CO_c["recommendationURL"],"").isEmpty()&& ($CO_c["recommendationName"]=="Recipe")) #set($prodRecoArr[${arrCounter}] = $CO_c["recommendationURL"]) #set( $recoURL = ${prodRecoArr[${arrCounter}].split("//")}) #break #end #end #end <a href="https://${recoURL[$one]}">Recipe Link</a> List sorting in above VTL code is due to CO table data get updated weekly so sorting the data to get the most recent data only based on date field. No more loop iteration after getting the single objects in modified VTL code. Also, not need to print the default value. Index has been removed as this was used in global variable reference. Finally, business use case is to generate the traceable dynamic link based on recent data added as well as recommendationName which vary irregularly. Still, I am facing same issue to approve the email.

Jayant_Singh · ‎11-27-2020

Somehow, I missed one condition in VTL which I have added now. In the given VTL,CO table CO_c have the following value recommendationDateStart, recommendationURL and recommendationName and through VTL code want to generate tracking URL when recommendationName has value as Recipe . And in above VTL following things I am trying to do 1. If CO_c is empty for a Lead then display default value 2. Else, based on recommendationName generate the traceable URL 3. As, I have used foreach loop condition I have declared array variable i.e. prodRecoArr so that can assign one URL at one time while using arrCounter variable in this too. 4. At the end of loop condition and first, second IF condition. Evaluating the recommendationURL details and splitting the URL to use correctly in anchor tag <a> </a>. Based on third, IF condition.

Jayant_Singh · ‎11-27-2020

I am facing the issue when approving email below is the error which Marketo throws Validation Error approving An error occurred when procesing the email Rendered_Email_Velocity_Error_Area_?! Error invoking method 'get(java.lang.Integer)' in java.util.ArrayList near below is my VTL code which I tried to implement in email and when I preview the sample email it work perfect but when approving the email it throws above error #set( $default_Name_Recipe_1 = "#" ) #set( $arrCounter = 0 ) #set ($index = 0) #set( $prodRecoArr = [""] ) #set( $recoURL = [""] ) #set($one = 1) #if( $CO_cList.isEmpty() ) #set( $defaultNameRec1 = $default_Name_Recipe_1 ) #else #foreach( $CO_c in $sorter.sort($CO_cList, "recommendationDateStart:desc") ) #if( !$display.alt($CO_c["recommendationURL"],"").isEmpty()&& ($CO_c["recommendationName"]=="Recipe")) #set($prodRecoArr[${arrCounter}] = $CO_c["recommendationURL"]) #set( $arrCounter = $arrCounter + 1) #break #end #end #end #if ($prodRecoArr.size() >= 1 && ($CO_c["recommendationName"]=="Recipe") ) #set($index = $arrCounter - 1) #set( $recoURL = ${prodRecoArr[${index}].split("//")}) <a href="https://${recoURL[$one]}">VTL test</a> #else ${defaultNameRec1} #end In the above VTL, I am displaying data from CO table for product URL and using in email. Can anyone help on this issue?

Jayant_Singh · ‎10-15-2020

Hi @SanfordWhiteman In my case SOAP and REST API name both are same.

Jayant_Singh · ‎10-15-2020

Hi @SanfordWhiteman I have implemented the given JS but it is not working. Can you please help me to replace correct value in the suggested JS script for the given two Field. Field-1 = Country (REST API- country) Field-2 = Country Code (REST API- countrycode) Field-2 is hidden in the form. And I am using REST API name in the JS script. and Autofill as Use Default Value. And Form Prefill disable. Display Value Stored Value United States US Canada CA In this example, what will be the submitOptionText, valueField and textField.

Jayant_Singh · ‎10-14-2020

Business need to store Display Value as well as Stored Value in Marketo Field-1 and 2. Is it possible in Marketo? what will be the logic in such case. In the form, Field Type is Select. and allowing only one field to enable for display in Marketo Form.

Jayant_Singh · ‎07-19-2020

Using JSON, it allows 300 records to update but looking for bulk update using CSV.

Jayant_Singh · ‎07-17-2020

Our team want to update bulk lead via custom API. what will be correct JSON to update lead based on dedupe field as email address.

Jayant_Singh · ‎06-30-2020

While data cleanup process, our team focus is to remove the data whom we have not target in last 2 years. And as per https://nation.marketo.com/t5/Knowledgebase/Marketo-Activities-Data-Retention-Policy-Overview-FAQ/ta-p/250750 data retention policy we came to know that it deletes activity after 25 months for Email send. Problem- In lead activity, we still see email send details in 2016. We found this when setup the filter "Not was sent email" is any. How can I justify this activity in Marketo?

Jayant_Singh · ‎06-18-2020

We have created a Marketo landing page with two hidden field in which one field(email) pre-filled is enabled and another field(unsub) is disabled. Problem: - in database blank lead is being created. What are the possible scenario for this case when blank lead is created and how should it can be fixed?

Jayant_Singh · ‎06-12-2020

Business need is to track UTM parameter details on non-Marketo landing page and to achieve this we have created one time process mytoken as well as used system campaign token. Now, our stakeholder also want to capture email name in the UTM parameter but they do not like mytoken approach as it is need to update every time when new email or program is created. Does anyone have alternate solution for this use case?

Jayant_Singh · ‎05-29-2020

In a loop condition, for each item business need is to sort it twice. #foreach( $myList_c in $sorter.sort($myList_cList, "date:desc") ) #set( $mySortedList = $sorter.sort( $myList, ["field1"] ) ) Considering, more than 1 millions data sets, will this behavior result into 1. email delivery to be delay more 2. soft bounces and campaign response result affected

Jayant_Singh · ‎05-28-2020

In CO list, there are total eight field in which one field is date and second field item type. Business requirement is to sort it based on item type first after that again sort it by date field type. custom objects(default_c) , field Date(date), Item Type(itemType) And, counter is running for up to two times. what will be best way to sort it again and again in Velocity script?

Jayant_Singh · ‎05-25-2020

Hi Sanford, I was wondering if you have gone through the debug code and please let me know the details.

Jayant_Singh · ‎05-23-2020

date class java.lang.String 2020-03-20 08:20:02 leadID class java.lang.String 1 productCTA class java.lang.String https://www.mdg.co.in/product/item.html productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item.png productName class java.lang.String item date class java.lang.String 2020-04-21 08:20:02 leadID class java.lang.String 2 productCTA class java.lang.String https://www.mdg.co.in/product/item2.html productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item2.png productName class java.lang.String item1 date class java.lang.String 2020-05-22 08:20:02 leadID class java.lang.String 3 productCTA class java.lang.String https://www.mdg.co.in/product/item3.html productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item3.png productName class java.lang.String item2 [{date=2020-03-20 08:20:02, leadID=1, productCTA=https://www.mdg.co.in/product/item.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item.png, productName=item}, {date=2020-04-21 08:20:02, leadID=2, productCTA=https://www.mdg.co.in/product/item2.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item2.png, productName=item1}, {date=2020-05-22 08:20:02, leadID=3, productCTA=https://www.mdg.co.in/product/item3.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item3.png, productName=item2}]

Jayant_Singh · ‎05-22-2020

{kv.getKey()} class java.lang.String 2020-03-23 08:20:02 {kv.getKey()} class java.lang.String 4 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item4.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item4.png {kv.getKey()} class java.lang.String item3 {kv.getKey()} class java.lang.String 2020-04-24 08:20:02 {kv.getKey()} class java.lang.String 5 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item6.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item6.png {kv.getKey()} class java.lang.String item4 {kv.getKey()} class java.lang.String 2020-05-20 08:20:02 {kv.getKey()} class java.lang.String 6 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item5.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item5.png {kv.getKey()} class java.lang.String item5 [{date=2020-03-23 08:20:02, leadID=4, productCTA=https://www.mdg.co.in/product/item4.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item4.png, productName=item3}, {date=2020-04-24 08:20:02, leadID=5, productCTA=https://www.mdg.co.in/product/item6.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item6.png, productName=item4}, {date=2020-05-20 08:20:02, leadID=6, productCTA=https://www.mdg.co.in/product/item5.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item5.png, productName=item5}]

Jayant_Singh · ‎05-22-2020

I am using only the debug code and removed everything from VTL. #set( $coList = $pro_cList ) #foreach( $record in $coList ) #foreach( $kv in $record.entrySet() ) {kv.getKey()} ${display.alt($kv.getValue().class,"")} ${display.alt($kv.getValue(),"null")} #end #end ${coList} In the template, I am using {{my.VTL}} to debug it now. is it ok now or need to add code more?

Jayant_Singh · ‎05-22-2020

This is the one script product name where I added the code at the top. <html> <body> <table> #set( $coList = $pro_cList ) #foreach( $record in $coList ) #foreach( $kv in $record.entrySet() ) {kv.getKey()} ${display.alt($kv.getValue().class,"")} ${display.alt($kv.getValue(),"null")} #end #end ## start product name select <tbody> #set( $DEFAULT_Product = "No item in list." ) <tr> #if( $pro_cList.isEmpty() ) #set( $outputName = $DEFAULT_Product ) #else #foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") ) #if( !$display.alt($pro_cList["productName"],"").isEmpty() ) #set( $outputName = $pro_c["productName"] ) #break #end #end #set( $outputName = $display.alt($outputName, $DEFAULT_Product) ) #end <td> ${outputName} </td> </tr> </tbody> </table> </body> </html> is code placement is incorrect?

Jayant_Singh · ‎05-22-2020

I have added the code in three ways 1. Full code at top after debug no change in previous email design. 2. Both end statement at last after debug nothing display. 3. Putting both end statement before output the ${outputName} and got below design

Jayant_Singh · ‎05-22-2020

In the given code, 1. kv and record will be replaced with any property? 2. This code need to add in velocity script in starting

Jayant_Singh · ‎05-22-2020

I am selecting CO list tree. am I missing anything?

Jayant_Singh · ‎05-22-2020

I have already selected that one but not sure why it is evaluating only default output this is the worry part and I am not starting macro unless I am sure that I can get output individually correct.

Online Status	Offline
Date Last Visited	‎12-13-2021 12:38 AM

Date Registered	‎09-24-2019 02:52 AM
Date Last Visited	‎12-13-2021 12:38 AM
Total Messages Posted	41

Top Badges Earned

Re: Interesting Moment Account name not updating

Interesting Moment Account name not updating

Clear cookie for dynamic landing page

Re: Timezone to import lead in Marketo account CE...

Re: Timezone to import lead in Marketo account CE...

Re: Timezone to import lead in Marketo account CE...

Timezone to import lead in Marketo account CEST

Proxy field setup to select picklist value And upd...

Re: Validation error approving with Email Approve...

Re: Validation error approving with Email Approve...

Validation error approving with Email Approve whe...

Re: Picklist value to store in Marketo Form

Re: Picklist value to store in Marketo Form

Picklist value to store in Marketo Form

Re: lead update via API

lead update via API

Data Retention Policy- Email Sent

Lead created without email address

Email name to use as a UTM parameter

Looping condition sorting for bulk data in Custom ...

Custom Objects List sorting more than one field

Re: Velocity Dynamic Content Sorting

Re: Velocity Dynamic Content Sorting

Re: Velocity Dynamic Content Sorting

Re: Velocity Dynamic Content Sorting

Re: Velocity Dynamic Content Sorting

Re: Velocity Dynamic Content Sorting

Re: Velocity Dynamic Content Sorting

Re: Velocity Dynamic Content Sorting

Re: Velocity Dynamic Content Sorting