I'm trying to improve an old Infusionsoft service that is getting too slow. I noticed that is doing too many requests in order to find events (ContactAction) in a date range.
I tried to research before, but as it is a bit old, there are not many answers for this. The most approximate answer I found is this one about not being able to use two conditions with the same field, but I'm expecting that there's a workaround for that in the present time.
The field I need to query is ActionDate over ContactAction and I found this link that says that a special query format like this can be used for "bigger than":
ActionDate => '~<=~ 2023-01-01 00:00:00'
but how do I limit the "lower than" to avoid a slower call? is it even possible?
