I was looking at TM Service Guide and I couldn't find service endpoint which can return transaction history XMLs for given transaction reference code.
I want to grab transaction history xmls for audit purpose to store in data warehouse. We want to write a simple client to query transactions for given timeframe first and get the transaction codes. Once we have the transaction details we need all the transaction history records and current documentation for Transaction History API doesn't explain how to get the XMLs.
We need the XML data for each save for following two reasons.
Use of delivery service will mean that we have to push the data into client's system and also there won't be any data available for reports until the transaction is ready for delivery. ie. no of saved applications & audit on them can't be created as report.
It is a much cleaner approach to pull these saved XMLs from Transaction History API into client's infrastructure.
If you can provide an option with out of the box API where we can grab all the History XMLs for given transaction code then it would allow us to create a much scale-able reporting solution. We have infrastructure security applied on the platform and its being assessed by the security team. Our preference is to use PULL mechanism instead of TM pushing these XMLs.
With TM 5.0 if you want to load PII and metadata into a data warehouse I would recommend you use the REST Delivery API. This will provide you with access to the XML data and metadata associated with the transaction.
Please see the KB documentation: Delivery API
To perform a Fluent Delivery Process and then configure REST Delivery API please use the DeliveryResultBuilder in your delivery process. Please see the "Delivery Channel Example".
"REST Delivery Service"