The goal:
I want to get all the kb articles from a specific servicenow knowledge base in a JSON format.
Example response format:
[ {
"kb_id": "321321312",
"number": "KB12341",
"category": "IT",
"text": "HTML article content",
"lastUpdated": ""
},
{...}]
Since the information is separated in different SN tables - kb_category, kb_knowledge, kb_template_.. I thought I can go with a scoped appliction and custom table which will collect all this information for the KB articles.
The custom table should be synchronised with the SN tables once a day.
What is the best way to sync and populate the custom table with the SN kb tables? To use some kind of a scheduled script?
Does anyone know some guidlines for developing a REST API for a custom table / scoped application in SN?
I am new to SN and I am wondering if this is the right solution for the problem..
Thanks in advance!
