There are a couple ways to tackle. As Gary said you can start by writing your payload as formula for each record. Then you can create a single parent record for all the data then creating a combined text field at the parent with the date filter you need. Then using another formula field get rid of ";" and add any other json. Then use this field (payload) in your API call.
or
You can use Pipelines Webhook Make Request and do a QB RESTful API call to get your records. Then make your new API call and in the body build your Json using Jinja to iterate over the records. If your API call can take a text/csv (content type) this gets easier because you just make the body look like a CSV.
Here is a txt/csv body example:
FirstName, RecordID
{% for record in a.json.data %}{{record['10'].value}},{{record['3'].value}}
{% endfor %}
note: QB Call you'll want to use is api.quickbase.com/v1/records/query not the API_DoQuery
