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
I wondered if anyone was actually using a stored procedure to pull in 'custom' data to an HTML template, and if so if you would be happy to share the block of code that enabled you to do this?
Will Mercer said:I wondered if anyone was actually using a stored procedure to pull in 'custom' data to an HTML template, and if so if you would be happy to share the block of code that enabled you to do this?
I asked about this on the Slack channel a while back, and Justin from the network helpful supplied a sample:
https://tn-webshare.slack.com/archives/C02GE71RP/p1559581590012400?thread_ts=1559578631.012300&cid=C02GE71RP
I've gotten about as far as seeing some data in my order conf via a sproc, but was pulled away to another task at that point. Will be returning to it, soon, though. A discussion specifically about doing this further, specifically in in order confs, would be a discussion I would be very interested in.