Creating Web API which can handle Nulls

Question

Hi everyone, 
 
 I'm trying to do a simple web API which can handle nulls values, but I'm having problems using the if statement to set it up. Can someone please help me. Thank you 
 
 filter: a!queryFilter( 
 field: "name", 
 operator: "=", 
 value: if(isnull(http!request.queryParameters.name)," " ,http!request.queryParameters.name), )

Peter Lewis · Answer

There is actually a separate "is null" operator, so you probably would want to separate this out by using conditional logic around your entire Query Filter. Something like this would work: 
 filter: if(
 a!isNullOrEmpty(http!request.queryParameters.name),
 a!queryFilter(
 field: "name",
 operator: "is null"
 ),
 a!queryFilter(
 field: "name",
 operator: "=",
 value: http!request.queryParameters.name
 )
) 
 One other important note: the vale you have there for " " is technically not null - a space and null are not considered equivalent in Appian.

Creating Web API which can handle Nulls

Top Replies