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
