The Now Platform® Washington DC release is live. Watch now!

Help
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

kanika11
Kilo Contributor

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

1 ACCEPTED SOLUTION

Deepak Ingale1
Mega Sage

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.

 

find_real_file.png

 

find_real_file.png

 

find_real_file.png

View solution in original post

2 REPLIES 2

Deepak Ingale1
Mega Sage

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.

 

find_real_file.png

 

find_real_file.png

 

find_real_file.png

Thank you! "%5EOR" is working coorectly