Discussion posts and replies are publicly visible
I think you were trying this from a Smart Service, where we can pass the parameter of proper type by keeping them null and it works fine.
From Expression function:
When I initially tried passing an initialized parameter of type integer having a null value it, it always returned the below exception
[success:false,error:The conversion from UNKNOWN to UNKNOWN is unsupported.]I had a look into the expression function and there is no validation for if a input parameter is passed or not.Hence as a workaround if you are evaluating a stored procedure from an expression function, and need to pass a null, just don't map that as an input.Although in the doc it says they should be defined for functions as well.
© 2023 Appian. All rights reserved.