Filtering the service catalog task from Excel through REST API

SN_2023
Tera Contributor

‎10-11-2023 09:06 AM - edited ‎10-11-2023 09:07 AM

Hi,

 

I am communicating the servicenow Service Catalog Tasks (sc_task) table from Excel VBA 2019 through REST API. Everything works fine except one issue. I want to show only the TASKS is "active" and the state is "Open". On the servicenow webpage it works fine. But unable to filter the record from Excel VBA 2019 macro. It brings all the Service Catalog TASKS to Excel without filtering. I have included the filtering URL which was copied in servicenow url in SysQuery parameter. 

Any help to resolve this issue?

 

Note: Please see the image for the Excel VBA code for the URL

Thank you.

 

Preview file
105 KB
0 Helpfuls
  • 341 Views
1 REPLY 1

SN_2023
Tera Contributor

‎10-13-2023 03:51 AM

The issue is resolved myself. Earlier I copied the filter condition URL from the browser url. But I found that we should copy the URL from the filter option. Click "Filter" Button. select the filter conditions. Click RUN button. Then copy the url by right clicking the final filter option. Now Every thing  works fine.

 

0 Helpfuls