iManage Web Service
1(a). User Login:
GET['action'] = "getUserLogin"
POST['data'] = { "getUserLogin_data": { "userID":"test", "password":"12" } }
1(b). Test Connection (v2):
GET['action'] = "testConnection_v2"
POST['data'] = { "testConnectionv2_data": { "login_id":"67", "device_token":"asdsda" } }
2. Login:
GET['action'] = "getSalespersonCredential"
3. Product Details:
GET['action'] = "getStockQuantity"
POST['data'] = { "getStockQuantity_data": { "ProductID":123 } }
4. Order (OLD):
GET['action'] = "transferOrder"
POST['data'] = { "transferOrder_data": { "order_id":"order001", "order_date":"2014-04-02", "transfer_received_date":"2014-04-02", "total_discount":"1", "discount_method":"percent", "tax":"100.00", "shippingfee":"10", "grand_total":"20", "cust_id":"12", "cust_code":"1212", "cust_company_name":"michael", "cust_incharge_person":"johnathan", "cust_reference":"cusref0909", "cust_email":"some1@gmail.com", "cust_tel":"05-190909090", "cust_fax":"05-190909092", "billing_address1":"billing address 1", "billing_address2":"billing address 2", "billing_address3":"billing address 3", "billing_city":"petaling jaya", "billing_state":"persekutuan", "billing_zipcode":"22302", "billing_country":"malaysia", "shipping_address1":"shipping address 1", "shipping_address2":"shipping address 2", "shipping_address3":"shipping address 3", "shipping_city":"labuan", "shipping_state":"labuan", "shipping_zipcode":"12120", "shipping_country":"malaysia", "salesperson_id":"12", "order_status":"1", "payment_received_date":"2014-04-02", "order_remark":"this is remark", "Payment_received_by":"oracle", "OrderitemList":[{"order_id":"ref1234", "product_id":"12", "salesperson_remark":"new order", "quantity":"23", "unit_price":"12.50", "unit_uom":"meter", "uom_id":"1", "attribute_remark":"no remark", "optional_remark": "no remark", "discount_method":"no discount", "discount_amount":"0", "sub_total":"200", "sequence_no":"1"}, {"order_id":"ref2234", "product_id":"19", "salesperson_remark":"new order 2", "quantity":"23", "unit_price":"18.00", "unit_uom":"meter", "uom_id":"1", "attribute_remark":"no remark", "optional_remark": "no remark", "discount_method":"no discount", "discount_amount":"0", "sub_total":"200", "sequence_no":"2"}] } }
4. Order (New):
!!!! 6 September update: added cancel_status in transferOrder_data and OrderItemList !!!!
!!!! cancel_status = 0 => active, cancel_status = 1 => deleted/removed !!!!
GET['action'] = "transferOrder_v2"
POST['data'] = { "transferOrder_data": { "order_id":"order001", "order_date":"2017-08-09", "transfer_received_date":"2017-08-09",
"delivery_date":"2018-01-01"
, "total_discount":"0", "discount_method":" ", "tax":"0", "shippingfee":"0", "grand_total":"20","gst_amount":"20", "cust_id":"1", "cust_code":"SHDB", "cust_company_name":"michael", "cust_incharge_person":"johnathan", "cust_reference":"cusref0909", "cust_email":"some1@gmail.com", "cust_tel":"05-190909090", "cust_fax":"05-190909092", "billing_address1":"billing address 1", "billing_address2":"billing address 2", "billing_address3":"billing address 3", "billing_address4":"billing address 4", "billing_city":"petaling jaya", "billing_state":"persekutuan", "billing_zipcode":"22302", "billing_country":"malaysia", "shipping_address1":"shipping address 1", "shipping_address2":"shipping address 2", "shipping_address3":"shipping address 3","shipping_address4":"shipping address 4", "shipping_city":"labuan", "shipping_state":"labuan", "shipping_zipcode":"12120", "shipping_country":"malaysia","termcode":"CASH", "salesperson_id":"16", "order_status":"0", "order_remark":"this is remark", "order_delivery_note":"this is delivery note", "order_status_last_update_date":"2017-08-09","order_status_last_update_by":"salesagent", "cancel_status":"0","OrderitemList":[{"order_id":"order001", "product_id":"10","order_item_id":"1","product_code":"L 1100 ( A )","product_name":"NKRV 1100 LCD ( A )", "salesperson_remark":"new order", "quantity":"20", "unit_price":"12",
"disc_1":"40", "disc_2" : "10", "disc_3" : "20"
, "unit_uom":"meter", "uom_id":"1", "attribute_remark":"no remark", "optional_remark": "no remark", "discount_method":"no discount", "discount_amount":"0", "sub_total":"240", "sequence_no":"1", "cancel_status":"0"}, {"order_id":"order001", "product_id":"11","order_item_id":"2","product_code":"L 1100 ( O )","product_name":"NKRV 1100 LCD ( O )", "salesperson_remark":"new order 2", "quantity":"22", "unit_price":"18.00",
"disc_1":"40", "disc_2" : "50", "disc_3" : "50"
, "unit_uom":"meter", "uom_id":"1", "attribute_remark":"no remark", "optional_remark": "no remark", "discount_method":"no discount", "discount_amount":"0", "sub_total":"396", "sequence_no":"2","cancel_status":"0"},{"order_id":"order001", "product_id":"12","order_item_id":"3","product_code":"L 6260 ( O )","product_name":"NKRV 6260 LCD ( O )", "salesperson_remark":"new order 2", "quantity":"10", "unit_price":"10.00",
"disc_1":"50", "disc_2" : "50", "disc_3" : "50"
, "unit_uom":"meter", "uom_id":"1", "attribute_remark":"no remark", "optional_remark": "no remark", "discount_method":"no discount", "discount_amount":"0", "sub_total":"100", "sequence_no":"3", "cancel_status":"0"},{"order_id":"order001", "product_id":"13","order_item_id":"4","product_code":"L 1100F ( A )","product_name":"NKRV 1100 F/SET ", "salesperson_remark":"new order 2", "quantity":"10", "unit_price":"10.00",
"disc_1":"40", "disc_2" : "10", "disc_3" : "20"
, "unit_uom":"meter", "uom_id":"1", "attribute_remark":"no remark", "optional_remark": "no remark", "discount_method":"no discount", "discount_amount":"0", "sub_total":"100", "sequence_no":"4", "cancel_status":"0"}] } }
5. Order (Transferred): When salesperson search for order
GET['action'] = "searchTransferredOrder"
POST['data'] = { "searchTransferredOrder_data": { "salespersonid":"123", "created_start_date":"2014-04-02 00:00:00", "created_end_date":"2014-04-02 00:00:00", "customer_name":"nani", "order_status":"1" } }
6. Order (Transferred): When salesperson click on "Pay" button
GET['action'] = "editOrderPaymentDetails"
POST['data'] = { "editOrderPaymentDetails_data": { "salespersonid":"123", "orderId":"90" } }
7. Sync:
GET['action'] = "getLastUpdateDate"
POST['data'] = { "getLastUpdateDate_data": { "salespersonid":"123" } }
8. Sync (Customer):
GET['action'] = "getCustomerList"
POST['data'] = { "getCustomerList_data": { "salespersonid":"123", "date":"2017-08-08" } }
9. Sync (Product):
GET['action'] = "getProductList"
10. Sync (Back up selling price):
GET['action'] = "insertSellingPrice"
Insertion v1
POST['data'] = { "insertSellingPrice_data": { "lastSellingPriceList":[{"salesperson_id":"12", "product_id":"100", "product_unit_price":"20",
"product_disc_1":"40", "product_disc_2" : "10", "product_disc_3" : "20"
, "uom_id":"5", "cust_id":"10","quantity":"5", "discount":"10", "discount_method":"percenttype","last_selling_date":"2017-10-14"}, {"salesperson_id":"19", "product_id":"10", "product_unit_price":"90",
"product_disc_1":"50", "product_disc_2" : "50", "product_disc_3" : "50"
, "uom_id":"3", "cust_id":"10", "quantity":"6","discount":"15", "discount_method":"percenttype","last_selling_date":"2017-10-14"}] } }
Insertion v2
POST['data'] = { "insertSellingPrice_data": { "lastSellingPriceList":[{"salesperson_id":"12", "product_code":"100", "product_unit_price":"20",
"product_disc_1":"40", "product_disc_2" : "10", "product_disc_3" : "20"
, "unit_uom":"5", "cust_code":"10","quantity":"5", "discount":"10", "discount_method":"percenttype","last_selling_date":"2017-10-14"}, {"salesperson_id":"19", "product_code":"10", "product_unit_price":"90",
"product_disc_1":"50", "product_disc_2" : "50", "product_disc_3" : "50"
, "unit_uom":"3", "cust_code":"10", "quantity":"6","discount":"15", "discount_method":"percenttype","last_selling_date":"2017-10-14"}] } }
11. Sync (Restore selling price):
GET['action'] = "getSellingPrice"
POST['data'] = { "getSellingPrice_data": { "salespersonid":"123" } }
12. Sync (General Info):
GET['action'] = "getGeneralInfo"
13. Sync (SalesPersonCustomer):
GET['action'] = "getSalesPersonCustomerlist"
POST['data'] = { "getSalesPersonCustomerlist_data": { "salespersonid":"123", "date":"2017-08-08" } }
14. Get All Category:
GET['action'] = "getAllCategory"
POST['data'] = { "date":"2017-08-08" }
15. Get All Product:
GET['action'] = "getAllProduct"
POST['data'] = { "date":"2017-08-08" }
16. Get All Product Attribute:
GET['action'] = "getAllProductAttribute"
17. Get All Product Image:
GET['action'] = "getAllProductImage"
POST['data'] = { "date":"2017-08-08" }
17A. Get All Product Image By Batch:
GET['action'] = "getProductImageByBatch"
POST['data'] = { "date":"2017-08-08", "start":"0", "size":"100" }
18. Get All Product Optional Item:
GET['action'] = "getAllProductOptionalItem"
19. Get All Product UOM Price:
GET['action'] = "getAllProductUOMPrice"
POST['data'] = { "date":"2017-08-08" }
20. Get All UOM:
GET['action'] = "getAllUOM"
POST['data'] = { "date":"2017-08-08" }
20b. Get All Special Price:
GET['action'] = "getAllSpecialPrice"
POST['data'] = { "date":"2017-08-08" }
21. Get All Optional Item:
GET['action'] = "getAllOptionalItem"
22. Get All Document:
GET['action'] = "getAllDocument"
23. Get All Video:
GET['action'] = "getAllVideo"
24. Get All Order Status:
GET['action'] = "getAllOrderStatus"
25. Change order status
GET['action'] = "changeOrderStatus"
POST['data'] = { "changeOrderStatus_data": { "salespersonid":"123", "order_status":"1", "others_order_status":"sample text here", "orderId":"90" } }
26. Get All Journal:
GET['action'] = "getAllJournal"
POST['data'] = { "date":"2017-08-08", "salespersonId":"67" }
27. Get All Receipt:
GET['action'] = "getAllReceipt"
POST['data'] = { "date":"2017-08-08", "salespersonId":"67" }
28(a). Get All Invoice:
GET['action'] = "getAllInvoice"
POST['data'] = { "date":"2017-08-08", "salespersonId":"67" }
28(b). Get All Credit Note:
GET['action'] = "getAllCreditNote"
POST['data'] = { "date":"2017-08-08", "salespersonId":"67" }
28(c). Get All Debit Note:
GET['action'] = "getAllDebitNote"
POST['data'] = { "date":"2017-08-08", "salespersonId":"67" }
29. Get Orderpage by ios:
GET['action'] = "iosOrderPage"
POST['data'] = { "iosOrderPage_data": { "salespersonid":"123" } }
30.Send request to boss for lower price:
GET['action'] = "requestBossPrice"
POST['data'] = { "requestBossPrice_data": { "salesperson_id":"16", "customer_id":"1", "device_token":"hmng", "product_code":"LCD", "min_price":"6.00", "asking_price":"5.00" } }
31. Upload File:
GET['action'] = "uploadExcel"
Product Import File
:
Zip image File
:
You are required to upload product images with zip [extension .zip]
Please note the product images must be allocated at root folder of the zip which means it shouldn't include any subfolder in the zip.
Maximum allowed product image width is 1000.
Maximum allowed product image height is 1300.
submit
32. request mobile setting:
GET['action'] = "requestMobileSetting"
33. Get no stock page by ios:
GET['action'] = "iosNoStockPage"
POST['data'] = { "iosNoStockPage_data": { "salespersonid":"123" } }
34. Get no stock notification by ios:
GET['action'] = "getNoStockNotification"
POST['data'] = { "getNoStockNotification_data": { "salespersonid":"123" } }
35. Get owed quantity:
GET['action'] = "getOwedQuantitylist"
POST['data'] = { "getOwedQuantitylist_data": { "salespersonId":"123" } }
36. ConfirmTransferMultipleOrder:
GET['action'] = "ConfirmTransferMultipleOrder"
POST['data'] = { "ConfirmTransferMultipleOrder_data": { "OrderList":[{"order_id":"order1001"}, {"order_id":"order1002"}] } }
37. Get Product Current Count:
GET['action'] = "getAvailableProductQuantity"
POST['data'] = { "getAvailableProductQuantity_data": { "productCodeList":[{ "code":"P-SKI-FZ-DFP-12.5X12.5-PCS" },{ "code":"P-1000-IQF-100/200-0.8" }] } }
38. Get Product Current Count:
GET['action'] = "getProductGroup"
POST['data'] = { "date":"2017-08-08" }
39. Get Product Current Count:
GET['action'] = "getProductGroupAdv"
POST['data'] = { "date":"2017-08-08" }
40. Get Product Last selling price:
GET['action'] = "getProductLastSellingPrice"
POST['data'] = { "getProductLastSellingPrice_data": { "custCode":"700-B163", "productCode":"PWI E700" } }
41. Get Salesperson Customer Branch:
GET['action'] = "getCustomerBranchList"
POST['data'] = { "getCustomerBranchList_data": { "salesperson_id":"155" } }
42. Get Salesperson CustomerList by Branch Id:
GET['action'] = "getCustomerListByBranchId"
POST['data'] = { "getCustomerListByBranchId_data": [ { "cust_id":"42578" }, { "cust_id":"46501" } ] }
43. Get Product Special Price:
GET['action'] = "getSpecialPriceByBatch"
POST['data'] = { "date":"2017-08-08", "start":"0", "size":"10000" }
44. Get Product by Batch:
GET['action'] = "getProductByBatch"
POST['data'] = { "date":"2017-08-08", "start":"0", "size":"10000" }
45. Get Product UOM by Batch:
GET['action'] = "getProductUOMbyBatch"
POST['data'] = { "date":"2017-08-08", "start":"0", "size":"10000" }
45. Get PUP by Batch:
GET['action'] = "getPUPbyBatch"
POST['data'] = { "date":"2017-08-08", "start":"0", "size":"10000" }
46. Get Package By Batch:
GET['action'] = "getPackageByBatch"
POST['data'] = { "date":"2017-08-08", "start":"0", "size":"10000" }
47. Get Outstanding SO:
GET['action'] = "getOutstandingSO"
POST['data'] = { "date":"2017-08-08", "salesperson_id":"67" }
48. Get Warehouse:
GET['action'] = "getWarehouse"
49. Get Warehouse Stock:
GET['action'] = "getWarehouseStock"
POST['data'] = { "date":"2017-08-08", "start":"0", "size":"10000" }