REST Relation with children

is it possible to create an API with all children related?
I have a Category table and Course table.
Each Course belongs to a Category.
I know that is possible to get all from Course with the related Category.
But is it possible to get all Category with the Courses that belongs to it?

Hello @Tva_Tva

Yes, its possible.

You can get all categories, and for all of them invoke find request in Course table with Where Clause like this:

relation.objectId = category.objectId

Where:
relation - the name of the relation column to Category table in Course table.
category - some category in Category table

Each of these requests gives you all courses for a defined Category.

And transform all results into a structure that you need to use.

Regards, Dima.