Import .csv file from midserver, to Servicenow and to create report

[Sriram28]

hello team,

Requirement : customers have csv file data in their system. So, they want that data to be imported/loaded into ServiceNow  and create a report from it.

Note : this should be done on daily basis.

How we can achieve this ?

thanks in advance

[Mark Manders]

The file is placed on the MID server daily? Do you already have the import of the file to ServiceNow setup? Because then it would just be a datasource, create the import table and transform map and run a report against the data.

What kind of data is it? In what table are you putting the data?

[Sriram28]

@Mark Manders 

Thanks for your response.

Yes, file is placed in midserver daily.

No, we have not imported the file to ServiceNow setup.

The data is in excel/csv format.

Could you please help me what method in data source should be used for this kind of requirement ?

if any related documentation also, please provide.

Thanks in advance