Status: Open
Status: Answered
Status: Closed
Status: Duplicate

Develop REST API to query on Custom tables

0
Posted Jan 16 by 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 ?

2 Answers

0
BEST ANSWER: As chosen by the author.

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


0
BEST ANSWER: As chosen by the author.

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.<br/>
-Hugh Ferguson


 You have subscribed and will receive email notifications of updates to this topic. To unsubscribe, uncheck the checkbox.

Statistics

Related categories

Related tags

Your answer

To leave an answer, please sign in.