Get a Gift Notification Automated Flow Failed

Cathy Kollar

Hi Everyone, I have several gift notification workflows that failed today after running for several months. ?The failure is at Get a Gift returning a NotFound message. The gift ID is correct. Anyone have a suggestion?

Thanks for your help?

Ben Lambert

@Cathy Kollar Hi Cathy, just based on your screen shot…it looks like you might be using a "Get a gift" action inside a loop, where the looping array was returned from the “List gifts” action? If that's the case, then you can actually remove the “Get a gift" action altogether because the “List gifts” response will already include it. That will make your flow run faster as it's less API calls and less work fetching data that is already available in the flow.

That said, the “List gifts” action and the “Get a gift” action pull data from different databases under the hood. “Get a gift” returns the data from your transactional RE database, while “List gifts” returns data from the same internal data structures that power the “Lists” functionality in RE. This separate database is populated by an internal ETL process, so there is a potential for a small amount of latency (the process runs often so generally the latency is minimal).

This latency could show up if you delete a gift from RE and then immediately call "List gifts". The deletion may not have propagated from the transactional database to the “Lists” database under the hood. So a deleted gift could still show up in Lists for a small amount of time (and you'd see this in RENXT as well).

Another potential cause could be a change in your user permissions - for example, if you don't have permission to view gifts from a specific fund. I would expect “Lists” to respect that security as well, so this may not be the problem but wanted to mention it as potential.

So the first thing I'd check is to see if the gift in question still exists and hasn't been deleted. If the gift has been deleted then look in the “Lists → Gifts” area of RENXT and see if the “List update x minutes ago” is very large which might explain why the record still appears in the “List gifts" action.

Cathy Kollar

@Ben Lambert Sorry for my delayed response and thank you for your advice! I finally have the time to revisit this problem. Yes, the “Get a gift” data is pulled from a “List gifts” action. My goal is to add soft credit recipient to the HTML gift table.

I want to share more information to see if you thing I should still delete the “Get a gift” action. Here's the error message returned today: Unable to process template language expressions in action 'Donor_Name_and_Amount' inputs at line '0' and column '0': 'The template language expression 'body('Format_Amount_with_$_and_decimals')?['body']' cannot be evaluated because property 'body' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'.
More images of my flow: