N1QL : Getting deep nested child element from array

Hi,

How do I get the name of the configurations -> name. configuration is like this. document -> experiences -> features -> configurations.

I am having index on key_tx.

{
      "effective_timestamp": "2020-01-23T00:00:00Z",
      "end_timestamp": "9999-12-31T00:00:00Z",
      "experiences": [
        {
          "available_to": "AUTHORIZED-USER",
          "values": [
            {
              "features": [
                {
                  "embedded": true,
                  "identifier": "bcb3c0d0-ee4a-4bf8-8df5-42af12535310",
                  "legal_names": [
                    {
                      "language": "en",
                      "value": "membership"
                    }
                  ],
                  "name": "membership",
                  "terms": [
                    {
                      "identifier": "b3a7b3da-199f-4dd1-9651-9a173cf66295",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "Credit Limit"
                        }
                      ],
                      "name": "credit-limit",
                      "values": [
                        {
                          "maximum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 5000,
                              "currency": "AUD"
                            }
                          },
                          "minimum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 3000,
                              "currency": "AUD"
                            }
                          }
                        }
                      ]
                    },
                    {
                      "identifier": "29be8e0e-a03c-4541-88b4-ee3400a277dd",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "Credit Limit"
                        }
                      ],
                      "name": "credit-limit",
                      "values": [
                        {
                          "maximum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 5000,
                              "currency": "AUD"
                            }
                          },
                          "minimum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 3000,
                              "currency": "AUD"
                            }
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "embedded": true,
                  "identifier": "09603ad0-5d5e-4745-8b78-1d933c033da5",
                  "legal_names": [
                    {
                      "language": "en",
                      "value": "membership"
                    }
                  ],
                  "name": "plan-it",
                  "terms": [
                    {
                      "identifier": "144a50dc-ffbf-4133-a317-281862bed075",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "Credit Limit"
                        }
                      ],
                      "name": "credit-limit",
                      "values": [
                        {
                          "maximum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 5000,
                              "currency": "AUD"
                            }
                          },
                          "minimum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 3000,
                              "currency": "AUD"
                            }
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "embedded": true,
                  "identifier": "9de4a8aa-23eb-4c58-8597-e53e89c28431",
                  "legal_names": [
                    {
                      "language": "en",
                      "value": "membership"
                    }
                  ],
                  "name": "membership",
                  "terms": [
                    {
                      "identifier": "e6f2bd6c-fc90-497a-98e7-ed0560aefc1a",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "Credit Limit"
                        }
                      ],
                      "name": "credit-limit",
                      "values": [
                        {
                          "maximum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 5000,
                              "currency": "AUD"
                            }
                          },
                          "minimum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 3000,
                              "currency": "AUD"
                            }
                          }
                        }
                      ]
                    },
                    {
                      "identifier": "2b50ee2f-578c-4ed2-84b1-d87238462d8b",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "Credit Limit"
                        }
                      ],
                      "name": "credit-limit",
                      "values": [
                        {
                          "maximum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 5000,
                              "currency": "AUD"
                            }
                          },
                          "minimum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 3000,
                              "currency": "AUD"
                            }
                          }
                        }
                      ]
                    }
                  ]
                }
              ],
              "identifier": "d536c25d-aef5-499f-a6cd-cb646b82e625",
              "name": "American Express® Platinum Credit Card"
            }
          ]
        },
        {
          "available_to": "OWNER",
          "values": [
            {
              "features": [
                {
                  "embedded": true,
                  "identifier": "703f11f2-f22a-4681-873e-ea02c71bda91",
                  "legal_names": [
                    {
                      "language": "rs",
                      "value": "membership"
                    }
                  ],
                  "name": "membership",
                  "terms": [
                    {
                      "identifier": "d26a7afb-548b-4894-8a5f-953bdf7c9725",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "Credit Limit"
                        }
                      ],
                      "name": "credit-limit",
                      "values": [
                        {
                          "maximum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 5000,
                              "currency": "AUD"
                            }
                          },
                          "minimum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 300,
                              "currency": "AUD"
                            }
                          }
                        }
                      ]
                    },
                    {
                      "identifier": "7d950a23-2e68-41f9-b63a-37ae3e3e8a1e",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "Credit Limit"
                        }
                      ],
                      "name": "limit",
                      "values": [
                        {
                          "maximum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 5000,
                              "currency": "AUD"
                            }
                          },
                          "minimum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 300,
                              "currency": "AUD"
                            }
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "embedded": false,
                  "identifier": "55cd5cca-a84c-432d-8046-59aa096c45bb",
                  "legal_names": [
                    {
                      "language": "en",
                      "value": "Plan It"
                    }
                  ],
                  "name": "plan-it-amount",
                  "related_features": [
                    {
                      "context": "PARENT",
                      "identifiers": [
                        "4f5ebd6b-3c41-4604-a3b7-11e870de1f0c"
                      ]
                    }
                  ],
                  "terms": [
                    {
                      "identifier": "baa650b8-3413-49cb-8ed9-280c5c43ea7f",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "minimum-plannable-amount"
                        }
                      ],
                      "name": "minimum-plannable-amount",
                      "values": [
                        {
                          "minimum": {
                            "calculation_method": "FIXED-AMOUNT",
                            "fixed_amount": {
                              "amount": 100,
                              "currency": "AUD"
                            }
                          }
                        }
                      ]
                    },
                    {
                      "identifier": "51180d67-5f91-43a8-a5fa-9754f691777d",
                      "legal_names": [
                        {
                          "language": "en",
                          "value": "percentage-of-statement-balance"
                        }
                      ],
                      "name": "percentage-of-statement-balance",
                      "values": [
                        {
                          "maximum": {
                            "calculation_method": "PERCENTAGE",
                            "percentage": {
                              "of": "statement-balance",
                              "value": 85
                            }
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "configurations": [
                    {
                      "applicable_to": "4f5ebd6b-3c41-4604-a3b7-11e870de1f0c",
                      "category": "feature",
                      "identifier": "c99636eb-9c44-48ca-9d3f-d28bf71604cf",
                      "name": "offer-id",
                      "values": [
                        {
                          "values": [
                            {
                              "value": "860000004"
                            }
                          ]
                        }
                      ]
                    },
                    {
                      "applicable_to": "4f5ebd6b-3c41-4604-a3b7-11e870de1f0c",
                      "category": "feature",
                      "identifier": "8b4cb7f8-7ef6-4b54-9e9a-9fef5212f9f0",
                      "name": "plan-it-eligibility",
                      "values": [
                        {
                          "jurisdiction": {
                            "category": "COUNTRY",
                            "name": "AU"
                          },
                          "values": [
                            {
                              "value": "include"
                            }
                          ]
                        }
                      ]
                    }
                  ],
                  "embedded": false,
                  "identifier": "4f5ebd6b-3c41-4604-a3b7-11e870de1f0c",
                  "legal_names": [
                    {
                      "language": "en",
                      "value": "Plan It"
                    }
                  ],
                  "name": "plan-it",
                  "related_features": [
                    {
                      "context": "CHILD",
                      "identifiers": [
                        "55cd5cca-a84c-432d-8046-59aa096c45bb"
                      ]
                    }
                  ]
                }
              ],
              "identifier": "e2d2f9ce-ab39-4575-8752-876e0b0f5b0b",
              "legal_names": [
                {
                  "language": "en"
                }
              ],
              "name": "American"
            }
          ]
        }
      ],
      "jurisdiction": {
        "category": "COUNTRY",
        "name": "AU"
      },
      "key_tx": "ARNG_CMP_ARR::test::V1",
      "version": "V1"
    }
SELECT  f.configurations
FROM default AS d
UNNEST d.experiences AS e
UNNEST e.`values` AS v
UNNEST v.features AS f
WHERE f.configurations IS NOT MISSING;