How to retrieve categories for documents

Hi,

This would require some customization since REST allows you to get one object per call only. The customization would be basically the same. Or, have you tried using the WHERE condition in the query string? It depends what exactly you want and how complex the WHERE condition could be.

Best regards,
Juraj Ondrus

Is there a way to view the underlying sql being executed with sql debugging at all?

Answering my own original question here with the REST call I am using if anyone else stumbles on this:

http://localhost/rest/content/fcs/all/news?topn=2&classnames=cms.news&columns=newstitle,newssummary,newsreleasedate,documentId&where=DocumentID IN (SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID IN(6))&orderby=newsreleasedate desc

Thanks Juraj for suggesting the WHERE condition.

Joel,

You can turn on Debugging within the CMS SIte Manager and view all the sql and other things that are being executed.

Hi Guys. Am I correct in assuming there is no accessible REST object for the linkage between a document and a category that will accept a POST request to create a new linkage? The resolution above would indicate such. I am deep in progress of creating an automation process to create site pages in KENTICO from an external database and the key connector I was planning on using to cluster content items was the Categories. It appears that I may need to use cms.relationship REST object instead? Brad

Hi Brad,

The object that holds the relation between the document and the category is the cms.documentcategory:

~/rest/cms.documentcategory

You will need to insert both DocumentID and CategoryID for creation of a new bond.