Search mapping error and isempty filter

I am trying to map a field with a search of sales order number (in our case it is called booking) to get the value of the division.

In my search filter I have the following:

[["custbody_eym_booking","is","{{{[BK No]}}}"],"AND",["mainline","is","T"]]

The BK No column in the field contains the name of the sales order (booking) so in our example it is Booking #BK871.

When we run the flow we are getting the following error:

"A mapping error occurred. More than one match for \"[\"custbody_eym_booking\",\"isempty\"]\" for the record type \"transaction\"."

Why does it show isempty in the error when I am mapping the column with the sales order name and the custom field is in the transaction with the same name?

Hi, Paul. Sorry that that error description isn't helping much.

It's a shot in the dark, without being able to see how the data is structured at each endpoint and then modified throughout your flow. For that level of analysis, you'll probably need to submit a support ticket.

What I have noticed in looking through similar questions is that that problem is most likely unrelated to your filter, which looks fine. Usually the source of the error is on the data mapping side, specifically with NetSuite subrecords, lookups in line items, or SKUs/IDs not synced between the systems when making updates.

Hi @paulnavarrete,

The is operator is converted to isempty by the NetSuite connector (adaptor) when searching where the searchValue is empty. Can you check whether your {{{[BK No]}}} in the source data might be empty?