Multiple Filters in API Request

Hello,

I was wondering if it was possible to apply multiple filters. I know that you can pass a JSON string as follows

{"created_at:gt":"2013-01-01 00:00:00"}

But what would happen if I specify two filters

{

"created_at:gt":"2013-01-01 00:00:00",

"updated_at:gt":"2013-01-01 00:00:00"

}

Will this be treated as an AND or an OR condition?

I’m trying to retrieve all submissions either created or updated within a given time window.

Hi Alonso,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Regarding your question about applying multiple filters in an API request, when you specify multiple filters like:

{
"created_at:gt":"2013-01-01 00:00:00",
"updated_at:gt":"2013-01-01 00:00:00"
}

This is treated as an AND condition. So, the API will retrieve submissions that meet both criteria — submissions that were created after the specified date and updated after the specified date.

If you want to retrieve submissions that were either created or updated within the time window (an OR condition), this would require a different approach, as the API filters combine conditions with AND by default.

Let us know if you need further clarification.

Give it a try and let us know how it goes.

Hi Alonso,

Currently, Jotform’s API does not support logical OR operations between filter parameters. This means you can't retrieve submissions either created_at or updated_at falls within a specific time window in a single request. As a workaround, you can make two API request to get the submissions created at and another for updated at. Each call retrieves submissions that match one of the conditions. After retrieving both sets of submissions, you can merge them on your end.

Let us know if you have any other questions.