REST - Getting valid_values from table key lookup column

Hi,
We have a field with numerous opions of valid values. Before, these values were entered in the field itself, and came by as an array from the valid_values property on the columns.

Now they are in a table key lookup field and stored in the database. When I look at the valid_values property, it's now the string select statement per the lookup. Is there anyway to get those values back per how they are stored in the database and not the select string itself?

Thanks
Frank

Find more posts tagged with

Comments

Jeremy Naylor

There may exist a way to handle this, but it depends on the type of TKL that you are using, Are you using Attribute Extension TKL, or Automatic Document Numbering TKL?

André_Roy

Hi Frank,

If you are using Content Server 16.2, this is possible with Attribute Extensions. The Table Key Lookup functionality was added to the Smart UI in 16.2, therefore the underlying REST functionality was also added.

In order to get a list of valid values, you can construct a POST request to this URL: /cs.exe/api/v1/tklattribute/validvalues

You must pass an ‘id’ and ‘attribute_key’ parameters in the Body. The id is the NodeID and attribute_key will point to the specific attribute which is your TKL.

The fact that you see the SELECT statement in your valid_values leads me to believe you are using CS 10.5 or 16.0.

Regards,
Andre Roy

Beaty_Frank

The build version is listed as "Content Server 16.0.4 (2017-03), build 1282"

How do I tell what type of lookup field it is? The type is just listed as "Text: Table Key Lookup" on the "edit attribute" screen of the category.

Otherwise, I get the information currently through calling:

$config.csUrl + '/otcs/llisapi.dll/api/v2/nodes/' + nodeId + '?fields=categories&metadata

Thanks!
Frank

Jeremy Naylor

Thats an Attribute Extensions TKL, so the suggestion that Andre provided should work. ADN TKL are labeled as Text: ADN Table Key Lookup.

For completeness, 16.1.1 of ADN includes a webservice and REST API for calls. Not much yet in regards to documentation, but probably will be forth coming in the future.

Beaty_Frank

Ok, so I found the tklattribute node in rest: https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=67789539&objAction=browse

Wrote up a quick call:
function LoadValidValues(nodeId, attrId) {
   return $http({
                method: 'POST',
                url: $config.csUrl + '/otcs/llisapi.dll/api/v1/tklattribute/validvalues',
    data: {
     id: nodeId,
     attribute_key: attrId
    },
    headers: {
     OTDSTicket: $auth.Ticket()
    }
            }).catch(function (err) {
                 alert("Error: " + err.data);
            });
  }

and am getting a 400 error, which per the error description is listed as "The REST API URL could not be found in the mappings registry".

Any idea what I'm **** up?

Thanks
Frank

André_Roy

If you are using CS 16.0.x, then it is not possible unfortunately. This functionality was only added in CS 16.2. If you compare the REST API documentation for 16.0 vs 16.2, you will notice that the ‘tklattribute’ is missing, as well as some other key differences.

If you know the SQL query that the table key lookup uses, perhaps you can fetch the values using ajax? Otherwise you would need to upgrade to Content Server 16.2 in order to utilize the REST api.

Regards,
Andre Roy