Hello,
We are looking to exploit the functionality in the HTML templates that will allow us to expose data from the API. For context we are looking to get VAT pulled through to an email, and VAT is not natively stored against any of our performances with the exception of being able to identify it by GL codes. We have created a local view which splits the gross, NET (gross - VAT) and donation amount for each Sub Line Item and we are hoping that we can use this data in the email in question.
We don't currently have any internal resource who has experience of this work and it would be good to hear from anyone else in the community who has done work which is similar to this to get your advice on how this can be done.
Best,
Will
One of the easiest ways is to use the REST custom area where you can define a procedure in TR_LOCAL_PROCEDURE. Giving the proc an order# parameter, for example, can bring in any data you would like. Since the data will be coming back as JSON, there will be arrays to deal with and a good C#/Razor person would be needed. I know Tessitura has other resources like developers forums to get started as well.
I suspect that we will be able to get this done with a combination of internal resource, although I do see us struggling with the Razor side of this work. Thanks for the reply that was helpful.