BIP - Web Service

About

Getting Started with BIP Web Service

WSDL

Web Services - Description Language (WSDL)

http://<host>:<port>/xmlpserver/services/PublicReportService?wsdl

Generate Stub Classes

How to generate the BI Publisher Stub Classes

import com.oracle.xmlns.oxp.service.PublicReportService.ItemData;
import com.oracle.xmlns.oxp.service.PublicReportService.ReportRequest;
import com.oracle.xmlns.oxp.service.PublicReportService.ReportResponse;
import com.oracle.xmlns.oxp.service.PublicReportService.ParamNameValue;
import com.oracle.xmlns.oxp.service.PublicReportService.ReportDefinition;
import com.oracle.xmlns.oxp.service.PublicReportService.ScheduleRequest;
import com.oracle.xmlns.oxp.service.PublicReportService.DeliveryRequest;
import com.oracle.xmlns.oxp.service.PublicReportService.EMailDeliveryOption;

With Eclipse

With Axis command line

Classpath

Include the following jar files in your classpath

  • activation.jar from the Java Activation Framework (1.1.1)
  • mail-1.4.jar from Java Mail
  • xmlpserver.jar. The Oracle BI Publisher API. (Ensure that all the required request and response objects are present and that it's not needed to generate response and request stub objects)

With the linux find command, you will find xmlpserver.jar:

find OracleBI_Home -name xmlpserver.jar
OracleBI_Home/oc4j_bi/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib/xmlpserver.jar

Operation

validateLogin

Enveloppe:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
   <soapenv:Header/>
   <soapenv:Body>
      <pub:validateLogin>
         <pub:userID>gerar600bip</pub:userID>
         <pub:password>gerar600bip</pub:password>
      </pub:validateLogin>
   </soapenv:Body>
</soapenv:Envelope>

Java Class:

import java.net.URL;
import javax.xml.namespace.QName;
import javax.xml.rpc.ParameterMode;
import org.apache.axis.client.Call;
import org.apache.axis.client.Service;
import org.apache.axis.encoding.XMLType;

public class ValidateLogin {

    public static void validateLogin() throws Exception {

	final String bipEndpoint = "http://bipserver:bipserverport/xmlpserver/services/PublicReportService";
	final String bipNamespace = "http://xmlns.oracle.com/oxp/service/PublicReportService";
	// final String reportPath = "/HR Manager/Employee Salary Report/Employee Salary Report.xdo";

	Service service = new Service();
	Call call = (Call) service.createCall();
	call.setTargetEndpointAddress(new URL(bipEndpoint));

	System.out.println("TESTING login Service BEGIN");
	
	// Operation definition
	call.setOperationName(new QName(bipNamespace, "validateLogin"));
	call.addParameter("userID", XMLType.XSD_STRING, ParameterMode.IN);
	call.addParameter("password", XMLType.XSD_STRING, ParameterMode.IN);
	call.setReturnType(XMLType.XSD_BOOLEAN);

	// issue the request
	Boolean valid = (Boolean) call.invoke(new Object[] {
		"gerardnico",
		"gerardnico"
	});

	if (valid) {
	    System.out.println("user valid");
	} else {
	    System.out.println("user invalid");
	}
	System.out.println("Success for validateLogin");
    }

    public static void main(String[] args) throws Exception {
	
	validateLogin();

    }
}

Output:

TESTING login Service BEGIN
user valid
Success for validateLogin

Documentation / Reference


Powered by ComboStrap