We are using the default vanilla order confirmation provided in the v8.0 general release and have kept it current thri v8.0.0.2.
We noticed that if there is an alternate seating choice the alternate total price was included in the order as well as the orginal seat choice. This simply shouldn't be. It would be one of the other but not both.
Anyone that can provide/direction it would be appreaciated. The issue is more far reaching than what Tessitura support can provide.
Just to make sure I understand correctly it is a prblem with the WebApi? Or is it a prblem with the email templae that you are using?
If it is an issue with the template you can create a new one to suite your needs. If it is an issue with the data set that is available for the email template to use, you can actually make webapi calls and then append the data to the xml data set, which you can then use in your transform in the XSL.
For example we ran into the problem where super package information was not part of the XML data set. So I did was create a custom stored procedure. Then in the tempate aspx code I made a call to the webapi's execute local procedure method. This called the stored proc, which returned the super package informatin for the order. I then added it to the XML dataset in the template for use in the XSL.
If you would like an example of this I can send you our template.
I have a work around to my issue and Tessitura support is working to have a more perminent solution included in a v9 release.
IS issue boils down to alternate seats that are seated and unpaid which have an sli_status = 2. I commented out this in two locations in the Order Email Sample1_html.xsl which was adding the amounts to the total.