- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2020 03:34 AM
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
Solved! Go to Solution.
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2020 07:51 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2020 08:08 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-15-2020 10:59 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2020 09:31 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader