cmdb_key_value table

[rachna56]

Hi Team,

When I try to hit the cmdb_key_value table by forming a query it doesnt give me the filtered response, seems like its giving the default response. I didnt face this issue for the other tables. Can anyone help me with the reason and other alternatives. I need this to validate the response in my automation.

https://<base uri>/cmdb_key_value?sysparm_query%3DvalueSTARTSWITHxxxxxxxxx

https://<base uri>/cmdb_key_value?sysparm_query=configuration_item.sys_id%3Dxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

[Slava Savitsky]

Here is the correct syntax:

https://<base_uri>/cmdb_key_value_list.do?sysparm_query=valueSTARTSWITHxxxxxxxxx 

https://<base_uri>/cmdb_key_value_list.do?sysparm_query=configuration_item.sys_id%3Dxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

[rachna56]

Actually , I had tried with this /cmdb_key_value_list.do - received 400 bad request.

Removing encoding helped me that is %3D to =

[Slava Savitsky]

I am glad to hear your problem is now solved. Would you please mark my answer as correct in order to close this thread?