Hey,
I was hoping someone might be able to point me to a resource where Tessitura stored procedures are defined and listed details on each. Specifically, I am looking for the stored procedure that updates a users address/info from the "Edit Your Account Information" TNEW page (/account/account.aspx). The procedure name would be nice, but having a resource for the future would be even better.
If anyone can point me in the right direction (or knows the name of the procedure I'm looking for), I'd greatly appriciate it.
Thank you in advance.
I'm afraid none such exists, nor is likely to. Doing so would imply some sort of contract about the format and behavior of the stored procedures, and Tessitura routinely changes those. The REST API is where they will be creating a documented interface for end users to build custom functionality.
Full disclosure: I continue to do almost all of my customization work in SQL. I'll do some digging to try and figure out how Tessitura handles a problem with their stored procedures at times, but I rarely use them, as it's easier to keep track of changes in tables than in everything else.
There are a handful of convenience procedures and functions specifically for end users, mostly for things like finding the best mailing address. I think they may be in the standard documentation somewhere.
Gawain,
I appreciate your help, if could track the procedure down, please let me know. I too like to work in SQL, but, like you said, documentation for TNEW-facing SQL ranges from poor to non-existent. However, it's really the only way you can provide custom functions without developing a full API site. Kind of puts us in an awkward position.
I could be wrong, but doesn't TNEW make use of the SOAP API? Maybe I could look through the documentation on SOAP too see if there is anything worthwhile.
At any rate, keep me posted, and thank you!
Unknown said: I could be wrong, but doesn't TNEW make use of the SOAP API? Maybe I could look through the documentation on SOAP too see if there is anything worthwhile.
That might be a good place to start, although to be sure TNEW is aggressively abandoning the SOAP API.
As Tessitura's primary ecommerce solution, we're excited that TNEW v7 is using more REST API requests than SOAP, and we will continue to expand REST usage across the application. As a result, it's very important that organizations have their REST API in order prior to a v7 installation or upgrade. This means making sure that you have working REST credentials and proper security permissions for the web user to carry out its functions. http://www.tessituranetwork.com/network/About/Network%20News/Articles/December%202016%20Web%20Products%20Update.aspx?utm_source=WebProductsUpdate&utm_medium=email&utm_campaign=December2016#rest
As Tessitura's primary ecommerce solution, we're excited that TNEW v7 is using more REST API requests than SOAP, and we will continue to expand REST usage across the application. As a result, it's very important that organizations have their REST API in order prior to a v7 installation or upgrade. This means making sure that you have working REST credentials and proper security permissions for the web user to carry out its functions.
http://www.tessituranetwork.com/network/About/Network%20News/Articles/December%202016%20Web%20Products%20Update.aspx?utm_source=WebProductsUpdate&utm_medium=email&utm_campaign=December2016#rest