End point to SFTP files

Andrew18
Giga Expert

‎09-07-2023 03:51 AM - edited ‎09-07-2023 03:52 AM

We have a requirement where one of our vendors cannot set up an API via their system but can SFTP, how would I go about setting this up in servicenow with end points etc to ingest the data?

0 Helpfuls
  • 395 Views
2 REPLIES 2

Prabu Velayutha
Mega Sage
Mega Sage

‎09-07-2023 04:23 AM - edited ‎09-07-2023 04:25 AM

Hi @Andrew18,

 

You should create a SFTP data source in Servicenow and create a transform map to transform data to the target table.

 

Ask the vendor to provide following details which are required to setup the SFTP data source

  1. SFTP Server name
  2. File format (CSV,XLS etc)
  3. File Path
  4. Port
  5. User name and password

Steps: In the navigation go to System Import Sets -> Data sources and Click on new you will find the below form update all the details. You need to mention the import set table name and it will auto create in the backend and fields get created based on the file columns. If CSV import mention the delimiter.  After you save click test load 20 records to verify the connection and credential, check the data loaded. Then you can proceed with creating Transform Map.

 

PrabuVelayutha_1-1694085885378.png

 

Refer the below document link for transform map creation:

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/script/server-scripting/concep...

 

Revert if you have any questions or issues in setup.

 

Mark this as Helpful and Accept the Solution if my response helps to solve your issue.

Prabu Velayutha
Mega Sage
Mega Sage

‎09-07-2023 07:35 AM

@Andrew18  can you  Accept the Solution if my response helps to solve your issue. It will be helpful for future readers! 

0 Helpfuls