谁能告诉我如何在开始日期和结束日期之间使用field_at在事件表上使用Web URL ServiceNow REST API在PowerBi中运行Web URL查询？
例如，我有以下查询
https://asosdev.service-now.com/api/now/now/now/table/incident?sysparm_display_value=true＆syssparm_exclard_exclude_exclude_rede_rede_rede_refere_refere_link_link=true间＆amp; sysparm_limit = 500
此返回号码，由简短描述和打开的_AT打开，限制为500行。
如何更新查询以返回opened_at '01 2022'和'2022年3月31日之间的数据，
网络上的任何地方都有一些示例查询，其中显示了如何编写这些Web URL REST API查询以在Power BI中构建报告。
另外，如何添加条款，例如简短描述包含“约翰”的位置，
非常感谢您的帮助和帮助。
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.
发布评论
评论（2）
对我来说，最简单的方法是使用视图列表过滤器。一旦您向您显示正确的记录，就可以右键单击过滤器，然后选择复制查询或URL。然后，您可以在SeviceNow Rest探索中使用它，以进一步调整API调用
For me, the easiest way to do this is to use the view list filter. Once you get it to show you the right records, you can then right click on the filter and select to copy query or url. You can then use this within SeviceNow REST Explore to further tune your API call
您可以按建议使用列表过滤器，也可以使用REST API Explorer快速测试并迭代查询。
使用标准列表查询构建查询以确切定义您想要的内容，然后通过复制查询来捕获SYSPARM_QUERY值（右键单击查询，然后选择 coppy query query （或 URL获取）并将其粘贴到API Explorer中
从
You can use the list filter as suggested or use the Rest API Explorer to quickly test and iterate your queries. ServiceNow REST API Explorer
To build queries using the standard list query to define exactly what you want and then capture the sysparm_query value by copying the query (right click the query and select Copy query (or get from the URL) and paste that into the API explorer.
Using a List Filter has a few advantages