Dynamic Daily Output and Run Daily Dynamic Date

[alteroak]

So looking for some assitance, if you see below we are querying DB via rest API to grab last 24 hours of data

In payload we are using http post method and delivering query like this

{
"query" : "SELECT __time, amount, account, campaign, type, userAgent FROM \"example-table-events\" WHERE __time >= CURRENT_TIMESTAMP - INTERVAL '24' HOUR"
}

This will then output JSON file for us to work with

However what we need to do is 

1) We will run this daily, so want to automatically get the previous complete days data without missing any timeframes, post query may need adjusting?

2) We output static file as you can see called everything.json which will get overwritten everytime it runs, however we want files to sit in folder to be added daily instead e.g 1stapril.json, 2ndapril.json etc etc

Whats best way alteryx can handle this? Example workflows appreciated