RedPrairie On Demand WMS Configuration
- URL to log into front end application
- URL to send Web Service requests to (configured in Connection)
- WSDL location
- Schema definitions for message types (helpful in understanding field names, types, enumerated values, etc. for Web Services)
Note: If you need to connect to the "STDEMO" environment for testing, simply replace services with stdemo in any of the URLs.
Every RedPrairie On Demand WMS Connector call consists of a request message and a response message. When getting data from RedPrairie On Demand WMS, the request message contains selection criteria and the response message contains the resulting data records. When sending data to RedPrairie On Demand WMS, the request message contains the data records to save and the response contains the transaction status with any error messages.
The format of the request and response messages are represented by the Request and Response XML Profiles selected in the RedPrairie On Demand WMS Operation Component. You use these Profiles in Maps to transform to/from other formats.
Getting Data from RedPrairie On Demand WMS
When extracting data, you can narrow the results by specifying criteria. The Request Profiles of "lookup" operations contain a group of fields called criterions. To set a filter for a given field, add three Parameters in the Start Shape or Connector Parameters tab: enter the name of the field to filter by as propertyName, the comparison operator as operator, and the comparison value as stringValue or other appropriate data type.
To filter by two or more fields, modify the XML request Profile for the given Operation, and add additional criterions elements and sub-elements. Don't forget to select the namespace on the Namespaces Tab to match the original criterion. In the Start Shape Parameters or Connector Parameters tab, add additional sets of three Parameters for each filter field.
For example, to perform incremental synchronizations you only want to extract records that have been recently added or changed since the last time the synchronization ran. To do this, add three Parameters: "lastModifiedDate" for propertyName, "greaterThan" foroperator, and a Date/Time Parameter for dateValue field and set the value to the Last Run Date.
Sending Data to RedPrairie On Demand WMS
When importing transactions such as Purchase and Sales Orders, the item master records must already exist or the import will fail. If this is a possibility in your business scenario, you should query RedPrairie On Demand WMS using a Decision shape to make sure the necessary item masters exist and either create the records "on the fly" or reject the transaction.
Sending data to RedPrairie On Demand WMS produces a response message with the result of the import. You should always interrogate the response to determine whether the action completed successfully. Use a Decision step to check that the status field in the response equals "SUCCESS". If it does, the action was successful and you can end the Process. If not, the action failed. You can get the external reference number and error message from the externalRefId and error fields, respectively, to use in a dynamic alert message or exception.
Understanding Date Formats
RedPrairie On Demand WMS Date/Time XML Profile elements should be configured with the following format: