Auto load excel/csv file from MID server to ServiceNow target tables

Sarah Bouil
Tera Expert

‎12-19-2022 11:22 AM

Need to automated data import from MID Server to ServiceNow tables(cmn_location table). The excel/csv file is having Locations data and it's present in MID server. So I need to auto load(create/update) data in cmn_location. kindly help me with the scripts(step by step).

 

Once it loaded into ServiceNow table the attachment should be removed from data sources and import sets.

0 Helpfuls
  • 715 Views
2 REPLIES 2

SanjivMeher
Kilo Patron
Kilo Patron

‎12-19-2022 11:31 AM

There are lot of articles which may help you achieve this requirement

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

 

https://www.servicenow.com/community/it-service-management-forum/import-a-file-to-servicenow-from-mi...

 


Please mark this response as correct or helpful if it assisted you with your question.
0 Helpfuls

Sarah Bouil
Tera Expert
In response to SanjivMeher

‎12-19-2022 11:46 AM

Is it possible to do the SOAP message, if yes kindly help me with the scripts(step by step). Already I have verified the above threads but I need detailed steps please.

0 Helpfuls