Fill Excel sheet values in the RITM variables

Gowtham Kodali
Tera Contributor

Hi,

I have a requirement like 

I have to create Requests in ritm table and the Excel sheet contains the values which are to be inserted into the RITM variables . is it possible to Insert the  values from the Excel sheet to the RITM variables

and also the Username is given in the Excel sheet and I have to match that User name to the Requested for

 

Thank you

 

1 ACCEPTED SOLUTION

@Gowtham Kodali 

I assume you are having variable values in Excel and using that you need to create RITM and REQ

you will have to use Cart API for this

Also you need ExcelParser script to parse the excel row by row and create RITM with all the variable info

https://developer.servicenow.com/app.do#!/api_doc?v=newyork&id=GEPS-GlideExcelParser

these links will help you as well

Reading Attachment Contents || Copying attachment || Attachment Properties

Loading data from an email attachment

Script to create RITM with variable info

How to submit a catalog item from script?

Create requests from excel import

Regards
Ankur

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

View solution in original post

12 REPLIES 12

Hi,

you need to know from the excel column headers which are the fields on RITM and which are the variables for that catalog item

if the excel column headers are the variable names then while excel parsing you can get the variable names

If the rows are the variable values then you can set them using the Cart API.

Please check the links I shared they should definitely help you

Regards
Ankur

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

@Gowtham Kodali 

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate answer as correct & helpful to close the thread.

If not, please let us know if you need some more assistance.

Regards
Ankur

 

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

@Gowtham Kodali 

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate answer as correct & helpful to close the thread.

If not, please let us know if you need some more assistance.

Regards
Ankur

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