Extracting price for a product

[arthef]

I have been trying this for quite some time and I just cannot find a way or any hints how exactly to do it.
So I have the following 'catalog' yaml:

catalog:
  plans:
    plan:
      - +@name: personal-monthly
        product: Personal
        finalPhase:
          recurring:
            recurringPrice:
              price:
                value: "12.34"
      - +@name: small-monthly
        product: Small
        finalPhase:
          recurring:
            recurringPrice:
              price:
                value: "34.56"

Now, how to extract price's value for product: "Personal"? Any suggestions would be very appreciated.

[mikefarah]

Sure thing:

yq '.catalog.plans.plan[] | select(.product == "Personal") | .finalPhase.recurring.recurringPrice.price.value' file.yaml

Explanation:

• dive into the array .catalog.plans.plan[] - the [] at the end recurses into all the array children
• select the ones with personal product select(.product == "Personal")
• dig into that child to get the value.

Hope it makes sense!

[arthef]

Thanks a lot, works like a charm!