When you want to create a Bulk load 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 last field 'Operation' (which relates to Step 7 in the common flow) has the following options.

Bulk Load Request Message

Here you build a Bulk Load Request Message by Message (raw JSON) shape. The JSON Message should contain 2 array elements, namely header and data.

All the fields of the target table have to be specified in the header array. Any fields not specified will be treated as empty. The data array contains the list of multiple records to be inserted to the target table. The order of the data fields must be same as the order of the header.

Maximum size of JSON request message accepted = 1 MB

Maximum number of records to be loaded = 200 000

Standard Response Schema (Number of Records Processed)

See a separate section.

The number of records returned does not mean the number of records loaded here.