Warehouses

Base Url: /smartfin/api/v1/wh

Retrieve Warehouse’s Data

POST /smartfin/api/v1/whitelist/select

Retrieve all of the warehouse’s data under the current user

Authentication / Authorization

API Key

Headers

Schema

Headers:

Content-Type: application/json

Authorization：

string - JWT <<YOUR_API_KEY_HERE>> (required)

Request

Example:

JSON Body:

{}

Response

Example:

{
    "error_code": 0,
    "value": {
        "whs": [
            {
                "wh_id": 174,
                "wh_name": "JIJI",
                "update_time": null,
                "update_by": null,
                "create_by": 2,
                "create_time": "2023-11-01 11:50:35",
                "user_id": null,
                "wh_entity": "KIKIK",
                "wh_add": "OOOO",
                "company_id": 119,
                "c_name": "test2",
                "u_name": null
            },
            {
                "wh_id": 165,
                "wh_name": "2",
                "update_time": "2023-08-23 14:31:04",
                "update_by": 65,
                "create_by": 2,
                "create_time": "2023-08-23 14:07:39",
                "user_id": 65,
                "wh_entity": "KKK1",
                "wh_add": "KKK",
                "company_id": 119,
                "c_name": "test2",
                "u_name": "Careers"
            },
        ],
        "dropdown_list": {
            "wh_entity": [
                "KKK1",
                "\u4e2d\u50a8\u65b0\u6e2f",
                "MARK",
                "WAREHOUSE",
                "CAR",
                "KIKIK",
                "TEST",
                "CAR1",
                "4",
                "SALESX",
                "NEW E",
                "LOLOLO1",
                "XX",
                "2",
                "\u5170\u8003\u660c\u76db",
                "DGG",
                "1",
                "HAHA",
                "SALES",
                "34",
                "MARKS",
                "BUY ENTITY",
                "ADMIN",
                "MARKX",
                "KKK"
            ],
            "wh_name": [
                "\u4e2d\u50a8\u65b0\u6e2f",
                "54546",
                "MARK",
                "WAREHOUSE",
                "CAR",
                "NEW NAME",
                "TEST",
                "CAR1",
                "55",
                "4",
                "SALESX",
                "\u9752\u5c9b\u6e2f-\u7eac\u56db\u8def",
                "XX",
                "222",
                "2",
                "\u5170\u8003\u660c\u76db",
                "BUY NAME",
                "1",
                "HAHA",
                "SALES",
                "JIJI",
                "MARKS",
                "MARKX",
                "ADMIN",
                "KKK"
            ],
            "validation": []
        }
    }
}

Schema

whs - array[object]

An array of object that contains warehouse’s data

update_time, u_name, update_by - string

Information about last updated time for the data and the user who updating the data.

create_time, c_name, create_by - string

Information about created time for the data and the user who creating the data.

user_id, wh_id, company_id - integer

user_id - User Id ( who the data belongs to)
entity_id - A unique ID assigned to the data. This ID can be used to retrieve warehouse data.
company_id - The main company Id for the data.

wh_name, wh_entity, wh_add - string

wh_name - Warehouse name
wh_entity - Warehouse Entity
wh_add - Warehouse address

wh_name , wh_entity and wh_add cannot be duplicated,

Eg. wh_name of ‘WAREHOUSE' , wh_entity of ‘ENTITY’ wh_add of 'ADDRESS’ will not allow to be stored if the same wh_name , wh_entity and wh_add has been created in database.

validation - array[string]

a list of validation that been used to indicate the list that is not able to add a new value (it is empty, all of the lists are able to update and add a new value)

Warehouses - Upsert ( Update/ Insert )

Update/insert warehouse

Inserts/Update warehouse

Request

URL:

{basePath}/upsert

Method:

POST

Headers:

Content-Type: application/json

Authorization：

JWT { token }

JSON Body:

insert_list: warehouse/s to be inserted

[
  {
         "wh_name":"MARK",
         "wh_entity":"TEST1",
         "wh_add":"TEST_ADDRESS",
         "company_id":119
  }
]

update_list: warehouse/s to be updated

[
  {
         "wh_id":174,
         "wh_name":"WH_NAME",
         "wh_entity":"TEST2",
         "wh_add":"TESTADD1",
         "company_id":119
  }
]

Response

{
    "error_code": 0,
    "value": {
        "whs": [
            {
                "wh_id": 176,
                "wh_name": "MARK",
                "update_time": null,
                "update_by": null,
                "create_by": 2,
                "create_time": "2023-11-02 11:57:10",
                "user_id": null,
                "wh_entity": "TEST1",
                "wh_add": "TEST_ADDRESS",
                "company_id": 119,
                "c_name": "test2",
                "u_name": null
            },
            {
                "wh_id": 174,
                "wh_name": "WH_NAME",
                "update_time": "2023-11-02 11:57:10",
                "update_by": 2,
                "create_by": 2,
                "create_time": "2023-11-01 11:50:35",
                "user_id": 2,
                "wh_entity": "TEST2",
                "wh_add": "TESTADD1",
                "company_id": 119,
                "c_name": "test2",
                "u_name": "test2"
            },
        ],
        "dropdown_list": {
            "wh_entity": [
                "KKK1",
                "\u4e2d\u50a8\u65b0\u6e2f",
                "MARK",
                "WAREHOUSE",
                "CAR",
                "TEST",
                "CAR1",
                "4",
                "SALESX",
                "NEW E",
                "LOLOLO1",
                "XX",
                "TEST1",
                "2",
                "\u5170\u8003\u660c\u76db",
                "DGG",
                "1",
                "HAHA",
                "SALES",
                "34",
                "TEST2",
                "MARKS",
                "BUY ENTITY",
                "ADMIN",
                "MARKX",
                "KKK"
            ],
            "wh_name": [
                "\u4e2d\u50a8\u65b0\u6e2f",
                "54546",
                "MARK",
                "WAREHOUSE",
                "CAR",
                "NEW NAME",
                "WH_NAME",
                "TEST",
                "CAR1",
                "55",
                "4",
                "SALESX",
                "\u9752\u5c9b\u6e2f-\u7eac\u56db\u8def",
                "XX",
                "222",
                "2",
                "\u5170\u8003\u660c\u76db",
                "BUY NAME",
                "1",
                "HAHA",
                "SALES",
                "MARKS",
                "MARKX",
                "ADMIN",
                "KKK"
            ],
            "validation": []
        }
  }

Notes

The returned response format are the same as Warehouses - Post response format.

Insert and Update would fail if there is an existing warehouse/s with the same wh_name, wh_entity or same wh_name

Warehouses - Delete

Delete company

Deletes single/ multiple warehouse by id

Request

URL:

{basePath}/delete

Method:

DELETE

Headers:

Content-Type: application/json

Authorization：

JWT { token }

JSON Body:

del_ids: list of ids to be deleted

[109]

Response

// Same format as {basePath}/wh/select response body

Notes

The returned response format are the same as Warehouses - Post response format.