Bulk upload of Catalog Item Requests

[kkaufmann]

Our company has recently acquired another small company and need to add these users to our system.  We currently have Service Catalog Items for "Add Active Directory" and "Add Citrix Access."  

I can create the Request and related RITM with transform scripts, however, I am having difficulty with two issues:

How do I populate the variables that are needed?

How do I fire the current workflow for each item so the SCTASK can be created with the Variables?

Thanks.

[Kalaiarasan Pus · Accepted solution]

Here is a sample of using catalog API to create requests.

https://docs.servicenow.com/bundle/london-application-development/page/script/server-scripting/reference/r_ServiceCatalogScriptAPI.html

[kkaufmann]

Thank you!  That worked just as needed.

[bpolo]

Hi

We are currently looking into doing something very similar. Please would you be able to write out the complete steps that you took to accomplish this. That is did you first create a user table and transform map to store the import data from the spreadsheet? Did you script the API  somewhere in the transform map, or did you write Business rules? Did the workflows automatically trigger when you inserted the catalog items?
Any help would be much appreciated. Thanks!   

[bpolo]

Hi

We are currently looking into doing something very similar. Please would you be able to write out the complete steps that you took to accomplish this. That is did you first create a user table and transform map to store the import data from the spreadsheet? Did you script the API  somewhere in the transform map, or did you write Business rules? Did the workflows automatically trigger when you inserted the catalog items?
Any help would be much appreciated. Thanks!