How to update this part of the code to extract metafields values correctly? Or what to paste to the edit query instead? { “query”: { “objectType”: “product”, “id”: “product.id”, “metafields”: [ { “namespace”: “my_fields”, “key”: “style1” }, { “namespace”: “my_fields”, “key”: “year” }, …

This gets the metafield by namespace/key and outputs the value. “first” is needed because “where” returns a list. {%- assign mf_object = product.metafields | where: "namespace", "my_fields" | where: "key", "pattern" | first -%} {{ mf_object.value }}

Look at the example queries and the search syntax. You don’t need to build the whole query … just the query string

To add… Shopify’s product query does not allow searching by metafields yet. https://shopify.dev/docs/api/admin-graphql/2023-07/queries/products#argument-products-query What are you trying to do in your workflow?

Pass data from metafields to Open AI for text generation.

Yes, but hot to take a date from Metafields? I don’t need all of them.

You might not need a query for this. When should the workflow run? Once you have a product in the workflow, you can access all of it’s metafields in liquid directly in the OpenAI action

See https://community.shopify.com/post/1826703 for some code

I know, but how to filter them out? Because they look like this: [Screenshot 2023-07-20 201738.png]

I’m not sure where / how you want to filter them out. If you mean access a single value in liquid, my preferred approach is like this: {%- assign mf_object = product.metafields | where: "namespace", "custom" | where: "key", "color" | first -%} If you mean in a condition, here’s example example for…

Things are more complex in my case. I am already checking if the required values are in the product: [Screenshot 2023-07-20 214147.png] Then I need to pass exact metafields variables to the Ai prompt here, not just one specific value, to generate a product description based on different parameter…

I’m not sure what you mean by “variables”. I think, b/c of that screenshot, you want all of the possible values for the metafield in that Open AI prompt? That isn’t a metafield value, but I think a metafield definition. I think the choices are stored in validations. You might need to use GraphiQL or…

How can I correctly extract metafields values in JSON code?

Shopify Plus

AndrewLeb July 20, 2023, 5:17pm 8

I know, but how to filter them out? Because they look like this:

Topic		Replies	Views
Query metafields value Graphql Basics And Troubleshooting troubleshooting , Setting-Up	1	69	February 9, 2024
Querying productvariants by metafields in GraphQL Technical Q&A	7	1048	October 2, 2024
Can we fetch products using their metafields? Technical Q&A	0	42	November 20, 2023
Pull Metafields and products without the API Metafields	6	259	February 19, 2022
Graphql query with metafields is returning all the product. Shopify Discussion troubleshooting	2	117	April 1, 2025

How can I correctly extract metafields values in JSON code?

Related topics