Bring in data from SFTP folder to ServiceNow instance

NishONish
Tera Contributor

Hello NowSmart Team,

Request for help please - Our use case is we have a csv file created everyday by another system which provides service desk telephony records like no of calls, chats etc for last 28 days (rolling basis). This csv file is available on a Secure File Transfer Protocol (SFTP) folder - one csv file each day showing last 28 days data (every new day one day from the past is dropped and one new day [yesterday] is added); possible that it has updated data for any of the past days.

one day data example in csv:

"2025-06-03","Voice","100","80","10","6","4","2200"
"2025-06-03","Chat","65","40","15","N/A","N/A","1250"

 

What I know is I need to create a custom table in ServiceNow to get the data into ServiceNow and use a ID to identify each day record. We will use this new custom table for reporting purpose. Can you please help me with what are my options for this integration? We have licensing in place so please suggest all options; with top-to-low priority is extremely helpful. tx a lot

8 REPLIES 8

Ankur Bawiskar
Tera Patron
Tera Patron

@NishONish 

you cannot have dynamic file name in SFTP data source to fetch

So just before scheduled import from that data source, run a scheduled job to update the file name and update it with correct file name so that it picks the correct file from that path

If my response helped please mark it correct and close the thread so that it benefits future readers.

 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar 

I thank you for the response. However I have not got enough to digest it step by step. Is it possible to help me with steps to be followed to implement it and what method of intergration/data import you recommend here? tx again

@NishONish 

My assumption above was that you already have SFTP data source configured and I just shared how you can ensure the correct file is picked daily.

Is that setup not done already?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thank you @Ankur Bawiskar . Not it makes sense. 

No I have not configured SFTP data source. How do I do that pls? I am looking to understand the step-by-step approach pls tx again