Create RITM based on excel attachment
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2024 07:19 AM
Hi,
I am developing a form to onboard multiple users via excel file.
This excel file will contain the users first, middle and last name, the user type and other fields that are to be pasted onto the new RITM.
I can't seem to isolate a single row with the GlideExcelParser, only columns.
Anyone knows how this can be done?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2024 12:59 PM
Hi, with no details of your code\configuration\example file, it's not really possible for the community to evaluate your issue. Are you using the method getRow() method?
GlideExcelParser - Scoped, Global | ServiceNow Developers
Perhaps you could share details of your code (as plain text) so that it can be reviewed\.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2024 01:20 PM
Hi @mipalm ,
you would require an after insert business rule on sc_req_item table with condition as Catalog Item is yours and if it has attachments
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
this link will help you as well
Script to create RITM with variable info
https://community.servicenow.com/community?id=community_question&sys_id=928a9f4ddb73ab805ed4a851ca96
If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!
Thanks & Regards,
Sumanth Meda
