Populating Variables on RITM using Transform Map

Swati Mishra
Tera Contributor

I have a requirement to create Requested Items using data in Excel. This file will also contain the variables that are required to create the RITM if created using service catalog. But here the data will be fetched using an excel file. So I want to know how can I achieve populating the Request variables using transform map. I am able to populate the fields placed directly on the Requested Item form, but having an issue populating the Request variables.

1 ACCEPTED SOLUTION

@Swati Mishra 

since you have excel file you will have to parse it and get the variable value and use Cart API

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

7 REPLIES 7

Hi Ankur, 

Thanks for your suggestion, I was able to generate RITM as required. Unfortunately it creates only one RITM whereas I need multiple. I referred to your article about creating multiple request using script where you had used for loop in jSon array. I am trying to customize that, hope it helps.

 

@Swati Mishra 

Sure.

Let me know if I have answered your question.

If so, please mark my response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Swati Mishra 

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark my response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur

 

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader