Combine Documents to Do Batch Upsert

Calling upsert once per each document is inefficient and would cause heavy loading in Pricefx. Pricefx would slow down and decline further connections if volume is too high and frequent.

In this scenario, the documents should be batched by the Flow Control shape so that only one upsert is called to upsert the whole batch. The batch size can be set to a larger value (up to 500) depending on the size of record. The message size has to be smaller than 1MB.

The documents can be combined by Data Process shape. Select the document profile and the combine element is always Array/items1 for all the master data upsert operations.

Â