Custom Knowledge Table with custom REST API

miteran4o — Wed, 09 Oct 2024 06:37:55 GMT

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!

question Custom Knowledge Table with custom REST API in Community Central forum

Custom Knowledge Table with custom REST API