How to filter product text by API (jsonadm and graphql) request

[ИванМаксимов]

Please, help me write API request to get long english text for a given product. For graphql or jsonadm API.

I try graphql request (on default demo data):

Code: Select all

"query":"query { getProduct(id:\"15\", include: [\"product/text\"]){ id,type,label,lists{text(listtype: \"default\", type: \"long\") { id, item (languageid: \"en\") { type label languageid } } } }}"

But get error:

Code: Select all

"message":"Unknown argument \"languageid\" on field \"item\" of type \"productliststextOutput\".

I try for just check filtering text attrs feature :

Code: Select all

"query":"query { searchProducts( include: [\"product/text\"], filter: \"{\\\"==\\\":{\\\"product/text.type\\\":\\\"long\\\"}}\" ){ id,type,label,lists{text(listtype: \"default\", type: \"long\") { id, item { type label languageid } } } }}"

or product.text.type
But get error:

Code: Select all

{"errors":[{"message":"Internal server error","locations":[{"line":1,"column":9}],"path":["searchProducts"]}],"data":{"searchProducts":null}}

Env:
"aimeos/aimeos-laravel": 2023.07.01
"laravel/framework": v10.21.0
php 8.1
Docker
Mac

[aimeos]

This should work:

Code: Select all

query {
  searchProducts(filter: "{}", include: ["product/text"]) {
    id
    type
    code
    label
    lists {
      text(listtype: "default", type: "long") {
        id
        item {
          type
          domain
          languageid
          label
        }
      }
    }
  }
}

[ИванМаксимов]

This worked, but i ask about "english" text!
How to filter by languadeid field value?

[aimeos]

You can't. The GraphQL API is for administration purpose only and you can't limit the texts of the product by any property because you need to pass all texts when you save them again. Texts with are not sent in the request are deleted.

[ИванМаксимов]

You can't. The GraphQL API is for administration purpose only and you can't limit the texts of the product by any property because you need to pass all texts when you save them again. Texts with are not sent in the request are deleted.

Ok. What about jsonadm ? By jsonadm API it's possible?

[ИванМаксимов]

And the next question: how to update the content of one text for a product?
Pease, give example request of update one text of existing product

[aimeos]

The JsonAdm API allows updating single items but it's deprecated and you shouldn't use it any more because it will be removed in the future.

With the GraphQL API, you can update all (text) items at once (pass those you didn't modify too, otherwise the will be deleted):

Code: Select all

mutation {
  saveProduct(input: {
    id: "123",
    code: "test"
    label: "Test product"
    lists: {
      text: [{
        type: "default",
        item: {
          content: "...",
          label: "...",
      	  languageid: "..."
        }, {
          // ...
        }
      ] 
    }
  }) {
    id
  }
}

[ИванМаксимов]

Thank you so much!

Code: Select all

mutation {
  saveProduct(input: {
    id: "123",
    code: "test"
    label: "Test product"
    lists: {
      text: [{
        type: "default",

type: "default" <--- is it a list entry type? where can I find out what types are available and what they are for?

[aimeos]

type: "default" <--- is it a list entry type? where can I find out what types are available and what they are for?

Have a look into the "Types > Product lists" panel in admin backend. There you can see the available types and can add your own. They can be used in the frontend for additional grouping of referenced items but for texts, their value is almost always "default" (which you can skip because it's also the default value).