Exporting data table rows based on query using HTTP node in a workflow

Help
1

I want to export data table rows based on query, such as below, from a workflow using HTTP node.

{
“email”: “someemailaddress”,
“query”: {
“$and”: [
{
“month”: {
“$eq”: “07”
}
},
{
“year”: {
“$eq”: “2022”
}
}
]
},
“queryOptions”: {
“limit”: 10000
}
}
Question is how should the query data be given to a POST request? I will be able to give the appropriate headers like Authorization etc

POST https://api.losant.com/applications/APPLICATION_ID/data-tables/DATATABLE_ID/rows/export

2

Hopefully the API documentation for the Data Table Rows: Export endpoint answers your question. The query goes in the body; you can view its JSON schema here.

FYI, you can also use the Losant API Node to perform this action instead of an HTTP Node. You may find that easier to use.