Problem with static map from boolean value

Integrator.io
, , , ,
1

I'm sure I'm missing something basic, but I'm not seeing it. I have a dead simple static lookup for a NetSuite SO import. The export data is boolean and the Import data is a List/Record ref.

When I run the flow I'm receiving error:

Failed to create, update/transform record because You have entered an Invalid Field Value null for the following field: price

When I preview the mapping it works fine. The retry data confirms the expected xxxxx.isKeyAccount property is present.

Here's the mapping showing the input data:

5301043caa20740200000001-bb6a7559f79f45fcb8c668c23ac10399.png
5301043caa20740200000001-bb6a7559f79f45fcb8c668c23ac10399.png784×688 87.5 KB

And here is the lookup settings:

5301043caa20740200000001-593724462095414e84ed43114d3bd803.png
5301043caa20740200000001-593724462095414e84ed43114d3bd803.png737×808 27.7 KB

I'm using the current SuiteApp on the Import. I've recreated the mapping multiple times.

The error is a NetSuite error due to the flow setting null as the value for price. The mapping isn't configured to send null and should fail if there's no match, not send null.

Anyone see the issue?

2

Hi Steve,
Not sure 100% , but could it be because of the data type "boolean" ? a true or false are expected for the field based on the config, but you are trying to send a non-boolean value?
I didn't actually test this , just from a first look at the issue.

3

Hi Youssef,

You nailed it! I don't know why I was thinking that needed to be a boolean, but I realize it's the destination Type, not the export type. Thanks for the help :)