LAPI to CWS API

Hi,

I am looking for CWS api for below LAPI Calls.

1. Lapi Call :
public   int   CreateObjectEx(
                    int       parentVolID,
                    int       parentID,
                    int       objType,
                    int       objSubType,
                    String    name,
                    LLValue   createInfo,
                    LLValue   objectInfo )

I didnot see any api to Create compund document like above.

2. Lapi Call :
public int ListObjects(
                 int         volumeID,
                 int         objectID,
                 String      viewName,
                 String      queryStr,
                 int         permissions,
                 LLValue     children )
Ex : query "DComment LIKE '%" + description + "%' " i know listNodes(id) will get all but i need to process it one by one, with all filters will take time if you have few thousands. Advice any other api will do same.

Find more posts tagged with

Comments

AKropp

Hello Rama,

Have you seen the API Comparison Chart? It can answer a lot of these kinds of questions.

https://knowledge.opentext.com/knowledge/cs.dll/Open/62392906

1 – The available CreateNode methods are capable of creating Compound Documents provided you use them the right way. You need to make sure you’re setting the type. createNodeAndVersion and createNodeAndVersionContext methods are probably better for real-world use. Any node type that has a corresponding OScript-side ServiceNode can be created, though some are easier than others to deal with that’s for sure, and this is system-specific. (There is a registry you can inspect under Services:DocManService:ServiceNodeRegistry you can inspect that will have every registered ServiceNode available in your CS install, though getting there requires Eclipse/CSIDE and a little basic OScript knowledge.)

2 – The API chart specifically calls this one out:

“ListNodes and ListNodesByPage provide generic methods for obtaining a list of children of any container in Content Server. The ListObjects method in LAPI provided consumers of the API with too much power as it allowed for low-level SQL query terms to be provided by the caller. As such, there is no direct replacement for the method in CWS. The goal of ListObjects was to allow the consumer to retrieve a list of direct children of a parent container meeting certain metadata criteria. The ListNodes method in CWS provides this functionality, however, no filtering capabilities are available. ListNodesByPage provides the ability to specify additional filtering criteria, limited to node types, hidden nodes, node names, and pagination.”

Hope that helps.

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Tuesday, October 24, 2017 12:00 PM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: LAPI to CWS API

LAPI to CWS API

Posted by Kolli, Rama On 10/24/2017 11:51 AM

Hi,

I am looking for CWS api for below LAPI Calls.

I didnot see any api to Create compund document like above.

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Content Server:	Knowledge Center CS16

ossie.moore@capspire.com

As noted in other replies, WebSerivces does not allow filtering ListObjects directly. Also as others have noted, you would typically use listNodes or listNodesByPage to iterate over each child node and look for the items that meet your criteria on the client side. While this does work, it also can be cripplingly slow if, for example, you are looking for a single node based on criteria in a folder that contains thousands of nodes.

Here is an option I frequently use to avoid having to fetch every child of a container. It isn’t optimal for all situations but I have used it when the situation made sense. For example, if you are looking for a specific node (or only a few of the child nodes) based on criteria.

Take your scenario, where you want only the child where DCOMMENT is like %whatever%. This qualifies as a scenario where I would consider using this technique.

Create a LiveReport that queries for a batch of children under the container where DCOMMENT is like %whatever%, picking up from the last batch. For example…

SQL: select dataid from dtree where parentid = %1 and dcomment like '%%' || %2 || '%%' and dataid > %3 order by dataid ( I used %% before and after %2 because you need to escape the ‘%’ in a live report query)
Report Format: Auto Live report
Inputs: #1 number parentid, #2 string comment, #3 number next dataid
Max rows: 100
Depending on what you are doing, you might also include the option to honor permissions.

In your web service code, create a List<DataValue> with

IntegerValue (set to the parent dataid)
String Value (set to the comment text you are looking for)
IntegerValue (initialized to a value of zero)

