Is it possible to read and update entries in a user-defined lookup table (a lookup for a category attribute) using the Content Server Web Service API?
Hi, are you talking about Table Key Lookup attributes on categories? Unfortunately, this functionality is not supported by Content Web Services.
Yes, that is what I mean.
Just to double-check - suppose I have a table key lookup attribute called "Color" on my category. Then I have values in that lookup table "Blue", "Green", "Red". If I would like to add "Purple" to that list, or change "Green" to "Orange", is it possible through CWS?
Table Key Lookup values are stored in custom database tables. If you have programmatic access to the database then you can make direct modifications to the tables without having to go through CWS.
I believe that Web Services (CWS) should allow you to execute a LiveReport (correct me if wrong) already - you just need to write a LR that exposes the table in question. But CWS is a different beast from the REST API, and is typically accessed using .NET or Java.
<
p> If you need this functionality exposed as a REST API (i.e. for access from jQUery, AngularJS, Backbone, or good ole' fashioned Javascript) then there is currently no REST API that exposes this. I have had great success building extended REST API's when the core ones don't have the desired functionality. I could always write a REST API Wrapper for SQL or LiveReports for your company if need be.
p>UPDATE (2015-08-18) I had some time today so I built a quick prototype of a REST Wrapper for LiveReports. If this is something that is of interest, I could develop it further, and any SQL that is used for TKL attributes that has a LiveReport written for it, can be accessed from your REST client. -Hugh Ferguson, President Hugh Ferguson Consulting Ltd.
Tomas, thanks for the information. Hugh, thanks for the tip about LiveReports and for the offer of help. We don't need a REST API actually. We're creating a .NET application that invokes CWS.
