The Now Platform® Washington DC release is live. Watch now!
‎12-17-2018 08:45 PM
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
Solved! Go to Solution.
‎12-17-2018 09:38 PM
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.
‎12-17-2018 09:38 PM
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.
‎12-18-2018 01:26 AM
Thank you! "%5EOR" is working coorectly