Mapping of multi row variable set in fulfilment record

PriyankaSadhwni
Tera Expert

Hello,

All variables of record producer are getting transferred /mapped in custom target  table (not in fields present in table, but they are visible in 'Task Read only Varriable editor' except one new multirow varriables  I mean to say; 'map to field' is false for all varriable.

 

PriyankaSadhwni_0-1684331884800.png

 

'

PriyankaSadhwni_1-1684332066739.pngPriyankaSadhwni_2-1684332137289.png

 

I am looking for:

I want to fetch and Print all 10 to 15 rows of multirow varrible set in  field -type multi Line.
I wonder why fields of mutirow varriables is not coming in Variables section even once

1 ACCEPTED SOLUTION

Harshal Aditya
Mega Sage
Mega Sage

Hi @PriyankaSadhwni ,

 

Hope you are doing well.

If map to field is set to false the variable mapping must be defined in the script field on the record producer.

 Please refer below script to print mrvs values

var mrvs = JSON.parse(producer.testmrvs); // replace with mrvs internal name
var value = "";
for (var i in mrvs){ // consider test1 and test2 are two variable in mrvs
	value  =value+ "test1" + " "+mrvs[i].test1 +" "+"test2" + " "+mrvs[i].test2+"\n";
}
gs.log(value);

 

 

Please mark this response as correct or helpful if it assisted you with your question.

Regards,
Harshal

View solution in original post

7 REPLIES 7

PriyankaSadhwni
Tera Expert

@Ankur Bawiskar  Any clue on above?

 

@Ankur Bawiskar 

I can see values in 'Multi row Question answer

Harshal Aditya
Mega Sage
Mega Sage

Hi @PriyankaSadhwni ,

 

Hope you are doing well.

If map to field is set to false the variable mapping must be defined in the script field on the record producer.

 Please refer below script to print mrvs values

var mrvs = JSON.parse(producer.testmrvs); // replace with mrvs internal name
var value = "";
for (var i in mrvs){ // consider test1 and test2 are two variable in mrvs
	value  =value+ "test1" + " "+mrvs[i].test1 +" "+"test2" + " "+mrvs[i].test2+"\n";
}
gs.log(value);

 

 

Please mark this response as correct or helpful if it assisted you with your question.

Regards,
Harshal

In script sect mappings are not there except for setting URL.

Also when I tried so;in making chnges in script ; existing mapping are impacted