How to use opsgenie api to get alert list between a datetime range

[gnaneswar seshu]

Hi,

I was trying to get alerts between a period of time, when I used the query as ""

query": "createdAt>=20-08-2024 and createdAt<=22-08-2024" it is giving me some list of alerts but when I was trying the query including time within it for example ""

query": "createdAt>=20-08-2024'T'10:30:00z and createdAt<=22-08-2024'T'18:30:00z I am not getting any alerts while I can see alerts from ui or app

here is the sample url which is working:

"https://api.opsgenie.com/v2/alerts?limit=20&sort=createdAt&offset=20&order=desc&query=status+open+OR+closed+NOT+tag+QA+createdAt%3E31-07-2024+AND+createdAt%3C31-08-2024",

Sample url which is not working

"https://api.opsgenie.com/v2/alerts?limit=20&sort=createdAt&offset=20&order=desc&query=status+open+OR+closed+NOT+tag+QA+createdAt%3E31-07-2024'T'10:30:00z+AND+createdAt%3C31-08-2024'T'18:30:00z",

Thanks in advance

[Wei Wung]

Hi @gnaneswar seshu 

Thank you for reaching out! 

Please try using this format: 

createdAt>="20-08-2024T10:30:00Z" and createdAt<="22-08-2024T18:30:00Z"

The workaround in the following ticket addressed this issue as well:

https://jira.atlassian.com/browse/OPSGENIE-1588  Incident API and Alert API using the "createdAt" condition display incorrect usage error