Red Prairie On Demand WMS Integration

Document created by gbockelmann Employee on Aug 2, 2012Last modified by admin on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
Apply these connector best practices to your process development.

RedPrairie On Demand WMS Configuration

Important URLs

Note: If you need to connect to the "STDEMO" environment for testing, simply replace services with stdemo in any of the URLs.


AtomSphere Configuration

Understanding Operations

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: