上传[物料]信息excel

52--81

http://192.168.124.52:8081/v2/api

POST

/materials-lists/upload-excel

请求参数

Header 参数

Body 参数multipart/form-data

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'http://192.168.124.52:8081/v2/api/materials-lists/upload-excel' \
--header 'Authorization: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1dWlkIjoiZWNkYTRiNmMyYTkzNDA0YTlmNmNkM2JhN2JhMWEyZTQiLCJleHAiOjE3MTU5MTM3Mzl9.YR3nVaehMh4RKFYul_Lr3plAGk-jVPxMkhbeeZ6jgR4' \
--form 'file=@"cmMtdXBsb2FkLTE3MDU0ODIzMDM0NDgtMg==/物料批量上传.xlsx"'

返回响应

🟢200成功

application/json

Body

示例

{
    "code": 20000,
    "message": "读取excel成功",
    "data": [
        {
            "materials_unit": "个",
            "materials_color_number": "明黄",
            "materials_type": "22a",
            "materials_sn": "1212",
            "materials_spec": "12mm",
            "remark": "螺丝粉专用",
            "category": "螺丝",
            "materials_name": "螺丝123",
            "materials_color": "何乌昂黄色",
            "rowId": 1
        },
        {
            "materials_unit": "个",
            "materials_color_number": "超红",
            "materials_type": "33a",
            "materials_sn": "4855",
            "materials_spec": "18mm",
            "remark": "吃螺丝粉的工具",
            "category": "螺丝",
            "materials_name": "螺丝刀",
            "materials_color": "东方红",
            "rowId": 2
        }
    ]
}

修改于 2024-01-17 09:11:26

批量增加[物料]

分页和条件查询物料信息（不带位置）