Get constituent prospect status- Flow fails if empty

Carol Grant

I have a flow that pulls in prospect status but when its empty I get the following error:

Action 'Get_constituent_prospect_status' failed

[{"message":"The requested operation could not be fulfilled","error_name":"RequestNotFulfilled","error_code":404,"raw_message":"The requested operation could not be fulfilled","error_args":[]}]

I can't figure out how to look at the Get Items before it runs. This is run by one person at a time.

I can't filter the array, there are no trigger conditions under settings. I have tried doing a condition if empty but it doesn't get that far.

Thanks,

Carolyn

Glen Hutson

@Carolyn Grant
We're checking with folks here at Blackbaud to see if we can make an adjustment to that API Endpoint / Connector action. In the mean time, this may be an alternative solution (or may prompt ideas from others).

After that "Get constituent prospect status" action, create a Condition. Once you create that condition, click the three dots the right and select “Configure run after”.

On the resulting screen, check: “is successful” and “has failed” and then click done:

In the Condition Value, select expression and enter

length(coalesce(outputs('Get_constituent_prospect_status')?['body/status'],''))

And then “is greater than” and 1 . The on the yes side, put in what you want to happen when there is a status and on the no side when there is no status.

What this is doing:

• Making the condition run regardless if the “Get constituent prospect status” passes or fails.
• The coalesce function is a short-hand if/then to say "hey, if there is a status use that, if not, replace it with an empty result". Empty and null are two different things.
• The length part of the expression returns how long the status result is.
  • If it's greater than 1, then there's something really there and follow the ‘yes’. Otherwise, follow the ‘no’.

Carol Grant

@Glen Hutson

THANK YOU!! That worked!

I had tried to do configure run after on the next item in my flow but it didn't work. I read about the coalesce function in Google but I wasn't sure if it would work here so thank you for your expertise.