Nested query - How to fetch categories of each product

[agsmartwolf]

Hi, I've added permission and there is only one 'id 'field in response right now. The production environment is effected.

Request is:

response:

Permissions:

[agsmartwolf]

I have a category which includes all of the existed products. I use this approach I could sort products in the dashboard to display all of the products sorted in specific way.

[agsmartwolf]

Guys, do you have any solutions?

[logeshswell]

@agsmartwolf I get your point of sorting all the products by introducing a new category (All Products). But, I am still not clear with the last section.
Do you wish to have,
i) Categories of each product filtered by category_id (or)
ii) Fetch all categories present in your store.

[agsmartwolf]

I want to have all categories for each product.
In the product model, there is a field categories, which includes all categories, which include the current product.

So I fetch a category and want something like this:

category:
    id: string
    slug: string
    ...
    products
        id: string
        ...
        categories: Array<{ name: string; slug: string }>

[logeshswell]

Understood @agsmartwolf. So, you need to use "products.product.categories" which would fetch all categories present in each product.

But, the above solution would work only in backend APIs as we need to open up some permissions for frontend API.

I am not very sure if we can open up permissions for this scenario as it gets deeper into expand attribute instead of fields. But, I will look into it and confirm you in sometime.

[logeshswell]

I found an answer to your query. Please check and let me know if you face any other issues.

First you need to setup the permissions as follows:

{
  "permissions": {
    "categories": {
      "fields": [
        "products.name",
        "products.slug",
        "products.price",
        "products.categories",
        "products.categories.parent"
      ],
      "expands": {
        "products": {
          "url": "/products",
          "params": {
            "categories": "id"
          },
          "data": {
            "expand": ["categories.parent"]
          }
        }
      }
    }
  }
}

Secondly, you can use swell-js to query as follows:

let categoryDetails = await swell.categories.get('624d956b8c83fa0133235e3f', {
  "expand": ["products"]
});
console.log(categoryDetails);

Output:

{
    "sort": 0,
    "slug": "cosmetics",
    "name": "Cosmetics",
    "id": "624d956b8c83fa0133235e3f",
    "products": {
        "count": 1,
        "pageCount": 1,
        "page": 1,
        "results": [
            {
                "id": "61c75dda2280080132420500",
                "name": "Hand bag",
                "slug": "hand-bag",
                "price": 24.95,
                "categories": {
                    "count": 2,
                    "pageCount": 1,
                    "page": 1,
                    "results": [
                        {
                            "parentId": "624c937f9f1c73013cebda59",
                            "productId": "61c75ddb2280080132420b39",
                            "sort": 0,
                            "dateCreated": "2022-09-27T20:26:21.646Z",
                            "id": "63335c6d9796770012147a65",
                            "parent": {
                                "name": "Accessories",
                                "active": true,
                                "slug": "accessories",
                                "dateCreated": "2022-04-05T19:07:43.955Z",
                                "dateUpdated": "2023-01-25T23:41:39.772Z",
                                "sort": 1,
                                "id": "624c937f9f1c73013cebda59"
                            }
                        }
                        {
                            "parentId": "624d956b8c83fa0133235e3f",
                            "productId": "61c75dda2280080132420500",
                            "sort": 0,
                            "dateCreated": "2023-01-05T22:05:42.449Z",
                            "id": "63b749b69bd1a200125bb256",
                            "parent": {
                                "name": "Cosmetics",
                                "active": true,
                                "slug": "cosmetics",
                                "dateCreated": "2022-04-06T13:28:11.980Z",
                                "dateUpdated": "2022-04-06T15:10:49.731Z",
                                "sort": 0,
                                "id": "624d956b8c83fa0133235e3f"
                            }
                        }
                    ]
                }
            }
        ]
    }
}

[agsmartwolf]

@logeshswell
Yeah, it works great, thank you! I've implemented all the logic I wanted with approach you suggested.

[agsmartwolf]

One more question: how to get localized response?
I've tried to add locale parameter, but null is returned.

[agsmartwolf]

@logeshswell

[agsmartwolf]

@logeshswell Could you please help me to get localized response?