Pass a Default value to a Map Function from Inbound document with Null value for field

Document created by pete_mccoy1.3055586893899446E12 Employee on Dec 19, 2013
Version 1Show Document
  • View in full screen mode
Trying to pass a value from an Inbound Document to a Map function that calls a stored procedure and the input value is NULL receiving this error.

Embedded message: [Function: Sql Lookup]: Prepare the sql parameters error!; Caused by: For input string: ""
Instead passing the data from the inbound document, try setting a dynamic document property, and do a user defined map function that calls the property and assign a default value if the value of the property is a NULL.