Develop REST API to query on Custom tables

Nandeesh Renukaradhya

Hi,

I would like to develop the Rest API ,which can be used to query custom tables.Does this functionality exists.
If not please guide me how can i do it ?

Ian_Whitfield

Hi,

The typical way of retrieving custom data from Content Server is using a LiveReport node. At the moment there is no Rest API for LiveReports.

If you are licensed for Content Intelligence you can use the WebReports API /api/v1/nodes/{id}/output here: https://developer.opentext.com/webaccess/#url=%2Fawd%2Fresources%2Fapis%2Fcontent-server-v2%23!%2Fwebreports%2FgetWebReportOutput_get_1&tab=501.

The WebReport can be linked to a LiveReport which queries the custom table and returns JSON using the desired mechanism, for example, the INSERTJSON tag.

The only other way at the moment is to create a custom Rest API in oscript as per the following article: https://developer.opentext.com/webaccess/#url=%2Fawd%2Fresources%2Farticles%2F6102%2Fcontent%2Bserver%2Brest%2Bapi%2B%2Bquick%2Bstart%2Bguide&tab=501.

Regards
Ian

HFCDev

I actually built a REST API module that would work for this use case. I originally built it for when I'm writing Web Reports that need to query custom TKL tables when I wasn't satisfied with the WebReports based solution I could do "out of box" (I was forced to trade off between being adaptable or making the report allow dangerous SQL injection - you can do some really bad things with LiveReports). Building REST extensions in Oscript is far easier than extending the Web Services API.

-Hugh Ferguson