How to use a filter in a query profile in the advanced .xml body

I'm using a query profile to get data from an endpoint.

All works well for most endpoint's but with one of the endpoints I run into an error where I assume the load to be too big (time out)

 

I would like to cut it into chunks by setting a filter, perhaps something like where updated_at > 2023-05-01

 

what's the best way to do this?

 

Have you tried pagination while creating the api profile?