Support Forum

[Simon H]

We generate a report via the SOAP interface in TS 3.5, but it is not returning any useful data in TS 4.0. We have got the SOAP interface working in TS 4.0 where we can authenticate and create messages. We can also interrogate the list of reports to find the required ReportID. The code we use to run the report is:

Code: Select all

// Run report now we have the ID
  Result := FReportInterface.generateReport(FPostTrackStudio.SessionID
   , LReportID
   , '1'   // Task 1 which is base project.  Report will run for all projects
   , false
   , 'CSV'  // Format returned
   , ','    // CSV deliminator
   , false
   , 'UTF-8'  // One byte per char for our data
   , nil);  // Standard filter parameters

The SOAP call runs without error, but data returned is an array of 10 bytes with every byte has a value of decimal 10. The same data is returned whichever report is run.

Please help!

[admin]

ok, we'll check this.

[admin]

In Java, all works for us

Code: Select all

package test;

import com.trackstudio.soap.service.report.Report;
import com.trackstudio.soap.service.report.ReportDataBean;
import com.trackstudio.soap.service.report.ReportService;
import com.trackstudio.soap.service.user.User;
import com.trackstudio.soap.service.user.UserService;

import javax.xml.namespace.QName;
import java.net.URL;

public class Client {
    public static void main(String[] args) {
        String url = "http://localhost:8080/services/";
        System.out.println("START");
        try {
            UserService service = new UserService(new URL(url + User.class.getSimpleName() + "?wsdl"), new QName("http://user.service.soap.trackstudio.com/", "UserService"));
            User user = service.getUserPort();
            String sessionId = user.authenticate("root", "root");
            System.out.println("Autorization successfully! " + buildReport(url, sessionId));
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static String buildReport(String url, String sessionId) throws Exception {
        ReportService service = new ReportService(new URL(url + Report.class.getSimpleName() + "?wsdl"), new QName("http://report.service.soap.trackstudio.com/", "ReportService"));
        Report report = service.getReportPort();
        String reportID = "ff8080812f059fe8012f05ad46380002", taskId = "1";
        ReportDataBean bean = report.generateReport(sessionId, reportID, taskId, false, "csv", ";", false, "windows-1251", null);
        return new String(bean.getData());
    }
}


[Simon H]

As we are now using SQL Server we are creating reports by querying the database directly rather than using the SOAP interface, so this is no longer an issue for us.