How do I import a service catalog item's attached spreadsheet into its multi row variable set?

mike275 · ‎09-25-2019

I have a service catalog item with an MVRS with a few fields. I have a link on the page to a spreadsheet template I want to allow users to fill out and upload to populate the MVRS.

Can I do this?

mike275 · ‎10-07-2019

It's possible - I did it like so:

Create a workflow script task that
If an attachment exists for the SC item, I create an Excel attachment datasource
Copy the attachment from the SC item to the Excel data source
Import from the data source created in #3 into an Import Set
Query the Import Set table and read the imported rows, converting them into Javascript objects and pushing them onto an array
Set the MVRS value to the JSON.stringify(...) value of the array created in step 5

I do data validation and all that, and add comments in the task if rows in the spreadsheet contain invalid data.

View solution in original post

mike275 · ‎10-08-2019

Here is the article about it with a link to the script:

https://community.servicenow.com/community?id=community_article&sys_id=acadc97adb1c8490feb1a851ca961...