Ideas on how to dynamically import CSV files into Servicenow.

[Meloper]

Let's assume that a team (software) has no possibility to send data to ServiceNow via RestAPI.

Furthermore, we assume that the manual effort to do IT manually via request or File Upload would be too high

Means the team wants to import new data to servicenow every day.

It was possible to export the data as a CSV file and store it on a Windows share.

This means that the file would be stored dynamically in the share.

Now it should be recognized whether the file contains differences compared to its previous file or has a new timestamp.

If so, it should be imported to Servicenow.

Can anyone think of anything?

Is there 3rd party software that can do this and perhaps write the file to an SQL database on which you can then build a scheduled import and use a DataSource?

The solutions to store the file on the mid server all come to nothing.

[SumanKumarM]

Hello Meloper,

Please refer below video, it might solve your problem.

https://www.youtube.com/watch?v=x1Lkxe4YoI0

Please mark helpful, if content answers your question.

Cheers,

Suman.

[HIROSHI SATOH]

This can be achieved by using ETL such as "MuleSoft".
If your environment allows, you can also get the files using FTP etc. from the ServiceNow Integration Hub.