How to filter with multiple parameters in Rest API
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-31-2022 02:15 AM
Hi Team,
I want to make api which will filter the data based on short_description and u_requested_for.When I tried able to filter by requested for and not able to filter by short_desc. could you please suggest the exact query to filter.
https://****.service-now.com/api/now/table/sc_req_item?sysparm_limit=5&sysparm_display_value=true&sysparm_query=u_requested_for.name=Selina Forte&short_descriptionLIKESHOP
- Labels:
-
Integrations
-
Team Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-31-2022 02:31 AM
Hi,
you gave incorrect query
you should use ^ to give AND condition
if you want OR then give ^OR
https://****.service-now.com/api/now/table/sc_req_item?sysparm_limit=5&sysparm_display_value=true&sysparm_query=u_requested_for.name=Selina Forte^short_descriptionLIKESHOP
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader