Create Catalog Item via Excel Data Source

[Justin Pakula]

Hello,

I would like to ask for some help with importing Requested Items into ServiceNow via an excel sheet/data source. I've been tasked with creating a bulk upload from an excel sheet using an existing catalog item. I can create the request item, but the associated workflow doesn't get created or started. I've tried initializing a cart on both onAfter and onBefore, but this doesn't associate the cart to the imported item. The cart script include just creates a new item independent to the import set row. The script include for cart looks like it's per user and not per item. 

Has anyone done this before or have some guidance to solve this?

Thank you,

Justin

[Justin Pakula · Accepted solution]

Update: I've been able to create the item and its associated workflow successfully. I have an onBefore transform map that initializes the cart and places the order with the variables. I used the transform map script from Request Generation Methods as a reference. 

The next issue that occurred was the import creating 2 request items per row on the excel sheet. The first item created was a blank record from the transform and the next was the expected record. I had to add an 'ignore = true' on the main transform script to ignore the first record then process my actual excel record via the onBefore script.

I'm not sure if this is best practice or the right way to approach this, but I have a working solution for now!

Thanks,

Justin

[bpolo]

Hi Justin

Please would you be able to share the script you used to trigger the workflow. I also need to do something very similar. Any help with this would be much appreciated.

Thanks so much!