--- title: Web Ordering 2.0 API Documentation tags: Web Ordering 2.0 API Documentation description: API Documentation --- ![](https://i.imgur.com/jEIPfP4.png) <div style="text-align: center; font-size: 35px"> WEB ORDERING API Documentation </div> --- # Copyright Information **Maxs Group Inc - IT Application Development**<br> 3rd Floor KDC Plaza Building<br> Chino Roces Avenue. Makati City, 1231<br> Email: appdev@maxsgroupinc.com --- # Confidentiality and Usage <div style="text-align: justify">The information contained in this document (and any attachments) is a confidential information provided by MGI IT - Application Development. This document is intended only for use by merchants approved by MGI.<br><br> Any copying, distribution or dissemination of this document by any other parties is prohibited.</div> --- # Revision History | Revision | Date | Revision Description | | -------- | --------------- | -------------------- | | 0.0 | August 01, 2022 | Final Draft | | 1.0 | September 18, 2022|Initial Release | | 1.1 | September 23, 2022| Tempo DR Revision| --- <!-- # API Documentation - <span style="color:red">API Key provided in email</span> --> # API ## WEB ORDER 2.0 API ### Temporary Delivery Receipt <p>This API is used to process and download word document.</p> For commissary list definition > See full list [here](https://hackmd.io/pa3z7pZmQDmbjYKBBC-IXQ?view#Data-Parameter-Definitions). - DEVELOPMENT https://9sda584osh.execute-api.ap-southeast-1.amazonaws.com/development/report-export-word - PRODUCTION https://9sda584osh.execute-api.ap-southeast-1.amazonaws.com/production/report-export-word --- | **FUNCTION** | Web ordering export word | | -------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **METHOD** | POST | | **HTTP HEADERS** | Content-Type: application/json<br> x-api-key: {<span style="color:red">*Note: API key to be sent separately*</span>}| | **DATA PARAMS** | ```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```erp_org_id_num:"",``` <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```delivery_date_from:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```delivery_date_to:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```report_name:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```filter_params:""```<br>```}``` | | **DATA DEFINITION** | <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```erp_org_id_num:" ERP ORG CODE",``` <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```delivery_date_from:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```delivery_date_to:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```report_name:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```filter_params:""```<br> | | **SUCCESS RESPONSE** | Status: 200<br>Sample Response Body:<br>```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"code": 200,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"message":"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"data":{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```customer_name: "",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```erp_org_code:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```promise_time:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```item_code:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```item_name:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```quantity:""```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```}```<br>&nbsp;```}``` | | **ERROR RESPONSE** | Status: 69<br>Sample Response Body:<br>```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"code": 69,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"message":"“No store available." ,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"data":{}```<br>```}``` | ### Order Summary Report per Store and per Item <p>This API is used to extract excel store orders summary report per store.</p> For brand list definition > See full list [here](https://hackmd.io/pa3z7pZmQDmbjYKBBC-IXQ?view#Data-Parameter-Definitions). - DEVELOPMENT https://9sda584osh.execute-api.ap-southeast-1.amazonaws.com/development/report-export - PRODUCTION https://9sda584osh.execute-api.ap-southeast-1.amazonaws.com/production/report-export --- | **FUNCTION** | mgi-web-ordering | | -------------------- |:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **METHOD** | POST | | **HTTP HEADERS** | Content-Type: application/json<br> x-api-key: {<span style="color:red">*Note: API key to be sent separately*</span>} | | **DATA PARAMS** | ```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```commi_id:"",``` <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```delivery_date_from:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```delivery_date_to:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```comminame:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```reporttype:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```order_type_id:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>```}``` | | **DATA DEFINITION** | ```commi_id:" ERP ORG CODE",```<br>```comminame:" REPORT NAME",```<br>```delivery_date_from:" Delivery Date",```<br> ```delivery_date_to:" Delivery Date ",```<br>```reporttype:" order_summary_store",```<br> ```order_type_id:" order class",```<br> | | **SUCCESS RESPONSE** | Status: 200<br>Sample Response Body:<br>```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"code": 200,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"message": "Extracted Successfully ",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;``` "data":{} ```<br>&nbsp;```}``` | | **ERROR RESPONSE** | Status: 69<br>Sample Response Body:<br>```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"code": 69,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"message":" No data available." ,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"data":{}```<br>```}``` | --- ### Auto Allocation Import Data <p>This API is used to extract excel store orders summary report per Item.</p> For commissary list and order class definitions > See full list [here](https://hackmd.io/pa3z7pZmQDmbjYKBBC-IXQ?view#Data-Parameter-Definitions). - DEVELOPMENT https://9sda584osh.execute-api.ap-southeast-1.amazonaws.com/development/order-imports - PRODUCTION https://9sda584osh.execute-api.ap-southeast-1.amazonaws.com/production/order-imports --- | **FUNCTION** | mgi-web-ordering-import-items | | -------------------- |:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **METHOD** | POST | | **HTTP HEADERS** | Content-Type: application/json<br> x-api-key: {<span style="color:red">*Note: API key to be sent separately*</span>} | | **DATA PARAMS** | ```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```operation:"",``` <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```tableName:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```headerid:"",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```payload:""```<br>```}``` | | **DATA DEFINITION** | &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```operation:"CREATE",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```tableName:"orders_items_auto_allocate_tmp",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```headerid:" HEADER ID",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```payload:" EXCEL DATA ARRAY"```<br> | **SUCCESS RESPONSE** | Status: 200<br>Sample Response Body:<br>```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"code": 200,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"message": "Upload Successfully ",```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;``` "data":{} ```<br>&nbsp;```}``` | | **ERROR RESPONSE** | Status: 69<br>Sample Response Body:<br>```{```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"code": 69,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"message":" Upload Unsuccessful." ,```<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;```"data":{}```<br>```}``` | |