Conditional mapping (NetSuite)

Integrator.io
, ,
1

Is there a way to map a subrecord only if a certain field value is != data in the source application?

e.g. I want to map the Quantity in the source JSON to the destination (NetSuite) inventory detail sub record but I only want to do this mapping if the quantity field (source JSON) is higher than the quantity field on the NetSuite sub record.

Thanks

2

Hi @craigsilk,

You can't do this using normal conditional mapping as it involves NetSuite subrecord quantity searches. However, you could do this using a NetSuite postMap SuiteScript hook. Our conditional mapping can only be used if the condition completely depends on the source data.

3

Thanks for this answer.

All this really needs to do is overwrite the field 'Inventory Detail : Quantity'.

I have set 'true' for the field 'Inventory Detail : Replace All Lines' in Celigo but this overwrites everything rather than just the quantity so if the inventory is not available, an error is thrown in celigo as the last piece of inventory is already assigned to the order that we are trying to fulfil.

When 'Inventory Detail : Replace All Lines' was not set, it looked like Celigo was trying to create a whole new line which means the QTY is now too high.