How to Map the MRVS field value to the custom table fields

[Vijay Baokar]

Hi, 

I have a requirement where i need to map column values from MRVS to the similar column in ServiceNow custom table.

Let say in MRVS i have 3 columns 

1. Service Type

2. Region

3. Business Area

and i have similar 3 fields created in custom table. Now whenever i submit the catalog , all (3) column values from every row from MRVS should be mapped to custom table.

[Ankur Bawiskar · Accepted solution]

@Vijay Baokar 

it's an easy task

these links have solution, you need to parse that MRVS json, iterate and create the record into target custom table

How to create records in a table from MRVS? 

How to store record producer Muti row variables set in custom table 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Vijay Baokar]

Hi @Ankur Bawiskar Thanks for help as always, can i modify the script as per my requirement in workflow or flow designer since i am using Catalog item not the record producer?

[Ankur Bawiskar]

@Vijay Baokar 

yes you can add in workflow run script or have it in after insert business rule on RITM table.

If my response helped please mark it correct and close the thread so that it benefits future readers.