Filter the api response using Sysparm_query for nested JSONObject

Adithya Khurana · ‎07-21-2023

Hello,
Is there a way to filter the response using sysparm_query, i want the role to be itil & the provided user id.
I tried the below query but it doesn't work. could you please help.

role.display_value=itil^user.value=

b6b364e253131300e321ddeeff7b121b

Response :

{

"role": {

"display_value": "knowledge_manager",

"link": "https://dev143839.service-now.com/api/now/table/sys_user_role/f8bfbd02eb202100216a87b9d106fe92",

"value": "f8bfbd02eb202100216a87b9d106fe92"

},

"user": {

"display_value": "Problem Manager",

"link": "https://dev143839.service-now.com/api/now/table/sys_user/d3dbbf173b331300ad3cc9bb34efc466",

"value": "d3dbbf173b331300ad3cc9bb34efc466"

}

},

Community Alums · ‎07-24-2023

@Adithya Khurana ,

No need to use role.display_value and user.value.

you can filter by

sysparm_query: role=(sys_id of itil role)^user=(sys_id of user).

It's working as desired

View solution in original post

Adithya Khurana · ‎07-23-2023

yeah i understood, for single key value pair i am able to query.

API Response :

{"result": {

"calendar_integration": "1",

"country": "",

"user_password": "74R17ry2kM"
}}

Key : sysparm_query
Value : user_password=74R17ry2kM

How to query for the nested object ? (what value should be passed )

API Response : ( I want to get the result of role that has display value = "knowledge manager")

"result": [

{

"role": {

"display_value": "knowledge_manager",

"link": "https://dev143839.service-now.com/api/now/table/sys_user_role/f8bfbd02eb202100216a87b9d106fe92",

"value": "f8bfbd02eb202100216a87b9d106fe92"

}

},

key : sysparm_query
value : ?????

Adithya Khurana · ‎07-24-2023

Team, Could anyone provide update on this please

Community Alums · ‎07-24-2023

Hi @Adithya Khurana ,

Do you want to acheive this in Postman ?

Adithya Khurana · ‎07-24-2023

yes like external API Call