Import CSV file in local system in a Data source

Devishree Anant
Tera Contributor

‎05-17-2022 07:21 AM

I need to configure a data source. In that I need to import a CSV file from local system. I have created an import set table and transform mapping. And that has been made referred into the data source. Where to insert the CSV file?

 

TIA

0 Helpfuls
  • 1,276 Views
4 REPLIES 4

Maik Skoddow
Tera Patron
Tera Patron

‎05-17-2022 06:16 PM

Hi

you have to upload the CSV file on the record of your Data Source.

You also can load the file from any source that is available via HTTP(s), (S)FTP or SCP (see https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/import-set...)

Kind regards
Maik

0 Helpfuls

Pranav28
Tera Contributor
In response to Maik Skoddow

‎03-12-2024 02:45 AM - edited ‎03-12-2024 02:46 AM

Hello Maik,
Is there any way to load data into ServiceNow from local file path (where CSV file is located / file from local drive) and that too without using FTP? or without attaching the csv file to the data source? Is this even possible?

0 Helpfuls

Andrew Eyre
Tera Contributor
In response to Pranav28

‎09-18-2024 06:26 AM

Yes, you can do that with the API. Personally, I opted for PowerShell as this was super easy to configure and it can be triggered using the MID server

0 Helpfuls

avieet
Tera Contributor

‎09-18-2024 06:53 AM

Is the use case to only import CSV files or is it also to process data within that csv file?

0 Helpfuls