Good morning,
I created a flow that allows to retrieve API data and store them in a database.
The frequency is daily.
I would like to be able to add in the Body Json of the API, the date Today so that every morning the query retrieves the data of the day.
Do you have an idea ?
THANKS
{
"size": 10000,
"track_total_hits": true,
"query": {
"bool": {
"must": [
{
"range": {
"timestamp": {
"gte": "@{Day(utcNow())}08:40:05.753Z",
"lte": "@{Day(utcNow())}T08:50:37.704Z"
}
}
}
]
}
},
"sort": [
{
"created": {
"order": "desc"
}
}
]
}
