Invalid TCM ID returned when getting a keyword from a keyword's meta using Broker

Question

I have a keyword taxonomy that I'm retrieving from the Broker DB, and the keywords have a metadata schema that includes a link to another keyword.

When I use (pseudocode):

taxonomy = taxonomyFactory.GetTaxonomyKeywords([taxonomyUri] ...)
taxonomy.KeywordChildren.Cast<Keyword>().Select(c => c.KeywordMeta.GetValue("[keywordFieldName]")

I end up with a TCM ID for each keyword's [keywordFieldName] that looks like: "tcm:0-87-1024" - if I check that TCM ID I get a tcm:Error:

Unable to read Keyword

The item tcm:0-87-1024 does not exist.

If I swap the '0' for a '9' everything works fine.

Answer 1

As you say in your comment, the .KeywordChildren part of this is correct and is working elsewhere.

The problem appears to be the the link to another Keyword, from within the Metadata of the original Keyword, does not give the Publication part in the TcmId (i.e. it is returning 'tcm:0-87-1024' instead of 'tcm:9-87-1024' when you are searching in a Category in Publication number 9).

It appears that this is by design.

Looking at Raimond's answer here, where the is a link to a Component from within Keyword Metadata, this also is returning TcmIds in the form tcm:0-<id>

I cannot find anywhere within the online documentation or API documentation where this is described.

I suspect that when you try to get the Keyword, you will have to get the Publication ID part from the Application Settings.

            var keyword = new TaxonomyFactory().GetTaxonomyKeyword(new TcmId(System.Configuration.ConfigurationManager.AppSettings["PublicationID"], keywordId, 1024).ToString());
            //keywordId here would be 87
                if (keyword != null)
                {
                ...
                {