How to formulate a API to get articles from multiple knowledge base?

kanika11 · ‎12-17-2018

I want to formulate an API which will fetch articles from multiple knowledge articles

https://<hostname>/api/now/v1/table/kb_knowledge?sysparm_query=kb_knowledge_base=<sys_id of knowledge base> &sys_updated_on%3E%3D2018-09-06%2005%3A12%3A53%5EORDERBYsys_updated_on&sysparm_limit=1000

the above query is for single knowledge base. However , I have tried

https://ibmmobi.service-now.com/api/now/v1/table/kb_knowledge?sysparm_query=kb_knowledge_base=<sys_id1>ORkb_knowledge_base=<sys_id2>&sys_updated_on%3E%3D2018-09-06%2005%3A12%3A53%5EORDERBYsys_updated_on&sysparm_limit=1000

https://ibmmobi.service-now.com/api/now/v1/table/kb_knowledge?sysparm_query=kb_knowledge_base=<sys_id1>,<sys_id2>&sys_updated_on%3E%3D2018-09-06%2005%3A12%3A53%5EORDERBYsys_updated_on&sysparm_limit=1000

but these API are not working.

Please suggest what logical operator I need to use to get articles from more than 1 knowledge base in Service Now

Deepak Ingale1 · ‎12-17-2018

Hello,

I tried below via REST API explorer to query from 3 knowledge base, and it returned me the results

sysparm_query=kb_knowledge_base=f9523e640fdd430046f1cfdce1050e9c^ORkb_knowledge_base=a85d66200fdd430046f1cfdce1050e8f^ORkb_knowledge_base=6942cd130fb3130046f1cfdce1050e55

/api/now/table/kb_knowledge?sysparm_query=kb_knowledge_base%3Df9523e640fdd430046f1cfdce1050e9c%5EORkb_knowledge_base%3Da85d66200fdd430046f1cfdce1050e8f%5EORkb_knowledge_base%3D6942cd130fb3130046f1cfdce1050e55&sysparm_limit=10

It has returned 3 knowledge articles each one from one knowledge base

Please construct the query as mentioned above and you should be fine.

Note: Please mark reply as correct if it answers your question.

View solution in original post

Deepak Ingale1 · ‎12-17-2018