How to get all normal keywords inside nested keywords?

Question

We need to get all the normal keywords inside the abstract keywords: for example we have 2 normal keywords hotelA and HotelB:

• hotel(category)
• United States (abstract keyword)
  • North Dokota (abstract keyword)
    • Fargo(abstract keyword)
      • HotelA (normal keyword)
      • HotelB (normal keyword)

How can we get keyword of hotelA and HotelB using the tcm id of United States using coreservice client?

Answer 1

In general, to get a list of items related to some subject, you can use the Core Service methods GetList (returns Data Objects) or GetListXml (returns so-called R5 XML).

Specifically, to get a list of child Keywords, you use one of those methods in combination with a filter of type ChildKeywordsFilterData.

If you only want to get the "normal"/"concrete" (i.e. not abstract) Keywords, you can specify ChildKeywordsFilterData.IsAbstract = false.

Answer 2

the solution which i have written will be a recursive function which is not effective but it works.

public static IEnumerable<XElement> getChildKeywords(string tcmId)
            {
                var normalkeywordFilter = new ChildKeywordsFilterData() { IsAbstract = false };
                var normalKeywords = client.GetListXml(tcmId, normalkeywordFilter).Elements().ToList();
    
                if (normalKeywords.Count() != 0) return normalKeywords;
    
                var allabstractKeywords = con.client.GetListXml(tcmId, new ChildKeywordsFilterData() { IsAbstract = true }).Elements().ToList();
                foreach (var el in allabstractKeywords)
                {
                    normalKeywords.AddRange(getChildKeywords(el.Attribute("ID").Value).ToList());
                }
    
                return normalKeywords;
            }