I have a NetSuite import step that upserts (add or update) a custom record including several point of contact fields (List/Record: Employee). In the event any one of those POCs is an Inactive Employee, the whole record fails…
Failed to save record because invalid [custrecord_fieldname] reference key [employee internal id].
What is the best practice to ensure the rest of the record updates while the Inactive Employee value is either ignored or nulled?
Instead of direct mapping, maybe you could make the mapping to the employee field a lookup, which then fetches the employee and filters to where employees are active. From there, maybe you could then set "Use null as default"?
Another option would be to have an individual lookup step to fetch the employee details from NetSuite, then make a branch for inactive employees and active ones, and then have different mappings.
That appears to have worked. I would never have thought of doing a lookup for a value I already had. Thank you.