Query Service Request WSDL Configuration - j5 - 28.0 - Administration & Configuration - Hexagon PPM

j5 Maximo Integration Configuration

PPMProduct
j5
PPMCategory_custom
Administration & Configuration
Version_j5
2019

The j5 Maximo interface queries Maximo for Service Requests using a SOAP web service exposed by Maximo. The WSDL URL of this web service is captured in the Service Request Query WSDL URL field. If a SOAP service is configured off the default Service Request object (MXSR), then the WSDL URL will be as follows:

http://<server name>:<port name>/meaweb/services/MXSR?wsdl

In some versions of Maximo, when a third party application calls the SOAP service for querying service requests that has been configured from the standard Service Request object, Maximo returns a Constructor Error message. This is a defect in Maximo and is logged as APAR IJ05279 - Error using Web Service in Maximo 7.5.0.6 (IBM Ticket #: TS000804214). IBM has released a patch that addresses this issue. It may be necessary to apply the patch in order to use the out of the box web service.

The Service Request Query Service URL is the URL j5 calls when calling the query operation in the WSDL. This Service URL is usually defined in the WSDL but Maximo can be configured to expose a different URL hence why this is a separate configuration point. If a SOAP service is configured off the default Service Request object (MXSR), then the service URL will be as follows: http://<server name>:<port name>/meaweb/services/MXSR

Read more about how to find the Service URL for a web service in the section on Finding the Service URL for a web service.

The Service Request Query Operation is the common text in the web service operations on the WSDL for querying service requests. For example, if the web service operations are "CreateMXSR", "DeleteMXSR", "QueryMXSR" etc, then Service Request Query Operation is "MXSR".

The SOAP identifier for Service Request Set is the SOAP element that contains the list of service requests, for example MXSRSet.

The Service Request Identifier is the unique identifier of a service request in the Maximo table. It is important that this field is a unique integer as it is used to iterate through the data set of service requests during a full synchronization. This field is also used as a unique identifier of service requests in the j5 Service Request logbook.

Service Request Query Filter is a filter condition that allows the interface to exclude a subset of service requests from the synchronization. This is of the form of a SQL WHERE clause. For example, FIELDX IS NOT NULL.

SQL query to fetch the Service Request record with the maximum ID is used by the batch processing during the full synchronization with Maximo to identify the maximum of the Service Request Identifier. This maximum bounds the j5 synchronization in order to identify when the operation is complete.

Service Request Date Changed Field is the field on the service request that identifies the last date and time that the service request was modified in Maximo. This is used to identify the change set during the incremental synchronization.