Connections API Issues for Dates in Nov-24

[Jeff Van Note]

We have noticed we get a 500 or 502 internal server errors when querying connections for date ranges in Nov-2024

Example Queries

Our filter is slightly more detailed and we select more columns, but these simplified examples that retrieve just a few rows illustrate the error.

Not Working - November time period:

This runs for a while before timing out.  It works occasionally.

https://api-us.cloud.com/monitorodata/Connections?$filter=IsReconnect eq false and ModifiedDate ge 2024-11-03T18:40:00.000Z and ModifiedDate lt 2024-11-03T22:40:00.000Z&$top=20&$select=Id,SessionKey

Working - Earlier time period"

This works, response time is a few seconds.  I have moved the dates to different months and widened the time interval.

https://api-us.cloud.com/monitorodata/Connections?$top=20&$filter=IsReconnect eq false and ModifiedDate ge 2024-09-03T18:40:00.000Z and ModifiedDate lt 2024-09-03T22:40:00.000Z&$select=Id,SessionKey

[David E.]

hi,

Do you receive data if you change modifieddate with brokeringdate?

I just input your first filter in my env and no problem here.

[Jeff Van Note]

Thanks for the idea.  I gave BrokeringDate a try.  I also tried CreatedDate.  Both worked OK and no 500 errors after testing many calls.

[David E.]

nice!