Hello, I would like to filter shopify transactions (or even orders) in the HTTP Get request module. However, URL filter nor string filter doesnt work.
URL filter:
https://shopname.myshopify.com/admin/api/2024-07/shopify_payments/balance/transactions.json?processed_at_min={{replace(formatDate(addDays(now; -1); “YYYY-MM-DDT00:00:00XXX”; “Europe/Prague”); “+”; “%2B”)}}&processed_at_max={{replace(formatDate(addDays(now; -1); “YYYY-MM-DDT23:59:59XXX”; “Europe/Prague”); “+”; “%2B”)}}
String filters:
created_at_min: formatDate(addDays(now; -1); “YYYY-MM-DDT00:00:00XXX”; “Europe/Prague”)
created_at_max: formatDate(addDays(now; -1); “YYYY-MM-DDT23:59:59XXX”; “Europe/Prague”)
GOAL: I want to sum up all shopify fees from yesterday.
I cant use make filters since im then iterating all transactions and with numerical aggregator summing them all up together. Since its in the loop, it doesnt acknowledge the filter. Any advice please?
