Many times in order to save up time in API integration, we suggest to skip API integrations for masters and sync them by giving a dump on client’s FTP folder.

This is not the ideal recommended method, Ideally all data should come through API integration.

Here is the process how that can be done

Overview

The client will be posting CSV files with the complete snapshot in the required format in the expected folder structure once a day.

Azure Data Factory Pipelines will be segregating New and Updated masters line items by comparing the current day's file with the previous day's file and will call the respective omni standard APIs.

This Integration covers the automation of Master Data mentioned below.

  1. Article Master
  2. Vendor Master
  3. Customer Master
  4. Vendor Location Master
  5. Customer Location Master

SFTP Details

Below are the SFTP details that will be required from the client.

  1. Host
  2. Port
  3. Username
  4. Password

Folder Structure

File Folder Name File Name File name example
Article Master sku_master sku_master<currentdate(yyyyMMdd)>.csv sku_master20221015.csv
Vendor Master vendor_master vendor_master<currentdate(yyyyMMdd)>.csv vendor_master20221015.csv
Customer Master customer_master customer_master<currentdate(yyyyMMdd)>.csv customer_master20221015.csv
Vendor Location Master vendor_location_master vendor_location_master<currentdate(yyyyMMdd)>.csv vendor_location_master20221015.csv
Customer Location Master customer_location_master customer_location_master<currentdate(yyyyMMdd)>.csv customer_location_master20221015.csv