How to submit a bulk request in Service Catalog?

[Harriet K]

Hi SNow community,

Is there a way for a user to submit a bulk request, where they attach a spreadsheet containing variables in their service catalog request and in turn, service now will parse through the content, creating requests for whatever the variables specify?

I appreciate any suggestions and insights you may have.

Thanks in advance!
Harriet

[Richard45]

With most SN questions, yes. You could have an item the user attaches the sheet, preferably a template they can get from the system to help with data validity. Then in the workflow parse the file, and create additional RITMs based on the data in the sheet.

If I were you, I'd want to better understand what problem this is solving. Could cart quantity serve 80% of bulk requests? Would setting up bundles or a more guided form on an item fit the requirements? Having a process this open ended will create massive work for you and be prone to failure if even the littlest things are wrong

[Harriet K]

The customer wants to be able to use an existing bulk load template spreadsheet, which allows them to copy and paste data from their own exported file.  They then want to be able to upload that file to ServiceNow service catalog, which then parses through that data and generate one request with multiple ritms. Do you know of a way to do this?

[Richard45]

I would investigate how closely you can get the source data and ServiceNow integrated to reduce manual intervention and human error:

1. Can the user attach the exported file without copy-paste?

2. Can the source system call ServiceNow APIs to create REQ/RITMs directly?

As for the processing of an attachment, here are some resources to help:

• https://snprotips.com/blog/2016/2/25/understanding-and-using-glideattachment
• https://community.servicenow.com/community?id=community_question&sys_id=f9ae7e65db58dbc01dcaf3231f96...

[Harriet K]

Thank you! I will look into these.