Best approach to use Middleware to update data tables

**This post was created as part of a How to Service Request (SR)**

Release: 22B

Summary of the question: When using middleware to send updates to the CPQ Data Tables, which method is the best way to do so? There will be an initial load of a large amount of data, followed by periodic delta updates that are much smaller.

FTP Approach:

Middleware will create upload.xml and csv file and put it in the CPQ FTP folder -> CPQ FTP folder will process the data and create/update records in the CPQ data table.

REST API Call Approach:

Middleware will call CPQ REST API to create/update records in the CPQ data table.