Filters in REST calls?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2022 04:28 AM
How do you set up a filter in the Query Parameter section of a REST Data Source Request? I've got a connection to a SQL Server database that works fine to pull all of the records in the table, but I need to limit that. I haven't been able to figure out how to construct the filter for the REST call. Any help would be greatly appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2022 03:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-19-2022 07:52 AM
Hi,
You can use a data pill in the Query Parameter value for any query parameters described in the external API.
Query parameters may contain different types of values.
- Encoded queries
- Field name(s)
- true/false/all
Refer below screenshot for data pill.
Hope it helps!!
Please Mark ✅ Correct/helpful, if applicable, Thanks!!
Regards
Pavankumar
ServiceNow Community MVP 2024.
Thanks,
Pavankumar