Fill Excel sheet values in the RITM variables

[Gowtham Kodali]

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

[Gowtham Kodali]

full name should go to requester

category and sub catgeory are variables

[Yash Agrawal1]

Hello Gautham,

You can directly create ritm and fill its variable, it is not even the best practice,you need to understand the process that first you need to order a catalog item, from that request get created after that ritm get created.

You have to follow that process.

if you directly create RITM with variable from where you will get the REquest number as it is important to have a request number in it.

Instead of RITM,you can create a request via transform. as it is a pre-requisite for RITM.

I hope you get my point.

Please keep posted if want more help.

Please Mark it helpful/correct if my answer helps in any way to resolve your query.
Reach out to me if any more help required.

Regards

Yash.K.Agrawal

[Gowtham Kodali]

Hi @Ankur Bawiskar  can you please look into this 

[Ankur Bawiskar · 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

[Gowtham Kodali]

is it possible to map the Fullname coloumn in excel to the Requested for in RITM