'Directus - how to show Many2Many relationship in api

I am trying to make a blog in Directus. I created Blog Collection and Categories Collection. I am using junction table with many to many relationship to connect categories to blog. I can create a new blog post and select category from category collection and I can add a new category also. But when I am calling in api, it is not showing the category field in my rest api call. I can call category endpoint and view the list of all the categories in rest api but in blog collection endpoint, I cant view related category name.

I want to view all the selected category name to each blog posts in my rest api. And I want to view all the blog posts when I call category collection in my rest api by putting category name like projectname/items/categories/aliens/ so I can see all the blog posts of aliens categories.

Currently I am getting this by calling my blog collection in json - 

{
  "data": [
    {
      "id": 1,
      "status": "published",
      "owner": 1,
      "created_on": "2020-03-16 21:15:25",
      "blog_title": "first blog post title",
      "blog_content": "<p>sdlkjfhsdkfol8ysdmfhj sd,fh klsdhf msoiudf oihsdyfghm soreht4,7shetc,oiuh,scenclkr</p>\n<p><strong>dsfgdsfgds</strong></p>"
    }
  ]
}

How to get the category name on rest api ?

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

directus


Solution 1:[1]

Did you try using the fields parameter? This is used to fetch deeply nested relational data:

?fields=*.*.*

In this example, the asterisk is a wildcard for_all_ fields at that relational depth... so this fetches three levels deep.

https://docs.directus.io/api/query/fields.html

Solution 2:[2]

To select only the relational data use

?fields=category.*

This shows only the related category field of the blog article.

Solution 3:[3]

You should have a relational table created between those 2 tables so you should be able to filter the information like this ?fields=id,blog_title,blog_content,category.category_id.category_name,category.category_id.status

In case this is confusing let me try to simplify the relationship part:

category.category_id.category_name
<field_name_on_current_item>.<identifier_on_junction_table_related_to_category_id>.<relation_field_name_to_display>

I realise that this is an old post, but it might help someone looking for the answer.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 RANGER
Solution 2 Robert
Solution 3 Daniel Fanica

Related Questions