What is the best approach for a bulk request for a service catalog item

[Lawrence4]

We have a requirement to raise a bulk request for a service catalog item and we are looking to do a transform map with it. Is there an easier approach to do this because you can't map the fields in the requested item table. Thank you

[Ron Legters]

Hi Lawrence - An approach that I've taken with this sort of thing is to create a record producer, and have the user attach a spreadsheet with a row for each item. Then we used a script with the cart api to create RITMs for each row in the spreadsheet. It seems plausible that you could also do this with a multi-row variable set rather than a spreadsheet, but I haven't done that. (I'm not crazy about the spreadsheet thing, but the customer's existing process used a spreadsheet, so this was just sort of automating that)

Does that help?

[Lawrence4]

Hi Ron, thanks for the response. They said this is just a one time requirement so I was thinking of just doing a transform map instead of a record producer. 

So the record producer that you created, they can still use it everytime they want to raise a bulk request? right?

[Ron Legters]

They can, yes. You would just need to publish the template someplace where everyone can get to it, and they would use that every time.

If this is just a one-time thing, you could still do it with an import, but, as you've noticed, you can't just map fields to Request Items. Your transform for the import would need use a script to invoke the Cart API to create request items for the rows you import. 

This community post has some links to documentation:

https://community.servicenow.com/community?id=community_question&sys_id=f88e8b43db016010f21f5583ca9619d9&view_source=searchResult