Import a file from a mid server to ServiceNow

Hans Peter
Tera Contributor

‎02-02-2022 09:55 AM

Hi,

I'd like to import a CSV file that's sitting on the mid server to my ServiceNow instance. Ideally, I'd like to use a scheduled import for that, so I need a data source.

Unfortunately, I can't really find an option to import files from the mid server? How can I achieve this?

Thanks in advance,

Hans

0 Helpfuls
  • 2,110 Views
2 REPLIES 2

Ct111
Giga Sage

‎02-02-2022 10:00 AM

Three solutions given in support article . Plz chk one of them as per your need and convenience

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0817437

 

Mark my Answer as Correct and Helpful if ot helps

0 Helpfuls

Hitoshi Ozawa
Giga Sage
Giga Sage

‎02-02-2022 01:14 PM

Another option not mentioned is to use csv - jdbc driver or load the csv into a in memory database.

Example:

http://www.hsqldb.org/doc/2.0/guide/texttables-chapt.html

http://www.h2database.com/html/tutorial.html?highlight=csv&search=csv#csv

https://github.com/simoc/csvjdbc

 

FYI, following thread contains powershell script to upload excel file to an attachment.

https://community.servicenow.com/community?id=community_question&sys_id=5e264251db194d10bb4a474d1396...

0 Helpfuls