3

I'm having a problem with the GraphQL API for Magento 2. I cannot retrieve the attribute value of multiselect or dropdown attributes when I retrieve my products.

In this example my attribute "material" returns an integer of the value ID instead of the textual value. I'm currently using the endpoint https://devdocs.magento.com/guides/v2.3/graphql/reference/custom-attribute-metadata.html to retrieve all the option values, but this is not very efficient.

{
  products(
    search: "Chair"
    pageSize: 10
  )
  {
    total_count
    items {
      name
      sku
      material
      price {
        regularPrice {
          amount {
            value
            currency
          }
        }
      }
    }
    page_info {
      page_size
      current_page
    }
  }
}

returns:

{
  "data": {
    "products": {
      "total_count": 48,
      "items": [
        {
          "name": "Brown Chair",
          "sku": "4203894",
          "material": 209,
          "price": {
            "regularPrice": {
              "amount": {
                "value": 89,
                "currency": "EUR"
              }
            }
          }
        },
    .......

Is there a way to get the textual value of the "material" attribute ("Leather") in this call?

1

From Native GraqpQl we cannot get the expected result.But we can write a custom module with the graphql and achieve it.What my suggestion is get the product detail by sku using _productRepository->get($sku);. This will return the entire product details.So you can get the attribute data by using $attributes = $_product->getAttributes(); Here is my data provider file

/**
 * @params string $sku
 * this function return all the product data by product sku
 **/
public function getProductBySku($sku)
{
    return $this->_productRepository->get($sku);
}
/**
 * @params int $id
 * this function return all the word of the day by id
 **/
public function getAttributesBySku( $sku ){
    $_product = $this->getProductBySku($sku);
    $attributes = $_product->getAttributes();// All Product Attributes

    $attributes_data = [];
    $x=0;
    foreach ($attributes as $attribute) {
        if($attribute->getIsUserDefined()){ // Removed the system product attribute by checking the current attribute is user created
            $attributeLabel = $attribute->getFrontend()->getLabel();
            $attributeValue = $attribute->getFrontend()->getValue($_product);

            if($attribute->getAttributeCode()=="language"){
                $attributeLabelAndValue = $attributeLabel." - ".$attributeValue;
                $attributes_data[$x]['atr_data'] = $attributeLabelAndValue;
            }
        }
        $x++;
    }
    return $attributes_data;
}

this code will return the need

$attribute->getFrontend()->getLabel(); this will return the label and 
$attribute->getFrontend()->getValue($_product); this will return the value.

To check the entire graphQl query and resolver file kindly view How to get product attribute value, label using GraphQl in Magento 2.3?

Hope this will help you.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.