Skip to main content

I created an action flow which gets data from the data model and creates a pdf file every day. In the second step it sends the pdf to my email adress. Once in a while the data load doesn't succeed. So the pdf send by the action flow is not up-to-date (data is from the day before). I tried to put a router in between and have two email options. One for the pdf and one with an error message. As a filter I used "now earlier than addHours( timestamp ; 24 )". How could I get the time of the last data load as "timestamp" in this filter?

Thank you so much!

So I am not sure if there is a direct way to handle this, however the suggestion would be to create a table that stores the date when you last transformation ran. Add this table to your data model

 

If the data model is sucessful this date will be the latest one hence you can use the same in your filter.

 

I hope this helps!


Thanks a lot!


Reply