Hi,
What is the best practice for extending an existing table? Is it possible to add "user-defined" fields to existing tables, (and if so, what are the naming conventions & procedures, etc), or do we need a custom "local table" that has the same key to provide a one-to-one linking between the standard Tessitura table and our local table? If this is the case, then is there any automation provided by the Web API that will return our custom fields, or must I also build local procedures, call those separately, and join the tables logically in code after retrieving the data from the standard Tessitura web API, and our local procedure API call?
One example would be to provide 3 custom fields for the "TR_Facility" table. Tessitura wouldn't use this data anywhere, but we will use it on our web site.
Thank you,
Larry
Like Ken said - check out GetLocalDataEx and UpdateLocalData API methods - as well as ExecuteLocalProcedure (my personal favorite)Also, GetWebContent may prove useful. For example, you could create a content type named 'image' associate that content to a performance or package and enter a URL to a promotional image as the value (/images/logo.png) Then, use this method to return that value which could be used to dynamically display a graphic associated with that performance. Rinse repeat as needed for whatever you like.
Good luck,