Forum Discussion

bnlucas's avatar
bnlucas
Adept
10 years ago

REST API - Find all forums and boards under category

 I'm trying to build an outline of our categories and the forums and boards associated with them. I have been searching the documentation for about an hour and I cannot figure out how to find forums ...
bnlucas's avatar
bnlucas
Adept
10 years ago

cike - I wasn't the one who set up the boards, so I'm not exactly sure. I have fully figured it out though, something I couldn't find in the documentation anywhere. The LiQL didn't work, it only returns the "board"

 

Using the following, I'm able to get the information:

 

<ul>
<#list rest("/categories?restapi.response_style=view").categories.category as category>
    <li>${category.title}</li>
    <ul>
        <#list rest("/categories/id/${category.id}/boards?restapi.response_style=view").boards.board as board>
        <li>${board.title}</li>
    </#list>
    </ul>
</#list>
</ul>

I found this looking at:

 

SELECT boards FROM categories

Which gives:

SELECT * FROM boards WHERE ancestor_categories.id = '<ID>'

 

cike's avatar
cike
Champion
10 years ago

bnlucas - Using the LIQL query (replace '<ID>' with the category id) should return board object:

 

SELECT * FROM boards WHERE ancestor_categories.id = '<ID>'

These objects could be of any type Lithium provide (e.g. forum, idea, Q&A)

 

Maybe, a screenshot of your community structure (Accessible via Community Administrator) could help to figure out what went wrong.

Could you append such a screenshot?

 

Best regards,

Christian