---
sourceDocument: Yokohama Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/source-to-pay-operations

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Employee


---

# Import data using FTP server

# Import data using FTP server {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Import a file from a local source, a remote network server, or another instance by
providing a path and authentication information. Transfer and manage procurement data in a
principled structure that administrators can use for various data management
operations.

## Before you begin

* Understand the data import workflows and FTP functionality.
* Ensure that you install and configure an FTP client.
* Ensure that you install and configure MID Server in your ServiceNow instance to connect to the ERP server. See [Installing the MID
  Server](https://www.servicenow.com/docs/access?context=mid-server-installation&version=yokohama&pubname=yokohama-servicenow-platform&ft:locale=en-US) for details.  
  Note:  
  The MID Server integration is required only for an ERP integration using SOAP services.
* Ensure you have permissions to access and pull data from FTP.

{#ftp-data-import__ul_xgk_nh1_j3b}

Role required: import_admin or admin

## Procedure

1. Navigate to All.
2. On the left navigation pane, enter <kbd class="ph userinput">sys_data_source_list.do</kbd>.  
   The entire list of available data sources is displayed.
3. In the Name search field, enter spend to find and select the spend data sources you want to configure.
4. On the form, fill in the fields:  
   {#ftp-data-import__table_xyb_nrh_wnb__entry__2}

   | Field | Description |
   |-|-|
   | Name | Enter a unique name for this data source. |
   | Import set table label | Specify a label for the import set staging table to use. |
   | Import set table name | ServiceNow uses the label to construct a unique table name to prevent namespace collision with an existing table. This table stores the data from any third-party sources. |
   | Type | Select File as the type of data that you are importing from. |
   | Format | Select JSON as format. |
   | File retrieval method | Select SFTP as format for data transfer. |
   | File path | Specify the file path for querying. |
   [Table 1. File]

   {#ftp-data-import__table_xyb_nrh_wnb}
5. Set additional fields based on the selected Type.  
   See the documentation for each data source type for additional field information. The Table transform map is associated with the table to transform the `File Based Catalog Import
   [sn_spend_ftp_intg_catalog_stage]` data into `Catalog Import [sn_spend_intg_imp_catalog]`. For more information on the table transform map, see the [Data source table information](https://servicenow-prod.fluidtopics.net/z8notPtw1PkSRlzzHSjYmA "The following information can help you with the FTP import and export data.").

## What to do next

* Manage the data integration by scheduled import and export jobs on a daily, weekly, or monthly basis. Perform the Scheduled Imports based on your business needs. See [Schedule a data import](https://www.servicenow.com/docs/access?context=t_ScheduleADataImport&version=yokohama&pubname=yokohama-integrate-applications&ft:locale=en-US).
* Verify the accuracy of the data import and share the errors on the FTP server. The reseller can fix the posted errors using [Perform export steps](https://servicenow-prod.fluidtopics.net/_2oxIzEfRx0mgUPGq46Vxw "Export a file from a local source, a remote network server, or another instance by providing a path and authentication information.").
{#ftp-data-import__ul_gty_kdk_xnb}
* **[Run scheduled imports](https://servicenow-prod.fluidtopics.net/M~fC4~BmbHdekRNebX7ylQ)**   
  A scheduled import allows administrators to import data on a regular schedule. Run import operations on a daily, weekly, or monthly basis based on your business requirements. Scheduled import runs a datasource similar to how a scheduler job runs the script.