接口名称tt.oapi.item.list.data.query.get接口说明查询料件列表资料程序代号soap_oapi00014输入参数说明参数代号型态是否必填参数说明范例值requestkeystring是检核编码(MD5)109c3c41a1441e702b909ed3de58e4b1typestring是Request类型(sync,async)固定传入synchostprodstring是发起方产品名称OAPIverstring是发起方产品版本1.0ipstring是发起方IP位置10.40.71.91idstring否发起方产品识别码，提供同一产品多台主机辨别之用acctstring是登入帐号固定传入tiptoptimestampstring是时间戳记格式：yyyyMMddHHmmssSSS20151211123204361timezonestring否发起方时区(-12~+14)+8langstring是语言别(zh_TW,zh_CN,en,vi)zh_CNserviceprodstring是接收方产品名称TIPTOPnamestring是服务名称tt.oapi.item.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号CompanyIdstring否营运据点sequencestring否条件顺序field_namestring否字段名称参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业编号不使用site_nostring否营运中心不使用is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmss20230615121059imadatekey_conditionstring否前次最后一笔资料的Key条件KEY1='04226P01'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，50默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制page_nonumeric否页码2item_nostring是产品编号支持模糊查询(输入不完整编号可查)P01ima01item_namestring否产品名称支持模糊查询(输入不完整名称可查)厂内ima021products_typestring否品类ima131item_sortstring是料件类别Pima08main_group_codestring是主分群码01303-Aima06storage_staff_nostring否仓管员00005ima23storage_staff_namestring否仓管员姓名不使用purchaser_codestring否采购员00008ima43purchaser_namestring否采购员姓名不使用date_sstring是开始日期格式：yyyyMMdd20230601imadatedate_estring是结束日期格式：yyyyMMdd20230630imadateconditions—否条件集合(单头节点，支持多数组)sequencestring否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称imadatevaluestring否字段值20230601operatorstring否操作符>、>=、=、<、<=、like、in、<>>logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring否字段名称ima01order_typestring否排序类型asc：升序desc：降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:6a41d75a1fa1a119a90b1821ee85352fdigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"TIPTOP","name":"tt.oapi.item.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","sequence":"条件顺序","field_name":"字段名称"}{"std_data":{"parameter":{"enterprise_no":"企业别","site_no":"营运中心","is_digiwin_product":"是否为鼎捷产品","data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","use_has_next":"是否启用分页机制","page_size":"每页条数/分包的请求笔数","page_no":"页码","item_no":"产品编号","item_name":"产品名称","products_type":"品类","item_sort":"料件类别","main_group_code":"主分群码","storage_staff_no":"仓管员","storage_staff_name":"仓管员姓名","purchaser_code":"采购员","purchaser_name":"采购员姓名","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"条件顺序","bracket":"括号类型","field_name":"字段名称","value":"字段值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"字段名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000datakeyitem_nostring是产品编号04226P01ima01参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述执行成功！data_timedate是异动时间格式：yyyyMMddHHmmss20230615121059imadatekey_conditionstring是前次最后一笔资料的Key条件KEY1='04226P01'total_resultsnumeric否总数135has_nextboolean否是否有下一页true：是false：否trueitem—是品号(单头节点，支持多数组)item_nostring是产品编号04226P01ima01item_namestring否产品名称厂内v2.0原料1(批条)ima02item_specstring否规格P01ima021unit_nostring否发料单位PCSima63unit_namestring否单位说明件gfe02item_sortstring否料件类别C:规格组件T:最后规格料件D:特性料件A:族群料件M:自制料件P:采购料件X:虚拟料件K:配件虚拟料件U:自制大宗料件V:采购大宗料件R:在制途料件Z:杂项料件S:厂外加工料件Pima08main_group_codestring否主分群码01303-Aima06main_group_namestring否主分群码说明成品imz02feature_groupstring否特征群组不使用feature_group_namestring否群组说明不使用products_typestring否品类002ima131products_type_namedate否品类说明不使用life_cyclestring否生命周期不使用statusstring否状态码0：开立1：审核1ima1010Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:3a1d3fdb-7485-4f86-b559-948464c0a44adigi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"item_no":"产品编号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","item_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"item":[{"item_no":"产品编号","item_name":"产品名称","item_spec":"规格","unit_no":"基础单位","unit_name":"基础单位","item_sort":"料件类别","main_group_code":"主分群码","main_group_name":"主分群码说明","feature_group":"特征群组","feature_group_name":"群组说明","products_type":"品类","products_type_name":"品类说明","life_cycle":"生命周期","status":"状态码"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）anm-03078sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述[TIPTOP_message]查询无数据！Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:3a1d3fdb-7485-4f86-b559-948464c0a44adigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
