Purpose
Upload Order details into OmniRPS using API to enable customers to create returns via the Seko OmniReturns Portal
Rest API
OmniRPS uses REST API for data transmission. REST (Representational State Transfer) API is a simple stateless architecture that runs over the internet. RESTful applications use HTTP requests to create, read, update or delete data.
JSON
OmniRPS uses JSON due to its simplicity and human readable data format. JSON (JavaScript Object Notation) is a way to store information in an organized, easy-to- access manner.
Field Types
Varchar – A varchar field is a field type used for textual characters.
Boolean – A Boolean field is a field type used for truth values. E.g. true, false .
Integer – An Integer field is a field type used for numbers. E.g. an amount.
Authentication
All HTTP requests will require token key. The key needs to be declared as the HTTP Request Header.
The access key will be provided by OmniRPS on request.
Please ensure that the key is not hardcoded into the system.
Parameters of API
Parameter | Mandatory | Type | Description |
---|---|---|---|
OrderNumber | Y | Varchar | Order number |
SKU | Y | Varchar | Item Sku code |
Quantity | Y | Integer | Quantity |
StyleNumber | Y | Varchar | Item Style number/ code |
Category | Optional | Varchar | Item category |
SubCategory | Optional | Varchar | Item sub category |
EAN | Y | Varchar | Item number |
ProductName | Y | Varchar | Product name |
ItemValue | Y | Varchar | Product price |
Currency | Y | Varchar | Currency code |
ItemWeight | - | Varchar | If order weight is empty then item weight required. Weight should be in Kg. |
OrderWeight | - | Varchar | If item weight empty then order weight required. Weight should be in Kg. |
CommodityCode | Optional | Varchar | Commodity code |
ProductCountryOfOrigin | Y | Varchar | |
Town | Optional | Varchar | Town address |
CommodityName | Optional | Varchar | |
CommodityShortName | Optional | Varchar | |
CommodityShortName | Optional | Varchar | |
CustomerName | Y | Varchar | Customer name |
CustomerEmail | Y | Varchar | Email address |
Building | Y | Varchar | Customer Building name |
Street | Y | Varchar | Customer Street address |
Suburb | Y | Varchar | Customer suburb / City. No short code. For Example add NEW YORK and not NY. |
State | Y | Varchar | Customer state. No short code. For Example add NEW YORK and not NY. |
Town | Optional | Varchar | Town address |
DeliveryPostcode | Y | Varchar | Order delivery date. Five digits for USA. For other country it is flexible. |
DeliveryCountry | Y | Varchar | Customer country |
DateDespatched | Y | Datetime | Order date |
Returnable | Optional | Varchar | Flag “Y” / “N” which provide information about the item is returnable or not and to stop the user to send unreturnable items. Default value is “Y” if not provided. |
SKUImage | Optional | Text | https:// Live URL of the product image. For example https://cdn.xl.thumbs.canstockphoto.com/sample- rubber-stamp-with-word-sample-inside-vector- illustration-image_csp27057271.jpg |
SupplierName | Optional | Varchar | Product Supplier name. |
API Request
Requires Authentication
A valid access token must be provided in token request header. Token will be provided by RPS on request to use the API.
Example Request
Request :
https://www.omnirps.com/app/ftp_return/add_ftp_order_details
Headers :
Token: [access_key_for_site_account] Content-Type:application/json charset:utf-8
Request Body :
[ { "OrderNumber": "12", "CustomerEmail": "customer1@gmail.com", "CustomerName": "customer1 ", "DeliveryCountry": "New Zealand", "Building": "6 Purser", "Street": "WELLINGTON", "Suburb": "WELLINGTON CENTRAL", "State": "WELLINGTON", "SKU": "S000450-mocha-10(M)", "Quantity": "1", "StyleNumber": "S000450-mocha-10(M)", "Category": "Clothes", "SubCategory": "Pants & Leggings", "EAN": "123EAN", "ProductName": "Make A Move Tights in Mocha", "ItemWeight": "0.5", "ItemValue": "45", "OrderWeight": "0.5", "TotalGBP": "45", "Currency": "AUD", "CommodityCode": "AA", "ProductCountryOfOrigin": "US", "CommodityName": "APPAREL", "CommodityShortName": "NOT APPLICABLE", "Town": "6 Purser", "DeliveryPostcode": "6011", "DateDespatched": "2018-06-02 16:04:32", "Returnable": "Y", "SKUImage": "https://cdn.xl.thumbs.canstockphoto.com/sample-rubber-stamp- with-word-sample-inside-vector-illustration-image_csp27057271.jpg", "SupplierName": "XYZ" }, { "OrderNumber": "13", "CustomerEmail": "customer2@gmail.com", "CustomerName": "customer2 ", "DeliveryCountry": "New Zealand", "Building": "6 Purser", "Street": "WELLINGTON", "Suburb": "WELLINGTON CENTRAL", "State": "WELLINGTON", "SKU": "S000450-mocha-10(M)", "Quantity": "1", "StyleNumber": "S000450-mocha-10(M)", "Category": "Clothes", "SubCategory": "Pants & Leggings", "EAN": "123EAN", "ProductName": "Make A Move Tights in Mocha", "ItemWeight": "0.5", "ItemValue": "45", "OrderWeight": "0.5", "TotalGBP": "45", "Currency": "AUD", "CommodityCode": "AA", "ProductCountryOfOrigin": "US", "CommodityName": "APPAREL", "CommodityShortName": "NOT APPLICABLE", "Town": "6 Purser", "DeliveryPostcode": "6011", "DateDespatched": "2018-06-02 16:04:32", "Returnable": "N", "SKUImage": "https://cdn.xl.thumbs.canstockphoto.com/sample-rubber-stamp- with-word-sample-inside-vector-illustration-image_csp27057271.jpg", "SupplierName": "ABC" } ]
Response:
Success
{ "SUCCESS": "TRUE", "MESSAGE": "Updated Successfully.", "RESPONSE": { "OrderNumber - 12": "Inserted successfully", "OrderNumber - 13": "Inserted successfully" } }
Failure Example
{ "SUCCESS": "FALSE", "MESSAGE": "Invalid Token" }
Other Error Messages
Invalid Token
Token is required
Failed to add order details
Field required/invalid ‘field name 1’.
Invalid JSON
Revision History
CURRENT VERSION :
Date
Version Number : By Whom
Description of change in that version.
20-May-2019
Ver : 4.0 By KT
Add Supplier name into Order upload.
04-March-2019
Ver : 3.0 By KT
Product Image added to sample FTP file and the effect of that on OmniReturns.
18-Dec-2018
Ver : 2.0 By KT
Add Returnable Flag field with order.
03-July-2018
Ver : 1.0 By RK
Initial Scope