Retrieve csv files placed on NAS and import into SN

[keshav77]

Hello All

We have a requirement to pull csv files placed NAS server into ServiceNow. 

Can you please let me know the process to proceed ahead with this.

Any help here would be appreciated.

Thanks.

[Ankur Bawiskar]

@keshav77 

check this

Import files from Nas and attach them to task 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Hi @keshav77 

1. ServiceNow is a cloud platform, it cannot directly reach into your local NAS storage. You need to  install a ServiceNow MID Server on a machine within the same local network that has read access to your NAS server. 

2. Automate File Transfer:

   a. Option 1: Flow Designer with PowerShell (Recommended): Use Integration Hub to create a Flow containing a PowerShell script. The script copies the CSV from the NAS file path to the MID Server and uses a REST API to attach it directly to a Data Source record in ServiceNow.

Ref: Import files from Nas and attach them to task 

b. Automated Data Import - Using MID Server and PowerShell

Refer these 2 helpful resources:

https://developer.servicenow.com/connect.do#!/share/contents/2271821_remote_file_importer_import_fil...

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