Automate System Import with script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2023 07:37 AM - edited ‎06-07-2023 09:55 AM
Hi! I am trying to automate the system import process. Essentially, from the servicenow catalog I want the user to be able to attach an excel spreadsheet, have it loaded into a data source, then a staging table, then transform it to a maintenance table... but ultimately I just want each row in the excel spreadsheet to be a new record created in the maintenance table.
The script I have successfully creates a data source for the spreadsheet but doesn't import the data into the staging table or the maintenance table. I was wondering if anyone else stumbled across this issue? Below is what I have and I'm doing this through Record Producer.
Additionally, for every attachment I get