Friday, 11 March 2011

Transaction Service

One way to retrieve data from 3e is to use the GetData method of the Transaction Service.

http://shf01-3ede01/TE_3E_development/WebUI/transactionservice.asmx?op=GetData.

1. In the IDE, create a ReportObject containing the data that is needed.
2. In the IDE, create a Report based on the ReportObject. Add the columns of data that need to be exposed.
3. In the front end, load the Report and save a ReportLayout. Be sure to add any criteria and sorting needed to the associated ReportQuery.
4. To test, open the ReportQuery in the Utilities3E AppObject XML Editor. Use the XML of the ReportQuery as the parameter value of the Transaction Services GetData method.

Note that the Report and ReportQuery are just steps in the creation of the test XML. They can be deleted if they are not needed in the front end.

1 comment:

  1. Hi Dan - we are currently in the process of setting up 3E at our firm, and were looking at Transaction Services. I know this post is ancient, but I was wondering if you ever did further work with them, and especially on the input side. Thanks! - Mike

    ReplyDelete