Call the runReport method of DocumentManagement to get a batch of qualifying dataids and create a List<Integer> containing the results.
Call the getNodes(List<Integer>) method of DocumentManagement to get a List<Node> collection.
Do something with your collection of Node(s)
Update the third IntegerValue parameter of your report input List<DataValue> object originally created in step two to be the last dataid in your report results.
Repeat steps 3 through 5 until you get no results.

It is definitely a bit more work, but if you ultimately are only processing a subset of the children of a container, it is many times faster than fetching/paging through every child of a container to find a single (or small number) of child nodes. Another benefit of this method is that you can apply the same technique to page through all content in an entire structure matching your criteria by tweaking the query to join to dtreeancestors and using dtreeancestors.ancestorid instead of dtree.parentid.

Ossie Moore | ossie.moore@capspire.com | 918-605-3581

On Oct 24, 2017, at 11:00 AM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

eLink : LAPI to CWS API
LAPI to CWS API Posted byKolli, RamaOn 10/24/2017 11:51 AM

Hi,I am looking for CWS api for below LAPI Calls.1. Lapi Call :
public   int   CreateObjectEx(
                    int       parentVolID,
                    int       parentID,
                    int       objType,
                    int       objSubType,
                    String    name,
                    LLValue   createInfo,
                    LLValue   objectInfo )I didnot see any api to Create compund document like above.2. Lapi Call :
public int ListObjects(
                 int         volumeID,
                 int         objectID,
                 String      viewName,
                 String      queryStr,
                 int         permissions,
                 LLValue     children )
Ex : query "DComment LIKE '%" + description + "%' " i know listNodes(id) will get all but i need to process it one by one, with all filters will take time if you have few thousands. Advice any other api will do same.
[To post a comment, use the normal reply function]
Forum: Content Server Development Forum
Content Server: Knowledge Center CS16

ossie.moore@capspire.com

Take your scenario, where you want only the child where DCOMMENT is like %whatever%. This qualifies as a scenario where I would consider using this technique.

Create a LiveReport that queries for a batch of children under the container where DCOMMENT is like %whatever%, picking up from the last batch. For example…

SQL: select dataid from dtree where parentid = %1 and dcomment like '%%' || %2 || '%%' and dataid > %3 order by dataid ( I used %% before and after %2 because you need to escape the ‘%’ in a live report query)
Report Format: Auto Live report
Inputs: #1 number parentid, #2 string comment, #3 number next dataid
Max rows: 100
Depending on what you are doing, you might also include the option to honor permissions.

In your web service code, create a List<DataValue> with

IntegerValue (set to the parent dataid)
String Value (set to the comment text you are looking for)
IntegerValue (initialized to a value of zero)

Call the runReport method of DocumentManagement to get a batch of qualifying dataids and create a List<Integer> containing the results.
Call the getNodes(List<Integer>) method of DocumentManagement to get a List<Node> collection.
Do something with your collection of Node(s)
Update the third IntegerValue parameter of your report input List<DataValue> object originally created in step two to be the last dataid in your report results.
Repeat steps 3 through 5 until you get no results.

Ossie Moore | ossie.moore@capspire.com | 918-605-3581

On Oct 24, 2017, at 11:00 AM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

eLink : LAPI to CWS API
LAPI to CWS API Posted byKolli, RamaOn 10/24/2017 11:51 AM

Hi,I am looking for CWS api for below LAPI Calls.1. Lapi Call :
public   int   CreateObjectEx(
                    int       parentVolID,
                    int       parentID,
                    int       objType,
                    int       objSubType,
                    String    name,
                    LLValue   createInfo,
                    LLValue   objectInfo )I didnot see any api to Create compund document like above.2. Lapi Call :
public int ListObjects(
                 int         volumeID,
                 int         objectID,
                 String      viewName,
                 String      queryStr,
                 int         permissions,
                 LLValue     children )
Ex : query "DComment LIKE '%" + description + "%' " i know listNodes(id) will get all but i need to process it one by one, with all filters will take time if you have few thousands. Advice any other api will do same.
[To post a comment, use the normal reply function]
Forum: Content Server Development Forum
Content Server: Knowledge Center CS16