Data sent to Warehouse Online
To send messages to Warehouse Online (push messages) you need to use an HTTP client. Our default data format is JSON. A Warehouse Online implementation consultant will prepare an account that can be used and a REST endpoint for each data flow to which messages can be send. Every data flow has its own identification. In the example below you see an example of the REST endpoint with data flow id 123456:
https://p1.realtime.eu/rest/dataflow/@123456/message
The message itself will be transferred using the HTTP request body. Make sure to set at least the following HTTP request headers if you send a message to our API:
Content-Type: application/json
Accept: application/json
Authorization: Basic d2V0cm9uLFdFVC0xNDphYmMxMjM
You will receive an error message when somenthing went wrong.
After processing your message correctly, you will receive:
{
"type": 0,
"message": "import successful"
}
When connecting to an ERP system, Warehouse Online expects three data flows:
- Product import
- Sales order import
- Purchase order import
In this document you will find the JSON schema for these three data flows and also an example for every data flow.
A Warehouse Online Consultant can prepare the following customizations if desired:
- A pull mechanism instead of a push mechanism. If your system can not push messages to one of our REST endpoints, Warehouse Online can access your system and retrieve the required data. This will be easy when your system has an standardized API and more complex when the connection needs to be custom build.
- A different form of transportation. Warehouse Online can also work with SOAP or an FTP server on your side.
- A conversion of your message from XML or CSV.
- A Translation of your message to the standardized message described in this document.
Data sent by Warehouse Online
As a result of performing the logistic processes, Warehouse Online will send stock updates to a standard sFTP environment hosted on ftp.realtime.eu. From there you can pull the data to your system. A Warehouse Online consultant will prepare an account for this environment and a folder for one or more of the following messages/files:
- After confirming a receipt on a purchase order, Warehouse Online will send a JSON delivery message.
- After confirming a shipment on a sales order, Warehouse Online will send a JSON shipment messages
- After every stock update that is not a receipt on a purchase order or a shipment on a sales order, Warehouse Online will send a JSON stock update message
- Every night Warehouse Online will send a full stock CSV file
You can find an example in these messages in this document
A Warehouse Online Consultant can prepare the following customizations if desired:
- A push mechanism instead of a pull mechanism. If your system can accept messages (REST, SOAP or on a FTP server) Warehouse Online can send the data.
- A conversion of your message to XML or CSV.
- A Translation of the message to a message that is specified by your system.