- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2020 11:40 AM
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