How to create ServiceNow tickets from a text or CSV report

moon-buddy
Kilo Contributor

I don't have a lot of XML or Java knowledge but tons of Unix/Linux/DOS scripting knowledge.

I have a pending task to achieve: the creation of ServiceNow tickets of the INCIDENT or REQUEST type from data feeds like TEXT (tab or other delimited TEXT) or CSV format.

How can I do this? Since I have very limited XML or Java knowledge, is there a tutorial for this?

Thanks


Ed
St Louis, MO

2 REPLIES 2

Aaron40
Kilo Guru

This is easy!

And best of all, you don't need to know any scripting to get this done. If you have a CSV, you're most of the way there already.

Please take a look at http://wiki.servicenow.com/index.php?title=Importing_Data_Using_Import_Sets .

Basically you'll create a new data source and create a new transform map. You'll then run your data source and transform map to pull over the fields.

Please take a look at that link above, try it out and post any and all questions you have during the process here. We'll be happy to help you through this import process.


sgm73
Kilo Contributor

"servicenow" + "incident" + "from a CSV.file" + "REST API" + "Jakarta"

Simple ask without uploading a Update set via a UI

So taking a CSV and feeding it line by line into the REST API

I would be interested in knowing if others have done this via Json or Python or Powershell

Best Regards,

Steve