Can anyone tell me how to run a web url Query in PowerBI using a web URL servicenow REST API on the Incident table using field opened\_at between start and end date ?

For example I have the below query

<https://asosdev.service-now.com/api/now/table/incident?sysparm_display_value=true&sysparm_exclude_reference_link=true&sysparm_fields=number%2Copened_by%2Cshort_description%2C> opened\_at%&sysparm\_limit=500

This returns number,opened by, short description and opened\_at for a ,limit of 500 rows.

How do I update the query to return data between opened\_at '01 Jan 2022' and '31 Mar 2022'

Is there some example queries anywhere on the web that shows how to write these Web url rest api queries to build a report in Power BI.

Also how to add where clause e.g. where short description contains 'john'

Many thanks in advance for your help and assistance.