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:

Design & build

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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')
)

Was this reply helpful? Yes No