Kevin Dugger
Kilo Guru

Good Afternoon Mayor,

If I am understanding your ask correctly, you are have an existing catalog item and you would like to create a request for each row of your spreadsheet.  It has been a while since I've needed to do this, however, I believe you can script the transform in order to accomplish this.  These cannot be directly mapped like a normal transform because of the way data is stored for catalog variables.  What I would do is to import the data you have into an import table, then create a transform map, and use a transform script to create the catalog items. 

Review the Service Catalog Script API for details on how to script this.  This should allow you to create a catalog request for each row of your data. 

Details of how to script this can be found in the Transform Map Script API documentation.

I hope this helps you get started.

 

Thanks,

Kevin

View solution in original post