MES

上传[物料]信息excel

52--81

http://192.168.124.52:8081/v2/api

POST

/materials-lists/upload-excel

请求参数

Header 参数

Authorization

string

可选

默认值:

eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1dWlkIjoiZWNkYTRiNmMyYTkzNDA0YTlmNmNkM2JhN2JhMWEyZTQiLCJleHAiOjE3MTU5MTM3Mzl9.YR3nVaehMh4RKFYul_Lr3plAGk-jVPxMkhbeeZ6jgR4

Body 参数multipart/form-data

file

物料批量上传的文件

可选

示例值:

cmMtdXBsb2FkLTE3MDU0ODIzMDM0NDgtMg==/物料批量上传.xlsx

示例代码

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

integer

必需

message

string

必需

data

array [object {11}]

必需

materials_unit

string

物料单位

必需

materials_color_number

string

物料色号

必需

materials_type

string

物料型号

必需

materials_sn

string

物料编号

必需

materials_spec

string

物料规格

必需

remark

string

备注

必需

category

string

类别

必需

materials_name

string

物料名字

必需

materials_color

string

物料颜色

必需

rowId

integer

行号

必需

vendor_name

string

供应商名字

必需

示例

{
    "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

批量增加[物料]

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