Upload Excel Data

When you want to create a Data Upload operation for Pricefx PriceAnalyzer, insert a Connector Shape and follow all the steps described in Create an Operation.

Upload.png

In Step 2, the setup should look like this: 

file upload.jpg

The last field 'Operation' (which relates to Step 7 in the common flow) has the following options.

Select the object type:

file upload wizard.jpg

Click 'Import' to generate the response schema. Metadata fields imported to the interface are "readonly"; they are just for reference. 

The field shows the last data update time of the selected table. 

file upload operation.jpg

Upload Data Request

The request must be an XLSX file and the maximum size is 1 MB. The file can be provided to the connector by the Disk connector.

Refer to the Pricefx documentation on how to create a data upload file. This file can be uploaded from Pricefx UI as well.

worddav844e494be76fc2f0305300e32b76ba12.png

worddav8d2f1d93cc838e5c47cc47ebde37b556.png

worddav6c4ec8804a3868ee79bbde3d1442ee18.png

Standard Action Response Schema

See Standard Action Response Schema for PA Operations.