How to use the Filter Array action on a field that is sometimes null

(0) Share

Report

Posted on by CU15101301-0

I'm using the HTTP action to pull records from a 3rd party provider. I want to only bring in records where the 'OptionDate' field value is greater than '2024-01-01', however some of the records have a null value for 'OptionDate'. As you can imagine, as soon as the GET encounters a record with a null value for 'OptionDate', the flow stops with a failure. 'The template language function 'greaterOrEquals' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

Is there a way, using advanced mode in the Filter Array action, to say something like, 'if field not null, then check to see if greater than 2024-01-01'?

Thanks

Categories:

General

All responses (1)

Answers (0)

Suggested answer

SaiRT14 317 on at

Like (0)

Report

How to use the Filter Array action on a field that is sometimes null

check if the OptionDate is not null, If it’s not null, then compare it to your date (2024-01-01).
@and(
not(equals(item()?['OptionDate'], null)),
greaterOrEquals(item()?['OptionDate'], '2024-01-01')
)