I’m trying to set up a flow that performs a loop action over products updated in the last hour. In the “Get product data” action, there is a prebuilt filter for products updated in the last day, and it seems like I should be able to use a custom query to filter by products updated in the last hour. I need to narrow my filter window because this action can only create a list of 100 products and even an inventory adjustment via a sale is considered a product update (per this documentation). By this criteria, my store easily has more than 100 product updates per day, and I don’t want to accidentally miss products in my loop action. However, I’ve not been able to figure out the correct syntax for this query, and when my Flow has completed with errors I get a completely blank screen when trying to view the run results, so I can’t even figure out where I went wrong. Any help in creating a query to retrieve products updated in the last hour would be appreciated.
There are examples in Flow for the syntax to use. You just need to adjust the time window. You should be able to use something like date_minus: “1 hour”.
Ah, I was using hour_minus: “1 hour” as the query but it wasn’t telling me what my specific syntax error was. The query of date_minus: “1 hour” worked.