Is there a REST Call for all Categories on server like attributes.dump in the UI

Hi all!

I am searching for a REST CALL to get all Categories. I am searching for a call which results more or less all Categories on the Server

As example when I am using this

func=attributes.dump

in the UI I am getting a visual display of ALL Categories.

Reason for that is, that I have a template (15483714) and in this template I have some folders.

The category is not on the main template it is inside a subfolder of the template.

For example this GET

api/v1/nodes/15483714/categories

is valid but returns nothing because the catorgies are on my subfolder.

{"data":[],"definitions":{"id":{"key":"id","name":"ID","persona":"node","type":2,"width_weight":0},"name":{"key":"name","name":"Name","persona":"","type":-1,"width_weight":100}},"definitions_map":{"name":["menu"]},"definitions_order":["name"]

Is there a quick solution, or what do i miss ?

Cheers Ch

ps: I also can life with a Call which returns all Categories on the server.

Find more posts tagged with

Comments

Appu Nair

To find all categories in a system the following query as in a LR can be used

select Name,DataID,OwnerID from DTree where SubType=131
The OwnerID is the way you can distinguish if it is in the categories Volume(which by default is 2004 but can be different)

For each result of the DtaId using an API like SOAP /Oscript or WR Tag you can find out what its attributes are its length whether MVA, MVSET and so on.

If REST does not fully support your use case what you can do is to wrap these intelligently as a WR then piggy back on the WR REST call as WR has an easy way to get this info.

Hopefully that is what your question is ..

Appu Nair

When you ask a DataID do you have MetaData Oscript code gets the Category DataId and puts it into groups. Each Group that is returned is a representation of the Cat Data Structure(comes from definition and not a table) and Data(Which comes from LLAttrDataBlob).To the receiver like your REST client, it looks everything is a DB Transaction it is not actually.

The Oscript RH attributes.dump you posted is executing a similar query for rounding up categories, and providing you a formatted HTML output it is not because that Category is applied to a node like a Folder or Document.

HFCDev

If you do the query that @Appu_Nair suggested, and you can wrap it in a WebReport, you can always use the REST API for WebReports to get thedata you need. This way, you can tailor the output to as much or as little as you need. It's a bit of a kludge that you have to go about getting the info this way. As I recall, WebServices (SOAP) API had a command to get info about specific categories but not one that listed them all out.

-Hugh

Mchoeti

HI guys thanks for the feedback i will test that when i am back in the office. thanks.

Appu Nair

I wrote in this a while back to help a friend I used WR to do this the main thing was in a forum by the great @Greg Petti
https://forums.opentext.com/forums/support/discussion/297694/category-attribute-details-question

I did not go as far as implementing the rest layer but in my years of employment in many places I have altered/written code to attributes.dump to create simple tables integrators can query on.

I think all I did was do something like select Top100 from DTree where SubType=131 as I was working in a system that had in excess of 14 K categories.