Upsert

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

In Step 2, the setup should look like this: 

The response message returns all the records successfully upserted. If you do not want to process a big response message, you can select the “Return No of records processed” option in the Import Wizard.

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

Upsert Request Message

Here you build an Upsert Request Message by Message (raw JSON) shape. It is an array of all the records to be upserted.

Maximum JSON file size accepted = 1MB. Maximum number of records to be upserted = 500.

Standard Response Schema

See a separate section